クエリ発行エラー 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
INNER JOIN dt_bloggers b
ON a.blogge' 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
ORDER BY a.pv DESC
LIMIT 10 OFFSET 0
