Search Detailed search

Did not find any current courses in system.

SELECT DISTINCT c.*, AS organization_name, COUNT( AS reservations_count FROM courses AS c LEFT JOIN organizations AS o ON = c.org_id LEFT JOIN course_reservations AS cr ON cr.course_id = AND cr.is_active > 0 WHERE c.is_active > 0 AND (c.status = 'P' OR c.status = 'R') AND ((c.start_date <= '2019-05-27' AND c.end_date >= '2019-05-27') OR c.start_date >= '2019-05-27') GROUP BY ORDER BY c.start_date