9TyGvLJNcRdkqwfdXWX0EBbwgtJhr+2XF7cMCWvsIPJL26wY0NAsQpayFyWMWhe985x6a9sVBO3fExN3z8SbIC5sCWgEsQFStSzH+f2/yJ6bMFr84kH3pd2x07sQZJsk5N4yC5zlXh6aJwdIS5BActLItuJKDx2b1MKQQ6CrIc1VCAD3V3IjfjE28Vceqql1qadsDIJvxxRzAQXxraY2Ie4soFtAEbkXGv8UFM6CgCd/12/ZZuFCjwBQX1X8Fs86XF6SATZh2nZ+r61k2cT/VHJxJtjuy1qRM8+8a85vThdQTAewBOerTLmdYWpLrGE2Cwapa4x37wlWVOdqen+0j539Z7cJ/MLfAouU+G8IST0kjmm69thp6lIDbPBxw31OGLoH40g3hRjkPkkpIRoSdU08anqKP7OEtsZa1iNo9vFbQiLUSZEsFPGpuqO/J8vC1CGgeHnFu9B0b7Wf8NZDncY9Vs6eyUg+TwiUBPJoThOSiM3oBlzKnisV/4mDXsdnplHHGxawt+HACMrvHmxEJkXQwn4DhvoCu+AlZGqW22BfrMMiMHPKREhcGtflfe+csojlhnjaQqxcZOnwbHQkkwGCxmh08gouz3JYWnc/rV7MsB6yFzDrdQA4XI9htINs1/uZPTYqs1P4g4HhVLSOw1kbRvbULOybc0UXTdU6ziAtYY35hdsa6O5PMBKD0nAldK9hkLPbYi1Ki/Oyq+YBpnpCgoDbY6H7L54niTWJo2z+dgN0UHh9JvoCEAYaAFmxAQcpOrMqj1EYG8AiOd5zYv0Er3q9KYIAbYgG1ne8cpkZ/KrSUy7kNXCHboU7A8M4RsUYdzsLnIrNwBMQZltCZrgpm4NYTFw2gCqec4effMMwV5ZqYZFQWr215WmvhZvDeg/7F91f+lDP06HlBHy2gC5MHfs+77xJUi+I+AOWVjEBa4zW6gvV559blqxzvHClIGfSB5ER5qcbicYCBdMxvr7yEKTr40espYEN/B7btg83el1r803fcFNOFY+hDySFXTsMMVAo+dUaUdVMMb+HUoOV8wJrljy7K6o2WkZCYqZ4jmH7miOJC8DebpTF0UZ877vPJ7a5KAY/fQM2JSCBwV70UlpEGe8M5zUUhqLBEWR7IDutcgscJWNlxN83+n5CbCxoHRCZc1sYJo2xpV2g8HmALkIGM39RcVechSsP4diRt1lxArH4oVC+bt1hdWDRjuvsnc+pMz86GvDnf3DmZ2hDWhmIuyj71khqqXjFKG+QxeXlFfOWcG51+8iuwtbdWCGQqDOKjV+pOsn50Dy7j/H9tnaRYyK6wHZW+MmRWozvxRJTnor61EVdpVxW2WCWA5uk3kopS9QZpZM/kvEpx+7qwbRu4BTsYVfNn/k=
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