Otsi Lisaks...

Ei leidnud ühtegi toimuvat kursust süsteemist.

SELECT DISTINCT c.*, o.name AS organization_name FROM courses AS c LEFT JOIN organizations AS o ON o.id = c.org_id WHERE c.is_active > 0 AND c.start_date >= '2017-11-22' ORDER BY c.start_date LIMIT 30