Search two tables with joins – complex query


SELECT workers.*,
jobtype.jobtype AS jobtype
FROM workers
INNER JOIN jobtype ON workers.jobtypeid = jobtype.id
LEFT JOIN invited ON invited.workerid = workers.id AND invited.jobid=166
WHERE workers.jobtypeid = 10 AND workers.working='no'
AND invited.id IS NULL
ORDER BY workers.rep