Copying to tmp table | SELECT p.ID, p.post_title, p.post_date, p.comment_count, count(t_r.object_id) as cnt FROM wp_term_taxonomy t_t, wp_term_relationships t_r, wp_posts p WHERE t_t.taxonomy ='post_tag' AND t_t.term_taxonomy_id = t_r.term_taxonomy_id AND t_r.object_id = p.ID AND (t_t.term_id IN ('2312', '7211', '4999', '102', '101', '1444', '98', '579', '2587', '6266', '21', '1498', '2886', '6269', '6268', '3015', '6769', '6766', '6267', '3591', '169', '3889', '1525', '3738', '49', '603', '7210', '6271', '6272', '6270', '7212', '6327', '')) AND p.ID != 23835 AND p.post_status = 'publish' AND p.post_date_gmt < '2010-09-25 21:10:32' GROUP BY t_r.object_id ORDER BY cnt DESC, p.post_date_gmt DESC LIMIT 10 |