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 (149,150,158,237,257,259,280,282,283,292,312,354,359,360,414,490,996) ) AND wp_posts.post_type IN ('thumbs', 'post') AND (wp_posts.post_status = 'publish') AND post_date > '2013-04-23' 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
