SELECT cf.distcode AS HOSPCODE ,campur.ampurname AS hosname ,sum(IF(fp.fptype = '1',1,0)) AS '1' ,sum(IF(fp.fptype = '2',1,0)) AS '2' ,sum(IF(fp.fptype = '3',1,0)) AS '3' ,sum(IF(fp.fptype = '4',1,0)) AS '4' ,sum(IF(fp.fptype = '5',1,0)) AS '5' ,sum(IF(fp.fptype = '6',1,0)) AS '6' ,sum(IF(fp.fptype = '7',1,0)) AS '7' ,sum(IF(fp.fptype = '8',1,0)) AS '8' ,sum(IF(fp.fptype = '9',1,0)) AS '9' FROM fp INNER JOIN cfptype ON fp.fptype = cfptype.id_fptype INNER JOIN chospital cf ON fp.HOSPCODE = cf.hoscode INNER JOIN campur ON cf.distcode = campur.ampurcode WHERE date_serv BETWEEN 0 AND 0 AND campur.changwatcode = '77' GROUP BY cf.distcode