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

selemet, select (SELECT COUNT(*)
FROM `cms_mail`
LEFT JOIN `cms_contact`
ON `cms_mail`.`user_id`=`cms_contact`.`from_id`
AND `cms_contact`.`user_id`=1
WHERE `cms_mail`.`from_id`=1
AND `cms_mail`.`sys`='0' AND `cms_mail`.`delete`!=1
AND `cms_contact`.`ban`!='1' AND `spam`='0') as `m1`, (SELECT COUNT(*) FROM `cms_mail` LEFT JOIN `cms_contact` ON `cms_mail`.`from_id`=`cms_contact`.`from_id` AND `cms_contact`.`user_id`=1
WHERE `cms_mail`.`user_id`=1 AND `cms_mail`.`delete`!=1 AND `cms_mail`.`sys`=0 AND `cms_contact`.`ban`!=1) as `m2`, (SELECT COUNT(*) FROM `cms_mail` LEFT JOIN `cms_contact` ON `cms_mail`.`user_id`=`cms_contact`.`from_id` AND `cms_contact`.`user_id`=1 WHERE `cms_mail`.`from_id`=1 AND `cms_mail`.`sys`='0' AND `cms_mail`.`read`='0' AND `cms_mail`.`delete`!=1 AND `cms_contact`.`ban`!='1' AND `cms_mail`.`spam`='0') as `mnew`, `users`.`id` from `users` where `id` = 1