mmHFMcnt3eJG7xKA3p6l3H0CvHTEhWiCFl9U6d8Huu9eUboetRV5fRoGBNnjZM3YUvjDafC4eMEuBJfaUPNwQSgXF8TpEG1Czcq3AiGC6ousYZXX1DslU37zoENPJAD2ApyFrgAQ2xAJ8OHzCGqyPtcG2kT2U1QgRjunvLdlWyC51QNwaWrTW/WF/1KHUQys7m+Ga2y6Hol8ubBs+5WQaPnqUnwuaO9oZz/duqVZRU/FMZGGOfoR3NbX+IjtUbymcRa+8YKTeNe8+tnb1z6iCIth25ipFxSDSBIs3HBkjOJ/na1mviat0rJ6z8PNkHAcb84zvPPnDbuJZOfnfJpCr8HxvrTp+QWdtz6+x9+ZVM1A7U5+ljUilK1ruN23i9BLDEDtLGf4kG/KUAInwvzrn4/TwMjUjGrrEvaGkdRmSUCe6FpKKasNoqzTcCqyuB3RO3IN4/eU2ujJJBqZJbqGwyc2mLGq50JXusQXsF+NgGZVM+F17hBWxU/VPJcYksphd0PXcTK87jwuxAX9mfgXQH0sLxpJo1dljt8tkoonOkwQyV97IW2uVwYGmDQ6OVVBt0cN9uosTTgBeoOI/QTdbuW77BUNFN8LOTnKpnin8u7RrOLYQ+m2ngZsxU+J+ZvUUgx8LGYzeKjcrV/9znnq8DNA40hl4XwzrFloaXIl3j8rInkJKw+2tvNOr113e+bsAiXrcn1QhjIYnzX4WIMoIcpmEvzejeBrinS2w4EDzh/+vepvtjB2sZ9BRncHGwIkki8KxebG9IPgsAVr2Q2lIos1JyecqKvYv/J4VxZk9sfCTrSg8kGvVI9ZtK3XdB1oVEYdqxwe/C+ZyRY75tUCV2Tp5vKcfdHn2akMBxHetIZ16DT0LYLGynuoYMyGLJn+Trhxr042zyEDnX6RViolm+3asI6II8nmoN9ZYtLBTV9WLl4n6t5C5PuOIUCacIpYp/ThPg6ju5duxMKtH3zdkEC2Wo5a3A1bgt2OFyBZqZVJoGEsIIl/Oo1HLlvA1aqR2llgBTwIQpAj2H2kFlpFPGqZmILrn1y9wfh0ifBzAiVbPEw+/ZlJmGO0VqkMvRj+N0Hnb1of5BXMGWv6JGiJo0YepVv9u/GH0a3hUXIuApJSoAT05NLUGDHnrBIn1nUUBATjMVxpnOnyXGGxaxxWQYimDcNJl/bffsYyvmXyZ6VN2A52oX8Bf16D5OZtKUcEGaEoyiVWkxA20H25eXUYBJeb7382oTOtMqiggx3g6VpKQ4vSsZogAb+uIybC6HyQ4gw4ZQnXQTqpljrRWMdYGeWa+yxw7/9PsDWYXd0A/tor6mGHx/9u8F5Po+Ps+bhu+8rdTSXNsqbpO8SV1+JqyG5nLo693vRu7+/S/lQ=
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