040215

    SELECT a.no_reg, d.cara_bayar,
    SUM(IF(c.no_reg, 1,0)) karcis,
    SUM(IF(b.konsul= 'Y',1,0)) konsul
    FROM pendaftaran a
    LEFT JOIN poli_kunjungan_pasien b ON a.no_reg=b.no_reg
    LEFT JOIN billing_karcis c ON c.no_reg=a.no_reg
    INNER JOIN master_cara_bayar d ON a.cara_bayar=d.id
    LEFT JOIN master_kelass e ON e.id_kelas=a.kelas
    WHERE `instalasi_id` !=  3 AND `id_smf` !=  0
    GROUP BY d.cara_bayar

    UNION

    SELECT COUNT(*) total, a.no_reg, IFNULL(b.nama_kelas,'IGD') nama_kelasnya, IFNULL(b.id_kelas, 'IGD') cost_center, f.cara_bayar
    FROM poli_kunjungan_pasien a
    LEFT JOIN master_kelass as b ON `b`.`id_kelas` = a.`kelas`
    LEFT JOIN mastercr_ruang_rawat as c ON c.`id` = a.`ruang_rawat`
    LEFT JOIN pegawai as d ON d.`id_pegawai` = a.`id_dokter`
    LEFT JOIN master_cara_bayar e ON a.cara_bayar=e.kd_bayar
    LEFT JOIN pendaftaran f ON f.no_reg=a.no_reg
    WHERE `instalasi_id` =  3 AND `id_smf` =  0
    GROUP BY f.cara_bayar

    UNION

    SELECT *
    FROM pendaftaran a
    LEFT JOIN master_asal_rujukan b ON a.prosedur_masuk=b.id_asal_rujuk
    LEFT JOIN master_cara_masuk c ON a.cara_masuk=c.id_cara_masuk
    WHERE c.asal_rujuk