Working...
invalid query: Table 'blogscanner.hashtag_posts90' doesn't existSELECT blog_id, url,
SUM(post_counter) AS post_counter,
SUM(comment_counter) AS comment_counter,
SUM(post_counter + comment_counter) AS post_comment_counter
FROM hashtags, hashtag_posts90, blogs
WHERE hashtags.hashtag_id = hashtag_posts90.hashtag_id
AND blog_id = blogs.id AND post_date <= DATE_SUB(CURDATE(), INTERVAL 0 DAY)
AND post_date >= DATE_SUB(CURDATE(), INTERVAL 90 DAY)
AND hashtag_posts90.hashtag_id = 148
GROUP BY blog_id ORDER BY comment_counter DESC LIMIT 10