Mysql error:
You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'option-permanent)) ORDER BY jct.value_nl ASC' at line 7
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 (3526, 3510, 3489, 3483, 3482, 3481, 3452, 3449, 3445, 3435, 3428, 3417, 3410, 3408, 3405, 3400, 3396, 3391, 3375, 3373, 3363, 3362, 3360, 3358, 3335, 3334, 3330, 3324, 3308, 3307, 3306, 3305, 3304, 3303, 3302, 3301, 3299, 3298, 3297, 3296, 3294, 3290, 3287, 3283, 3279, 3278, 3274, 3268, 3267, 3265, 3261, 3251, 3248, 3245, 3243, 3241, 3239, 3228, 3226, 3223, 3222, 3217, 3215, 3214, 3212, 3209, 3207, 3201, 3200, 1955, 1867, 1843, 1814, 1751, 1746, 1682) OR p.contractType_id IN(permanent-job-interim-option-permanent)) ORDER BY jct.value_nl ASC
/data/sites/web/letsworkinternationalcom/checkout/master/1c3d099a4c788d1a3eb84a52e9380e6e1cd7e7ab/www/_functions/content_function.php
Line: 2396
In function: get_jobs_format()
/data/sites/web/letsworkinternationalcom/checkout/master/1c3d099a4c788d1a3eb84a52e9380e6e1cd7e7ab/www/_data/_jobs_filter.php
Line: 23
In function: get_jobs_filter()
/data/sites/web/letsworkinternationalcom/checkout/master/1c3d099a4c788d1a3eb84a52e9380e6e1cd7e7ab/www/_templates/search.php
Line: 77
In function: include_once()
/data/sites/web/letsworkinternationalcom/checkout/master/1c3d099a4c788d1a3eb84a52e9380e6e1cd7e7ab/www/template.php
Line: 214
In function: include_once()
/data/sites/web/letsworkinternationalcom/checkout/master/1c3d099a4c788d1a3eb84a52e9380e6e1cd7e7ab/www/index.php
Line: 23
In function: include_once()