uE39rSe1+3F/uHrwwcNFQH6D95yfIS/NkA/gOBOQctzUZe+hO+l/xiaqbLH95IMaT1AjADUKmDz7+ZsD2afkuIWK9eCJo7UxZ9GmRfKnQt1RiA4MG5gU6Stq8C3m7qyQLMyZEPMOwX52qodv9eOG7bqcRY3HZiQdeSxPjlldIfIpdHV5SeiV+bknJLI8fpJwksvQxRtvP/bPT4QEX6N49rd29efbWENRbwvhw1ZuIm2SNDbvXX4+b2BHcbJB0662aiKdGy2oVjaos0lMZmz3sCCq8f2CGeswmeJe9PGzNSRAtkdlGa8vxPqqsvWPPT4vx/oDmCpk9qDgaYvesd5FUoNj7fh2A5WPwNaG7xyBIbzEDtn0ygre8vsyPV2FjAuPtFY/EBKBKBK58Kh/dGmYqaqLg+c6l8Nbw019owQC94g7gtCVI4rZaDBKiuJqzaQDdV7zxYLRxRDn67R4LYK/9+jZjV50Tdomtn3u3gMESTonZo0Y7AlYl8j7GN6WKxDWER1R9w5MANJrzNqLPOYRV8ipkrVDJEy1EA8HJfxXLe4Rl9aINpQhzHKZ5XsweSTTpGpN5Ad0z9cpl9PWeED6SqPrn+qKXVoucdP0mB6lJ0JQNHkI20G9pAJKnNrdX+6qrD/jvzIiI2bUWvuN+Fwk4j995q/MMDjBMr9ie2zaLhzTAGDdcDBd3vRoPD/ywhf3RCXLqX9IsdxQFuaUtmBgev2tDIgqxouozMKzFysnE+91pqjLdJKizsnjwTmsEeNW5lhrFqeEWhyHbBKcbAU7HwkD33fwpXFhhSZCwMHIw4ytUD5hk47bjVadZqMsAMQ0+X9xrTZR0wHYqge747tkO5LK7WTjdMxB58UiZoiIFAowCdqkrzD8UVni9HAZEO2ci31BCWzRjZWewlpJY4auWwNd8enHpoORG7OeG8jRYa8mNE3EmO0r0vxFAKwTg2Bj9cOoNZW0PnibfN221CeaeEACW8HVroYUJ7lTW7huKRed3Dkfs7cHwxB62KW4CdawTPwzJp6tybv906RuuMYKNFEmYBHXT64W0gvQfuU/WFHe5zA06N3y2AtMOKJ2537EjUXf7HMwrgOX7Vsbw6vhJHwl3fe7rFFfzzpX0Yb1FbdMnIt42Ntene0jCh34ClXCpggwT1iEod2yBeei8dVxfsMmUb2qJNP48FAiWtffE+xFLgHUu4MT7zrB5/HIPL/0mqT6q+mKyPYCiYauYNahPO8oJpth1G0vSfDC92L3Dn2rdFeE704P8aSuWRrHrJgmkmG5PFE0uOW+ZNIne0AEhTwM678WoJDQvZ2c94lx4iE/PdzGUmOpRAl8+W4UhevbJCKx3+XvSxfjRNBUCKZWnHCBRc6jPbVf1Zg0eho=
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