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 ') and newsID != 0 group by urlbullet, title having count(*) > 0 in select count(*) as rows, news.urlbullet, news.title, news.id from newsTags inner join news on news.ID = newsTags.newsID where tagID in () and newsID != 0 group by urlbullet, title having count(*) > 0 order by rows desc, news.created desc limit 0,5;