LfjiPIA67fcKHlsXIMFfKnH60yaRTzaIDuKF9Wc7V/gWToyybSB7/l19AY+nZUbQYBf8/VDQ12IAfgvyfB8xk/4Zg1L9notP0TP8UgrVAUlFuc/MLXyxmqI6uD6RO7VKfBwLnxU7CX7btf43nbhYm2Z14RX2TnkZ9LQ4i8byIw3pT3Df4tiB+YVTWVHsN0QHpKUds9fthuDXzXhLQURELvwuBYAh5Eqix4++sF7YenjAdQpy7Hs65Fy5r7wcnC1uyOC5ZyzT0PFGIAMMxENdOHmBU6jBUi9aPbrT+5G3jmHW0LHMmKG1LsjPFKwD2gAiytQY+ldTvsuXdGgh/jSHt9hKPl+LCOFkRNZKMpedl0Gseyf8SEDrpeGz4SkF57525s+gRu/0VruYNfdjXbEvPMNn05cdIBjyn9MqYoQJ+I4Ro6aeO60WfiFvyuF84LH0WLi0EXKlhtXj9TERfys0Ui/vF5OMcWycUZQXo8pA1jOMp4IikFXYEhWXEyBRuQcHaXGvuQFbW5/SItZthkV70U88QcCWGRLiGwU8BEwQWOKEeiTeMY+0sJXbGMy/wNv4r5KKsVUz6rf9O3cZSUp8YO+58omVnH0MqgfVafT8g/8y7G+O36RWQlw3SimNVDmnAvGjeSq+c96Ymj2TBPYKmr+yXpSIZv0EusPvE3zH1Ekt7zy45A0r4T0sU5jUjxsCvYbDp+CgpQ5pIjCk7WpVKt3afOixmAwfVWkIZCJEuksgDYiUm8sdco8TgKZYZ4fAV0frOw3srP54jljoNu/5b+W9udpr1whPvMgTS/ppebSFP+Nz37SKFi/gOO50N3bUg2L5J2oQrEmh0w/mPUtr8VqDCySzQnESuzYTTkI9CPr6WrqHBX9u6TqHVj4d6PUOxGC0IPSZDEw/c6V5puCP4Zis4D5ZlMMnu2SJOyPbkkX0viUaYML5onOhdB8qSkQERwf7lMp89g3oQMYxC6Am/4ihuZjQa+wJjvXbqPcv8I1uZPWKLFPemRC6ZbXPb5hqa1NbYK5ccwvaBj3yPbZEUdX1fSFngX7GebQNSiPp+gBdUH1IYKoR/bItFB+77QZipjc075fj8E3y6bjVvWhwuB9lffvoNBfD8tzAhzxe71FwjCZM3Xyi2LPIDOW+nIP5onXpYEPp9dva3MDJMbfDe05o65NYuRvcxwX705hjqkywe4QcRtv3vHEgN2GVBabbQwIc2sEvLUXpQ3BLzaNytLUKdSONazR6ag5HU0TYqaDF+lcR+E8JOQNKVLfGgwa3f1KXd/HM1jIh8AKryax6m8hOzQUTzOLppGWHL25cIhjpvhSDliQwn+4PLmK3BW4hOjZIFJz26DfOeNzf2SbYfSbF91JHyktkBWFOL88=
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