Mysql error:

Unknown column 'temporary' in 'on clause'
SQL:
SELECT DISTINCT jct.value_nl AS contractType, jct.external_id FROM job_contract_types jct INNER JOIN publications p ON p.contractType_id = jct.external_id LEFT JOIN regios AS r ON p.regioId = r.regioId AND applyUrl NOT LIKE '%igb%' AND publicationStart < NOW() AND publicationEnd > NOW() AND p.contractType != '' AND p.contractType_id > 0 AND (p.id IN (5380, 5376, 5375, 5374, 5371, 5369, 5367, 5366, 5353, 5352, 5348, 5345, 5344, 5343, 5339, 5338, 5336, 5335, 5332, 5331, 5330, 5322, 5321, 5319, 5318, 5315, 5285, 5264, 5249, 5243, 5242, 5239, 5226, 5209, 5200, 5192, 5191, 5189, 5182, 5174, 5169, 5155, 5154, 5150, 5144, 5133, 5125, 5110, 5100, 5094, 5088, 5060, 5059, 5058, 5057, 5056, 5055, 5052, 5051, 5050, 5049, 5048, 5047, 5046, 5045, 5040, 5038, 5035, 5032, 5031, 5019, 4659, 4318, 4315, 1955, 1867, 1843, 1814, 1751, 1746, 1682) OR p.contractType_id IN(temporary-job-interim)) ORDER BY jct.value_nl ASC