SELECT SQL_CALC_FOUND_ROWS wp_posts.ID FROM wp_posts INNER JOIN wp_term_relationships ON (wp_posts.ID = wp_term_relationships.object_id) LEFT JOIN wp_postmeta as wpMeta ON wp_posts.ID = wpMeta.post_id AND wpMeta.meta_key LIKE 'likes' WHERE 1=1 AND ( wp_term_relationships.term_taxonomy_id IN (312) ) AND wp_posts.post_type IN ('thumbs', 'post') AND (wp_posts.post_status = 'publish') AND post_date > '2012-05-19' GROUP BY wp_posts.ID ORDER BY comment_count DESC, SUM( ( (SELECT SUM(wpMeta2.meta_value + 0) FROM wp_postmeta AS wpMeta2 WHERE wpMeta2.meta_key LIKE 'likes' AND wp_posts.ID = wpMeta2.post_id GROUP BY wpMeta2.post_id) * 2 ) - (wpMeta.meta_value + 0)) DESC LIMIT 0, 12