WSKRrpBDTCGP+kUc8eri5RDG1K9jrLqvMikJJUhVXtKWFrYT6AVAVy6JeyRRv/sRn15TD3rVr1LlobozU+G2zlmsk89uqaLsf+OE55olH+OugQSYswbVVMM2Cj2pb80Ek4Bj5MYq1FoIdBlruwQmNHmyu25Wx2fHYRrAGkh4+JlOYbxXgaIlNpoUGztUX4DB7NBkuGsgfoPTzo3mLqTQvmZDiz3eRWhO2OMHvrMrcWjr5DqfQoruY2OAam5v4I09gVEHC7pssiPYMLyGxdsvIFTLlfNwFTdpcVviRnwPHJBB3SL/LlJsvE4oJ8vYH62njzV7Agevme956h7FgQ6kuLRfBo2K7bAGdX7qnB/ggCb9hPTDPyXPeg61E6/st7mme/8K++bDez3Eb1TRoMyqAg4ghqLGiAVl9hLCSd+CBtX8QCKDIITDF/gRMS2PcuwlPCJroEBtvA+1zNJwONhofq5w3au540BCHukj7DBSUDBgnzH1Ew9O21jgkSs3Mth+M/MCxpcfsPYWTmdsq12cGqTAaqnGr5NI/CfWau0sgLlMoHKvazsA1EHb/tHoCRMilPMBakrjTKIdxl2/vE2AC19vp93IdbwzlWjPq2PJ7jRZr6+f6Y1fWLpPZdW9Zox2LVoFtZWpDeMUD1R3lL7YB+7ecHDSAor5BdL1QSluU6O3V+MEQYLHF+qVrE4g7npKM/zV0lXD2qX3umXk9APT6LuKLLKeUAJUbHaPe5x6IDewsDoy/QLY4G+E560w9I9Tu/wSxEhlcfKjJnoY7Jw+bD8mbigFqGPjLohhJ0DCZt4iIiYtAsFTEa73ixSkqhmCFL8Xkelm6d5aEFvxU68nEJU7hMox+ulavSBjDRaJXFUUUbM6BN3v0/SRfGb1AQal99qcLqI8RsEVMbubl8fZkdyfZZ4cwspGlk5TW4WnUX1EA349CN6pK8fr6wVyEckeJWtijJQOo3yPiyM2f+VWb2CMcSQNIemgp0oU6gRSQBLP6sQ43kAFnur5rlSVwg/pPFVrR1u8vDuuIRKe8MUIRm1mE3biK1VWe6QIv7SSHkC2jeEMXQfUuvvwQBiy9ibBGXhezKuCrdBCap5z0ID4qiezwS50A5u6toYzDbJu+lJgUz866gO8bSWfCS1keaGiDkwTvCUA3oFln2VfrEV0+MJUeyBs3tnEJlNQbAHjHfBQmLES3jc3hX/28MbruWiIPnnC7q2c8iM2mcIyWopGc8cFR5RgqXIP+oUF8a1zubsmHiN4nGeltZRc39Gs4ev234cpBf9kJ+CDJfE/XXLB1SqDBC1eW07dM/KeQlBIeUddRablQfjOidM2RZHU86UW1+IjJXZzhhll5wJR3Ma4S5/PoGPbUc4/LiCdoIU=
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