YnG4Thu07pfLMzs9BFLO9Sk9WFFpxvbOznYI6DmSGkkP9aoApBVg8Vqaug0/yEvCx/njmiir7boWTZLjvMckaXa20o4nhTbZGwHvNj0DDDE77UkyxAfjv+SQI3jhATxzq0oFhhJ75BEjQio/OTlS4kB4yyBwyN3/oflznvUAHXkiciltHClhdI0s+lQ9Gr/axivlEmCRgqNCgrdsglBupfJEANizG2wfgvemhSc+Rk54cA8VUvTiMj0ZaNPrj+ouaZyaHAjfi7t0h/vlZs5ZWFvOYZSTUTzY8gjckreuHpepqFkpkqQj4is6+FWHd6K3BE1Zql7O6HMfp7OKJRUe4sBngBe2OMU4v70ReyX1RlqyQp9iQPbVkVzCzbu6AUZ/Ftz46kQ5vg3B9ytM+b2zaVfNY0sK1AfrFCekeo4zoXsKQsdVO256ZkpRDT/8jdcai+9BP2TlBVo/b3EkVjezqDSy4TdJ7vaM3j0LwEDBHXu//NDnj0kWNKGvVTuwV+etF27zXuLy8Zb3KAs3/sQ7+Xn7I4/gwGBbyELcXfyotrRyX6z/JdUUpdeAsW5w4F/pr+eVPelo9OCHTG07TNF3rUOhRqyAKQa6HvND63cId2yB+Itht/mIwGewuwuf9iHV6cbjNI/HEMm2kJay2RtwghK3HCXUAwSALbRsGZ0d0/cR34U+nJFcvDR7sBnaXzKVb4Qlt6wIeuNOMWsjUsbSBXTNZLSaFFwUtNhTTvvDgUaooJgVGmdzCgo8kxllcTcFsCR62B6BJTzFHYSKXvPknT00gCZNEQAzezx0WrGREPJtB6Z4zsnEdxcBFUYbAQ36BaHZdljd7jf/kTlwYXr29Gq8tx9cRfX1QA15BG05CTAfLzvCeLJjp8nnhuSIhYfpz/B2oPGI4it1569Pk2o8zS97oxwCPXXI6esLYY/77gR3gVl0Ik7U0y1wY3IyqSpwsCJb2U/WZII/hfC931s1TGra7JcL5yvhyQe38XnSfK0/pd/sUVqoznsMxQ8sr6EbUcIN8q/Y25PpkMomUq50jDuqZBjRmKaVrqA7VG+jAuFILDvC0GimFX1Eig+4uiFkMQRGTJWnKebJ9At7fU1lcDMY9wXqE2Dumd1W8KhBLyX2CLg6d5MdQixt4kOPIl63gpgTvi2vyn1UXs69e2iZLbCm2a/4DV7mzztS0oA7r5jHFam77k3XSxjJJq6WwFuff3r94spCwy0cxoPfhrtO1N1bU2zyBR6ag9aOVxtzCXTy2Sbl3GYFVNxdHETv3WTkvdkqZDs7lLyl4u/A4mvSdkU/AO+RYulaHmkWuHyxsLcOQrklDkPxRl+gcDwB5QU1RlVexpXJl9l6IRlQSi8UZ1T36nfNXDuT1Rtn0VY=
1 - SELECT et.id, et.residence, et.bottin, et.emploi, et.msss, (eev.dateFin > NOW()) as vedette FROM emplois_temp et
LEFT JOIN envois_eer_emplois_vedette eev ON eev.emploi = et.id AND eev.dateFin > NOW()
LEFT JOIN residences r2 ON r2.id = et.residence WHERE et.bottin = AND (r2.emplois_masques != '1' OR r2.emplois_masques IS NULL) AND
((SELECT desapprouve FROM emplois e WHERE e.id = et.emploi AND e.datePublication <= NOW()) = '0')
AND (SELECT affiche FROM emplois e WHERE e.id = et.emploi AND e.datePublication <= NOW()) = '1'
AND (
et.residence in (select res_id from utilisateurs where res_id > 0)
OR
et.bottin in (select serv_id from utilisateurs where serv_id > 0)
OR
et.msss in (select msss_id from utilisateurs where msss_id > 0)
OR
r2.groupe in (select res_groupe_id from utilisateurs where res_groupe_id > 0)
)
GROUP BY et.id
LIMIT 100