SELECT cf.distcode AS HOSPCODE ,campur.ampurname AS hosname ,COUNT(DISTINCT IF(fp.fptype='1', CONCAT(fp.HOSPCODE,'-',fp.pid), NULL)) AS '1' ,COUNT(DISTINCT IF(fp.fptype='2', CONCAT(fp.HOSPCODE,'-',fp.pid), NULL)) AS '2' ,COUNT(DISTINCT IF(fp.fptype='3', CONCAT(fp.HOSPCODE,'-',fp.pid), NULL)) AS '3' ,COUNT(DISTINCT IF(fp.fptype='4', CONCAT(fp.HOSPCODE,'-',fp.pid), NULL)) AS '4' ,COUNT(DISTINCT IF(fp.fptype='5', CONCAT(fp.HOSPCODE,'-',fp.pid), NULL)) AS '5' ,COUNT(DISTINCT IF(fp.fptype='6', CONCAT(fp.HOSPCODE,'-',fp.pid), NULL)) AS '6' ,COUNT(DISTINCT IF(fp.fptype='7', CONCAT(fp.HOSPCODE,'-',fp.pid), NULL)) AS '7' FROM fp INNER JOIN cfptype ON fp.fptype = cfptype.id_fptype INNER JOIN person ON fp.HOSPCODE = person.HOSPCODE AND fp.PID = person.PID INNER JOIN chospital cf ON fp.HOSPCODE = cf.hoscode INNER JOIN campur ON cf.distcode = campur.ampurcode WHERE person.NATION <> '099' AND date_serv BETWEEN 0 AND 0 AND campur.changwatcode = '77' GROUP BY cf.distcode