$sqlPart = " SELECT (SELECT COUNT(`id`) FROM `crm_requests` WHERE `date` BETWEEN '".$date1."' AND '".$date2."' ".$callSelect."  and `del` = '' ".$rights.") as `allall`,
            (SELECT COUNT(`id`) FROM `crm_requests` WHERE `date` BETWEEN '".$date1."' AND '".$date2."' ".$callSelect." AND `checkMoscow` = 'moscow'  and `del` = '' ".$rights.") as allMos,
            (SELECT COUNT(`id`) FROM `crm_requests` WHERE `crm_requests`.`date` BETWEEN '".$date1."' AND '".$date2."' AND `crm_requests`.`checkMoscow` = 'region' and `crm_requests`.`region` <> 'Неизвестно' and `crm_requests`.`state` <> 'neobr' ".$callSelect." ".$rights." and `crm_requests`.`del` <> 'hide') as allRegion,
            (SELECT COUNT(`id`)FROM `crm_requests` WHERE (`date` BETWEEN '".$date1."' AND '".$date2."') and `del` <> 'hide' and (`state` = 'neobr' OR `vtorCall`<> '' ) ".$rights.") as `allNeobr`,
            (SELECT COUNT(`id`) FROM `crm_requests` WHERE `state` IN('zapis', 'podtverjden') ".$callSelect." and `del` = ''  and `rdate` BETWEEN '".$date1."' AND '".$date2."' ".$rights.") as `allZapis`,
            (SELECT COUNT(`id`) FROM `crm_requests` WHERE `state` = 'prihod' and `del` = '' ".$callSelect."  and `rdate` BETWEEN '".$date1."' AND '".$date2."' and `partnerPin` = '' ".$rights." ) as `allPrihod`,
            ".$admin_prihod."
            (SELECT COUNT(`id`) FROM `crm_requests` WHERE `state` = 'sliv' ".$callSelect."  and  `rdate` BETWEEN '".$date1."' AND '".$date2."' and `del` = '' ".$rights." ) as `allSliv`,
            (SELECT COUNT(`id`) FROM `crm_requests` WHERE `state` = 'sozvon' ".$callSelect." and `rdate` BETWEEN '".$date1."' AND '".$date2."' and `del` = '' ".$rights." ) as `allSozvon`,
            (SELECT COUNT(`id`) FROM `crm_requests` WHERE `state` = 'brak' ".$callSelect." and `date` BETWEEN '".$date1."' AND '".$date2."' and `del` = '' ".$rights." ) as `allBrak`,
            (SELECT COUNT(`id`) FROM `crm_requests` WHERE `state` = 'nedozvon' ".$callSelect."  and `date` BETWEEN '".$date1."' AND '".$date2."' and `del` = '' ".$rights." ) as `allNedozvon`,
            (SELECT COUNT(`id`) FROM `crm_requests` WHERE `state` = 'bk' ".$callSelect." and `rdate` BETWEEN '".$date1."' AND '".$date2."' and `del` = '' ".$rights." AND checkMoscow = 'moscow' ) as `allBkMoscow`,
            (SELECT COUNT(`id`) FROM `crm_requests` WHERE `state` = 'bk' and `rdate` BETWEEN '".$date1."' AND '".$date2."' and `del` = ''  ) as `allBk`,
            (SELECT COUNT(`id`) FROM `crm_requests` WHERE `state` IN ('prihod', 'podtverjden', 'zapis') ".$callSelect." and `rdate` BETWEEN '".$date1."' AND '".$date2."' and `del` = '' and  `partnerPin` <> '' ".$rights.") as `partnerComing`,
            (SELECT COUNT(`id`) FROM `crm_requests` WHERE `state` = 'online-doc' ".$callSelect." and `date` BETWEEN '".$date1."' AND '".$date2."' and `del` = '' ".$rights.") as `online-doc`,
            (SELECT COUNT(`id`) FROM `crm_requests` WHERE `state` = 'vtorich' ".$callSelect." and `date` BETWEEN '".$date1."' AND '".$date2."' and `del` = '' ".$rights.") as `allVtorich`";
            $res = mysql_query($sqlPart, $bdUgolov);