<br>
Timezone Inisial : Asia/Jakarta<br>

		SELECT 
            v.id,
            p.id as patient_id,
            p.nik,
            p.name,
            p.phone,
            rc.kode_bpjs as clinic_bpjs_code,
            rc.name as clinic_name,
            rp.kode_bpjs as doctor_bpjs_code,
            rp.name as doctor_name,
			IFNULL(v.booking_code, v.id) as booking_code,
			v.payment_type_id,
			v.insurance_no,
			v.jenis_kunjungan,
			v.jenis_kunjungan,
			v.date,
			v.admission_type_id,
			v.bpjs_no_rujukan,
			v.queue_number_prefix,
			v.queue_number,
			v.bridging_antrol_task_id,
            v.insert_date,
            v.registration_date,
			v.registration_start_date,
			v.insert_date,
			v.pemeriksaan_perawat_start_date,
			v.pemeriksaan_perawat_end_date,
			v.pemeriksaan_start_date,
			v.pemeriksaan_end_date,
			v.prescription_received_date,
			v.prescription_start_date,
			v.prescription_end_date,
			v.continue_id
		FROM 
			visits v
            JOIN patients p ON (p.id=v.patient_id)
            JOIN ref_clinics rc ON (rc.id = v.clinic_id)
            JOIN ref_paramedics rp ON (rp.id = v.paramedic_id)
		WHERE 
            DATE(v.`date`) BETWEEN '2025-06-06' AND '2025-06-06' 
            AND rc.`type`='rawat jalan' 
            AND rc.kode_bpjs NOT IN ('', 'RAD', 'PSI', 'AKP', 'GOD', 'EKS', 'X', 'LAB', 'HDL', 'IGD')
            AND rc.kode_bpjs IS NOT NULL 
            AND rp.kode_bpjs IS NOT NULL
            
        ORDER BY v.id DESC