SELECT
tbl_programme.program_id,
tbl_programme.program_name_en,
tbl_programme.program_name_fr,
tbl_programme.program_type_id,
tbl_programme.program_price,
tbl_facility.facility_name_en,
tbl_facility.facility_name_fr,
tbl_programme.program_dates,
tbl_programme.program_start,
tbl_programme.program_end,
tbl_programme.program_description_fr,
tbl_programme.program_description_en,
tbl_programtime.time_name_fr,
tbl_programtime.time_name_en
FROM
tbl_facility
Inner Join tbl_programme ON tbl_facility.facility_id = tbl_programme.facility_id
Inner Join tbl_programtime ON tbl_programme.program_time_id = tbl_programtime.time_id
WHERE program_type_id =1
AND program_start > 2024-03-29 AND program_end > 2024-03-29 AND tbl_programme.facility_id =11 AND tbl_programme.visible = 1
ORDER BY program_start DESC