SELECT COUNT( 1 ) AS mailCount, newsletter
FROM module_newsletter_rel_cat_news AS tblRelListMail
RIGHT JOIN module_newsletter_rel_user_cat AS tblRelUserList ON tblRelListMail.category = tblRelUserList.category
RIGHT JOIN module_newsletter_user AS tblUsers ON tblRelUserList.user = tblUsers.id
AND tblUsers.status =1
WHERE newsletter =22
GROUP BY tblRelListMail.id, newsletter



mailCount 	newsletter
1446 	 	22
295 	 	22
2185 	 	22