ชุดคำสั่ง
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'
,COUNT(DISTINCT IF(fp.fptype='8', CONCAT(fp.HOSPCODE,'-',fp.pid), NULL)) AS '8'
,COUNT(DISTINCT IF(fp.fptype='9', CONCAT(fp.HOSPCODE,'-',fp.pid), NULL)) 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