AZI6qQ+DgZ0Tm6CHOIFHwaKh+e6v9J5nLzEg0a0DVm5rBqXBEtlmesvklyRS5j27vpbizHMGChGjsc93rgLzqqH8Qilx6bLp1dk9FimiuoITP37ETCSGkxFE28aeueR9LgTLSw99E4FftIqsJyiwNNthrjyxZL3+DOQ6B/Byl8/JtsuXG0ckglzkbS4wN9Q61yK7+U74fy7CTdA4SDLV9FJhrcdhVcvbUzW2Iw1Y6YV8R+qFKB7C9lSIwtLSfGscuv/y7r27npJ2tAnzcMxuIjhdikxk6n042sM14O9Mbnm+69Lk4KJODYwox33eDChkPOstTTjSGFVLtEYqX+SYm9IqybV+3oTC63uS8O37h6LM2sS3EXixamMEqFRbOdrWM8Z5xPM4XH4bhPkMmTDMlgNK6M6pPdtAvNQcGgGy2eBamNdZT/WzwXmWOVm4coavOhp/+1apcK+KGO5Eov5KYkrs8Jn1BY4IP3WxPykUzegR8fVWbcRBMcMiK0dqSDSEuj6nMkudOZFzWXFimpVn+yNbfxjsYedY2mTj2M2T18tVES7NQePPMT6UrzoFf5pSt8fSKhMOWLX1t4ZvVkFt14RmX2hVI5xr9PJWWhG6/1OGZNqATf52WoFGYuBq8nurV8ybEsMfBYJ9fHJjh612tzX5j5XPlp1GYqHh/nV6NjxSZsRBvFHPwJmOh1ycl+82YKcRPjhRcYiB2hqPheSCgqMrbkgDxbW2bD6dxk8xZwTsOLe9s44dKqN5FyPvxMBihjOl9ZBhyHkPYuD47xupZWMtENwhcf0V+JxoHkpxwH64cDtxyZ8KIcvk09HX0113/5EZA+3cu8HY6TjL+u+Uovioku/lBhG04RDNHg6XR2e7QMw+U7eDbblyw8ardM0Lc8q2eo7h9QUoGlLzli/3JXb1Oa5rgJiMNg05MVXOGTNSdjc307Z3yuDfQO0dqjNVdpQfZKa3X8ocnxOP7r1ikSXiie1DCqxm03jTDGXza27x1okFLMsRfOrsijopsjlAt80sbud6cdajcH1HYB7D/oUWs++ETqHzUgHgWqqri8DnIi+J9iMpkGHzFnqgjv4jHPXkvqjZgb4OdnP7T0TGnR+zTRfuiU38UhEquMujbplC4bPmkXLbtwMtZvEXfgSdFv2f8kKsYA813ecdAzwEEnKLAb2CUNjLh3bNp2Xo5H3rG/SHkqMJBOAypSwD0dHIvnNAGAyvi/fBqRKxs0ua7BStXzHXuQ5Hg1bho9OysQOEDGGUkLCxGX6tC4qexJqQjCdW6rm3GMJ6oYtXwMOlvUuqmybtpQh/9q0fN9B6orrM8h1+mLfMLqzqWih2hnHbsJX97JqOwgdVSTeUvtjYvULctLq8UBsb1178+dY=
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