yM+CH/vN04FOGvS6mEhZGZg+IegzQwinAGUTPUmxs25jPuayRwf/IFiobvA29hcuGHVLoK4aO78M5ntettrQC8+02EEnCGIofISDua20F9bJkLFsZDp84pDpf5++tJHFCiHkG2ORV4K5uzHlfv5rrAJHvle4/Xl37FyRmWPFnk9Xt0Jh2jXU1O0NOhhuVONP+ibpytnMuVz843VgetZg3/dqZk7mUw3NO+EhQa98fHIQE58cZ+e96vLBLyYsFMNV2rOSMg8FpmZo+VQTUfL5QXrXOmmkbjH3jmqm9/k6F4GpCrT52TCNndI2qAWRAYlNVT2XiAmtDWmUirDFLvpoc9YuwmnQOxm5AJjc7My/cp8wmyfbC0uUV4zxd7ZyGWvY4ixDEJ3mRYxQK3pB9ln0MtOT9y5WSS3LRw67DQlYWFzSvCFRXgUtWwE/MxKMfuOVXB7+Y34qyu92RGOHvIEJ6pJSJmy355glxJfalhU5uMR92O/eeSL1iAIILDvvsV2B6INrZ9bW8v6UP9cPK9XbBB+lVgWJs0sndvjHTFCOQTsXLC3Hp9Rj/LWnugAZEbUWYXBeNQUhZZJseEiGJgvVS/G3Eo9VkKwk74Zf6Y+gRnjEzqIB1OcE0gVF4kFpWGuGdipJolxjt5ADNYvLsips9qjysbEAh9QxKrVQx6AW3H2QwRH+fIG959iFpI0E8aGkC9CInqWa/UO0ErXc2iJS8sdJ+zZard4ncY87NHJBVuZqHtu/VVoN5+5675fohqKWZJQFfQ1a7aXTwqPtdEl2lXp6UArfWg+hkYcNYyHDqXRjMxOWPfgboRCUMVS5jSxLexnQ92n3qfZh4Bcas34VecroVT9fyG5alMdlTgdxrrACqfca6t9K6ePNFWNikGgq1v598aqoD6j+ify8Opkp7rz3znPh6wGNUY8LFV6nt1UY2QjFSvRVZHoeKC5tkGATJv9098kC2mdhpWthevr+TftENK2ATjkScEiuvr6gR9sbTkrP9CxM1oCNwN3fVy2UNgBILWpqJTbE6IHh1HYgsx8fOQ6xm52AhZRJp/Glj0Z3aurFwxbkPHCARgalPNsfiLLwDPn4j+m7yCjErYDtJKTZpwxcW3I2PWLJB6MjpoaNczDEJPdVOOPTraMxIx0+pr5+ECERY/zHmuskoy8JBnqqT5BxKTAaEhKQmg0L5JJQRHNMRdAivqogGbE+1tuVmtNwXfoabRQGNOdEtiWvb6L6HhkpvlxOs8NqUeYATvvGeK4l6+ZWxjQhkfONBKU1avDmxnGRP42o5Tv1RrTcH6RK5fN8+i5sfp5etwucrfZM266K+oSXUaJQsxb+W9rXK1XlEKEmG7wJRR1bPeHgfvRtnGT5tFujeCWg244=
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