1234567891011SELECT DISTINCT c.category_id AS id, c.nameFROM categories AS cLEFT JOIN jobs AS j ON c.category_id = j.category_idWHERE j.job_id IS NOT NULLORDER BY c.name
