Просмотр поста

SELECT COUNT(*) FROM `cms_mail`
                            LEFT JOIN `cms_contact` ON `cms_mail`.`user_id`=`cms_contact`.`from_id` AND `cms_contact`.`user_id`='0'
                            WHERE `cms_mail`.`from_id`='0'
                            AND `cms_mail`.`sys`='0'
                            AND `cms_mail`.`read`='0'
                            AND `cms_mail`.`delete`!='0'
                            AND `cms_contact`.`ban`!='1';
SELECT COUNT(*) FROM `cms_album_files` WHERE `user_id` = '0' AND `unread_comments` = 1;