Skip to content

Instantly share code, notes, and snippets.

@felclef
felclef / elland.skill.candidate.sql
Created August 15, 2011 16:47
Ajudando o menino Elland
SELECT
jb.*
FROM
jobs jb
INNER JOIN jobs_skills jbs
ON jbs.job_id = jb.id
INNER JOIN skills skj
ON skj.id = jbs.skill_id
LEFT JOIN (
SELECT
"jobs".*
FROM
"jobs"
INNER JOIN "skill_sets"
ON "skill_sets"."source_id" = "jobs"."id"
AND "skill_sets"."source_type" = 'Job'
INNER JOIN "skills"
ON "skills"."id" = "skill_sets"."skill_id"