1anBabqjME/HW6rCEJalU9D01crnEZ58wF6ppQNdMjYWcWttaIbynHUvVa/u4uYIu6TlQjrkBf3/5KFk2bEpiRqb3UCY3OAFb4Nep1gugNlp23BzJhf6CMW7+xy00aLxivg4Fo3FfpByv+DYZJ6bxNGnuvtrMDNYNrbGW6ZkblbhmH1sC2IWvOuol0BkD1/GiFjGrz38ukK6sm7xqfdnmKxAqyU8M+XMxquCQX27lOnZUhYlVRwTvO7W7A8ZcECOlQHLIZ3Cftw7QokWPs+DcXJF19GR3QsJEGbs1lp/fL/fxijqkXssSiAABIGRytsv2TItEK26yTHrvOydjDowzBe4Od/2p7D8F//p6w3Ep/XgPiiwDPcPpwBd2FLILeBjVWyXHRmP6UAN5P93Gg19U1ltnUnHP+5J2LbuOgmzvauZ/DZYckbgCpS0PGfJhNxQtpkm+Lpz1lU7RwZzGib5/x4JaJfHVIHM/IyNGrYVeSx81vPZACNenomqb3guR1okemYuOn1e/OzP+ZUsEjRQQSPD2pjmSbSdyBsLyHzM8rghx8qKy9IREdkWGW5tgR3pHd/TazTjaDlknJwlUxeZGrZwvklbtBXJpW2nRPty+6NCkIhHA4vcHa27m2bPQWCa++U5pQduMD1mEFXI9cOLuVLcKMGd9/CxVf340YCYVJ89TmvcEZ4W7sbAUFy9nunMmZIu/tQW1MJD3E8dVCKxbp6k3+LFl/oC0KvMA5UMKzHVCTvxM6WZx8Lt/r24ucZGVww9p9RQevK8SLqa/eNxhx6q7HWrBcRsC61FIcqrl6F41yrkvR7C7D+8dF00GMCPbXL7RDStKwkzxJ5Wsjm/xcLB4gjPueA6BgF9GN6q6Z60cnstUbBwlNTdS298+/NdKulpSzTLYkceCijRyzp/gb1jqw7o6xv+n90/x3lQsqxIlqeYsgY2gFeqWfbUS6jSIqUPALAet/dd+zN6zlBkRFSStXMrARuuFMwYaDv4EHH9YGW+3w980bjBqQ66tHRq7Z2WrW6gm/b7YO9lYkkA0SoTfQOWQAiksKKa0iQwTCXluUHesGu6fDza5I9ZYyL//6Y0458WS4SyTaQr9OQceYLaT1eVHkXmtfexRnOuyTHCVWeOvg1lPULpZ28mBQYWGTKJRru9tJ0eKBjDexV4CDvACO01sgGelI1my7HIBdGC7P8GKl3sNCrOCMF4BbGg7RpmCw8drhUJDdklgUpFNcwF3rrrr26jAZmdW0NTiMtVLYbh42XQ6j9v17i9Js6vZgaoGRQleSmUPRciXnToCEX5gvLfl3u/L2lbuXyPgXOaAqYgMYp0g2d2MngNYE3/Zs9RnNQUgiDuBAPXMnVsWebEtPNzqSFjX/cy3QE=
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