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 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-26' AND wpMeta.meta_key LIKE 'votes' GROUP BY wp_posts.ID ORDER BY 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
