LaMdvlSjIdN65w8UwYr2vuT/9NU8G0IizHXcxYomgTC8ZFDqP2Apu9n56nQvoaxpKMt2AFEiyqCSuBL067FLkLT1AEUzacIIXflYAIJ0xtjpNhXPlzDfwNlcBrLKx1X1HULvhrdj9SwfPrgjO0O2RHFNCgGy9ij0IDw7ZcXTmr+VMp1zfKoUKw6T2WkB7O+SRnbakT848UirK3Er/VGp4fRCb7Mw0aGAqRq7XWzMQTk3wzWn3JNvXmCdjs3B9UL9yyWLNEavJG9PWqsYN0zofiIslla5hm5A65wLIi+RkbvejgezrE/gC+e/Ls9tEloc4chV347kzelFskub7OlHM+M1h9xM2kRZhnNT4LCevJldSJq9f9gfxa+3a/O6JnuXgRZjtULdOeP8sPb41+AfHi42mIBN+/kUA1TB/tLusfQ0pxc4qxy455U1cQLPPBTQZohj1FLvGqf9VLbjEhXnw9qqUCmgLcwtr54jjXbtOLgY/qM2LbmNvA7bnkIyAfNskT4P7Eh01/x/xUx6FiFvNECgQmurWk7+hx9tEsmKFNYQ42nd71yoVERZOSzoRezhJIOkIqPyzz6bV3jc+S7WRV5eOjSLGDzolTCk8o53hsYAtZ5hJlARs9QD8NIZQERc+rm6Bh946GvUIStuqQZ7yZhH9S7PN1RHPk3pzHMVqkCeJtUQFxTDOgkdxiyOuhWybPpplFxE9Lhsh7n/L7SDSDjLzLEaisQq4kPZo6ns4E481FNlqFhuq6LJA188y42QGOhugJotPfQiZIHSYResCZeBL4QBwtoBLjOSPmNQ7EMckI8pilLOmz2VSyRYm4OBgP8V62y7Ri1y3kA0J31QmzRzyy3tqYeT4gqR/HE5ODEmJx4hEuCk3D4uzzkv0XZUX4Yy0qllJopjRqFnqc7GGu5LNPLebzAW65v1zrPrCldpvrEeP958Z+rOau/8Fn2a5ZmSaIbojCpeKzPD4H6kgRGWOcBKx93rp19wq5TcyvTt91AVznoIAGFl2/SqOSUEJIJEfo7al96RswdD52BAPYVodONnUKs+56CEl2B4MxI3Shl0XIiiIFhCYrbhPx89ocFfvlnjPSWE3bwnGqd9NGvAj8f/EFVGh2SZYUl1E5rGDmFy4LSeI73YmN2BzBs8YAfT6050/heecnWTMQyr9y+IhIpwVVJTa75OVoFyalTcUDpexT8nmszcrisfvKwRlJ2H0ZtZAsejhYNMStGzF8lsc+40kOC/VAiNpUmcxkwJewMg8mtOar1h1cNSlfr4S2zu+hxmN+ylh9fdSdJ0SubwxQFd+iz+mzHWQk644OPyN+0aw7OTBed3DqKf3lulHOEBu9g9HcGpbNyeboMZMb/zW5k2Ccx7ToOlOA8=
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