SELECT tbl_program_master.* , tbl_WP_PROGDETAIL.*
FROM
tbl_WP_PROGDETAIL
left join tbl_program_master
on tbl_program_master.pid = tbl_WP_PROGDETAIL.PID
WHERE tbl_program_master.pid <> '' and (tbl_program_master.pid <> 'P368') and (tbl_program_master.p_cate1 <> 'CATSM') and tbl_program_master.p_delete <> 'Y' and tbl_WP_PROGDETAIL.DELFLAG <> 'Y' and tbl_WP_PROGDETAIL.NEWSPUB = 'Y' and (tbl_WP_PROGDETAIL.AIRDATE BETWEEN '2022-03-24' AND '2023-03-24')
group by tbl_program_master.pid
order by tbl_program_master.p_title asc
limit 36,12
CTS기독교TV 홈
