SELECT COUNT(*) FROM (SELECT a.ID
FROM bn_articles a
													INNER JOIN bn_articles_distribution d
													ON d.ArticleID = a.ID
 INNER JOIN bn_articles_meta am
																		ON am.ArticleID = a.ID
INNER JOIN bn_articles_categories c
														ON c.category_id = d.category_id
WHERE a.publish <= NOW() AND am.language_id = 1
AND a.ID IN (0,80221,80196,75473,75137,75118,74867,74767,74692,74677,73909)
LIMIT 10000) as temp