You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near ') GROUP BY blogger_id ) a INN' at line 16

SELECT a.blogger_id, a.pv, a.date, b.blogger_name, b.identifier, b.blog_url, b.blog_name FROM (SELECT blogger_id, date, SUM(pageviews) AS pv FROM google_daily_gather WHERE date = (SELECT MAX(date) AS date FROM google_daily_gather WHERE date <= REPLACE(date_add(current_date, interval -1 day),'-','') ) AND blogger_id IN () GROUP BY blogger_id ) a INNER JOIN dt_bloggers b ON a.blogger_id = b.blogger_id WHERE b.not_show_ranking_flag = 0 AND b.delete_flag = 0 AND b.status_id = 3 ORDER BY a.pv DESC LIMIT 10