7yO1mO3rNrHRwhZJuKxL+ut3lm0el/SWabIskLRFbhw/96cYKslNaDfSLARJratrk64JJQdHPPUBenykKZ2RmHfBWjwjkfem1d+jT2oaRy06yARST2Beuj1FzFvbDHvFIkErMQraaGpWyNZqBGg8X1N9jsFe3Eta8E0cRNzb72VAL5lP5qpsl5W8ZBdKieUpjj9DlLgp2v+h6IyPesG4l+2b/2KUWpnyWJnlhxckA90iuPvPWrABFGYtouBMVw3SGRLhIi1UYXHkvN2wOP7cvkARXIRCiLyI+QW9JSafCEph+RaH50VP1vg4PTfsaDaZYGZQVPuhurOWT5tCOhY9ya//uQTYPs+ZM8XtOho6GSpPQhXlcXF4SjkT6P+RNWyk7ZMZtHIdFdKNCPiKxruoWp10njFe7qUfsxli+pKN8E88T4z2iAODhgL6oZcANE6Mw4YUP0IOjbI3nFHUg1w7qFyNAxmhfBIO06kJwTMebwmzKLnudVNrdVfTXCgCeC7+UoEYsCgHX1iW2lnV8W4A9PfygaXdByH5jmIJ3d+30VOxCD56vhPwM90jy6+g+hwF6D0ToSw6mH2Q1skDMrvbeuYgJH5wt6+BHnE+IHVVGv3Qc7CoOg7LJR5FtA7T75ZGU4dLZ/0iOtYH5P3HlsFlU2qQOd1GYulWKTw/Ca1QiHnr92g60m4SY41krN4EaPKffD+W7WUlcWX6tn3RRAjZUA3Y0PXaSRLq09eJD7EFjb6aMZSIq6M7dJqdkYtS6sKp9CQqmd/PXgNGGZAKV2GpFur18Yx+aq7tXv5RNpfJBpr7XEwqepVICWJcyD01ytc4MLJldLF93QqqGDmp57pwzIH3jcD9/NoGzlmSftEuYnDCu2ft8FwNOdtTAu9Qr1ZbVe+wZA15pRQR9/ELbyfoUoayp+LIiaJqGYxX39mcBWHGE3RiNCw+jUhXhOKn2L9X0d2RB7o79Ck++DJpx+ZknibI0cFnqQYsAEW44rPYkLtEdh2ZN2yLgVkx+gRwfpSAdRNaiMC2ZiIJIlP81+kwaK7Uhw5Y1LRmmtE9jhBOnyNUk70ffxF1D6Ocbgr18TijAUlcWNjM1IzVYwKdKbM56ZKaoh+Yd1sD0mGnzvYHHoWmKtPB5CZ52Gr1DAs3A83jvVxxTzMvesphyfx7vEN6ATtLESZJQVTSzNRZAEOQa9POx0b2MYx4cVNAXHea0/0r+zAKFts/y89dGwBNVl6AS/yClotQQOg+HVUOfIrFOrPF+MmxuqcTup9kmYYWuMK9nYwV9Chhn1CkIVE5hdEVZvosyfd6rLyzQnwnrXCuCjMX3RHRY+P1oNgnQzi1t3ITWeh5a9zOjKAvQInWynp6uw7LNJlIcNd+OLB0Qgc=
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