eNXBNmqLhHKhIlWCsU6MJg05xvUZzZhEqqo8s8eJd1QKn0NLgIlcGge927yZVNibSx2TO6IYjZvokZzaXMSBn7IJ/xVm+gMGdXvFgHYcR3yA5D9uscyuYZGFl3LrFqpVEFGcBR+d3fEwTTlfbynLumPseVG2Rx2AYQX8kG+ini9+8xfUKo+iHOzsgFu19bicB0FoXQIQ/KNODV2iq9/rucnQCrr24isiqzWi91xFYFT7RqMQqPGv8PNc7fK35/nm1wd7yihfvOBqniAFyZ06ccTGkXk3eqMl9OqWQza5F3ZIazzDxLueQQFS0k+Yr0eMjHYwwOG3UEVx386l6xRqHbdYBek7a8P6cgI/GsIWWOLnTxzVonqN+iC+fiHNrQIGw+StNC4kxHFevAYL39zaPjp4NdhmM0RkRsqOUsvGVNrVu3synCj/jySv6cqIfIpYWMyWcTtpiVvmEC7Zxyh2a3fJf4tpmLb3Xetjhly5Pts4VAZ2uEdUyeftnGGeTiY6XK83I1yuNILAsYFfsWt4rYQpb1qEC5h4DF3A1+sU6srbgGpQ9Nk3dro1sgRzjIVK9kwAJ8v+sn14iAVJaeUcTiFI7xqKrQxlogTBeyqahDomRETbJ9BnNcKARR4VpkLXQ/gANqJXm30AD88BRqOuCch8F8eR4sOxjF0AM4QRt5xyzKa64oGUw1tQtwZFFap8L+5SZCDDGl/NZoVMgcKV/Ge/ZMar22N8TIQWY8CWpbGFDKHCOhvPglFxK2JBUwd4HHLoNlB/tQ9qs7h6TFGTYeXL6mVpfeWjni+63rXwAkgPnvewV0z7B78K0/FQvposwUM5PiXRyGz6nbeMvBSnWL6GvCRQgZdEiFtdmobjh7d9iDHsDCTM3QsmvxNZgvO0KlZ6x8wpo0ErQZi4KKqINeTI66pT6HSVVNmlDe65oaVVp3Mk/+FE7Law3GM3i8oG2xvGm08v83kWVsCuQaZPr4mxhueK28cQgj89x7SEGAlnRpOb0s6bR24bYO5eTehtR0Iq48x7H51YefMKP8WbRR0dsYhuScHZU3zPevkcR1f4IBTCIhmvT9SDGLsWStOdwGmh7BmlcIj1c0F6t316o2FsDOSinCYKserw8x9WuDo6PPoa1bT45P2jgQNrmZaiviMiUbPhVKrLl1UrrCtXkw0YcEqBNszsBs1xDJ615YwWtJHGxqmnUbGbTk6I4u5b8MlqG8DcycsKPVqveXQ8ipOYzbBzj9K+R1LHH5Dc16uHlABpcVPa+6chzYTR1FA8Q/y9XBbupdJR4iT0YC4gt9rbaP4H4TEELrDANIBcd74wpD98M0UlcdcJpYJztWzIN2dnwJRn6QHuBu7DaUAvDNSSqqHJg9F5tBiOnUU=
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