SELECT t.tag_id, t.tag, t.raw_tag, a.post_id, a.blog_id, COUNT( a.post_id ) AS numpost
FROM bbMutag_tag AS t, bbMutag_tagged AS a
INNER JOIN wp_1_posts AS p ON a.post_id = p.id
WHERE (
p.post_status = 'publish'
OR p.post_status = 'static'
)
AND p.post_date_gmt <= '2007-05-07 13:59:30'
WHERE t.tag_id = a.tag_id
AND a.blog_id =
GROUP BY t.tag
ORDER BY numpost DESC