select c.id, c.name, (SELECT COUNT( * ) 
FROM customer cc
LEFT JOIN services_vagon sp ON cc.id = sp.id_costumer
WHERE sp.sost =1
AND sp.type_vagon =  'Порожний'
AND sp.type_uborka =  'Груженый'
AND cc.id =c.id) pogr, 
0 pogr_pr, 
0 pogr_kpr,
(SELECT COUNT( s2.id ) 
FROM customer c2
LEFT JOIN services_vagon s2 ON c2.id = s2.id_costumer
WHERE s2.sost =1
AND s2.type_vagon =  'Груженый'
AND s2.type_uborka =  'Порожний'
AND c2.id =c.id) vygr,
0 vygr_pr,
0 vygr_kpr,
(SELECT COUNT( s3.id ) 
FROM customer c3
LEFT JOIN services_vagon s3 ON c3.id = s3.id_costumer
WHERE c3.id =c.id) podan,

(SELECT COUNT( * ) 
FROM customer c4
LEFT JOIN services_vagon s4 ON c4.id = s4.id_costumer
WHERE s4.sost=1 and c4.id =c.id) ubran,

0 peregr,
0 peregr_kprmon,
0 sred_prost,
(SELECT COUNT( * ) 
FROM customer c5
LEFT JOIN services_vagon s5 ON c5.id = s5.id_costumer
WHERE c5.id =c.id and s5.pravo='ОАО РЖД') rjdvag,
0 man

 from customer c
where (SELECT COUNT( s3.id ) 
FROM customer c3
LEFT JOIN services_vagon s3 ON c3.id = s3.id_costumer
WHERE c3.id =c.id)>0

select c.id, c.name, (SELECT COUNT( * ) 
FROM customer cc
LEFT JOIN services_vagon sp ON cc.id = sp.id_costumer
WHERE sp.sost =1
AND sp.type_vagon =  'Порожний'
AND sp.type_uborka =  'Груженый'
AND cc.id =c.id) pogr, 
0 pogr_pr, 
0 pogr_kpr,
(SELECT COUNT( s2.id ) 
FROM services_vagon s2
WHERE s2.sost =1
AND s2.type_vagon =  'Груженый'
AND s2.type_uborka =  'Порожний'
AND s2.id_costumer =c.id) vygr,
0 vygr_pr,
0 vygr_kpr,
(SELECT COUNT( s3.id ) 
FROM services_vagon s3
WHERE s3.id_costumer =c.id) podan,

(SELECT COUNT( s4.id ) 
FROM services_vagon s4 
WHERE s4.sost=1 and s4.id_costumer =c.id) ubran,

0 peregr,
0 peregr_kprmon,
0 sred_prost,
(SELECT COUNT( * ) 
FROM services_vagon s5 
WHERE s5.id_costumer =c.id and s5.pravo='ОАО РЖД') rjdvag,
0 man

 from customer c
where (SELECT COUNT( s3.id ) 
FROM services_vagon s3 
WHERE s3.id_costumer =c.id)>0

select c.name,SV.id_costumer id, 
SUM( if (SV.sost =1 
           AND SV.type_vagon = 'Порожний'
            AND SV.type_uborka = 'Груженый',1,0)) pogr,
0 pogr_pr, 
0 pogr_kpr,
SUM( if (SV.sost =1
AND SV.type_vagon =  'Груженый'
AND SV.type_uborka =  'Порожний',1,0 )) vygr,
0 vygr_pr,
0 vygr_kpr,
count(1) podan,
SUM( if (SV.sost =1,1,0 )) ubran,
0 peregr,
0 peregr_kprmon,
0 sred_prost,
SUM(IF( SV.pravo='ОАО РЖД',1,0)) rjdvag,
0 man

from services_vagon SV left join customer C on SV.`id_costumer`=C.id
where SV.dt_doc>'2013-08-01' and SV.dt_doc<'2013-08-30'
group by id_costumer

SUM( if (SV.sost =1 
           AND SV.type_vagon = 'Порожний'
            AND SV.type_uborka = 'Груженый',1,0)) as po