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