7fLK7EAyeUuB/phHoVIfi4vME8i6LjNYY+8D4+cE+b98sBe9b/xRp1o9hb9Rw9IwBp2L35LC639adGTIt60gE+WEryNj0PAKr+c6bUu/RaNo2Gotl66J9/6Q56iKJa4jt4twTLW1quSA/6cMMhZPK583sMoXz3segmlu5erT5Cfck4BhBLQFmarAwhdHtjnyBfZSNSFL4BAZK0F/gRu+trWuw14t6S6qzlbs47YHjmQg+pdBv75I/+fC7y2p83APn2/9xenemDO7cf6y6866xhCbEJRLKK03eS2cvlyNjd9tMdjqundFBvKYCQv2ZAfORK2J8+N291QcolRw2EcoroD+sUoW9mtGw14rFWnSkng9mi01iuQFnXvLeUVB4ySR59mzgaCxlhmIP4KCLFqbVVOkEwEQYgbPFQVgCCrsDnX55PeRgKPPWTeIabS1BOaTo40r8Gn1YHZiUoYtDYY67XQUDGFqf8m1ko9pRsr1dwk51uuHBQp+epaWX6FoRHrFvkPFqR+NQPTjZ4kv/MNoyu+BRhPLTJvsxLUXZbPVGAx877o8uVHBt/W2NVYeuOpm+z/Kopa7o1A6MyHNTYUFoD/SE8MxFpZyZ13Vg8MzWJxnaaJBijS1YwJ09/W9hfL+6j2nc4cDZMOAYDXOWFEkAh0o6/IM4UcEDKnMuxTZ3pJC0HDFRPHrPGST2U7fMkeRn1F9gaO2bvIMSvttj41+duNzZMxYWHXECC/j8JWrut0OeTrzBXozjwRZJr+5/wHYS6lCv4MJj09bteivfmWzvJHMdCPALfxWVUa+jw67/fdFZF2vB3NriW1yV8M1ZcWoISXHUOoxNZPEaxZNjYqMA6kikLjJwOShqYlYQ2FhWrn+1I3EZrYI/F4fO4WIk49ls+8YrWRB669Dgy4WltdF0xmAMa1Fft8iN4fdno1MXvvsJ73a8b6syHXSJbfxET7DCAkKolvDckHwvK1I2H1Vhqsum2ZiFuSTa6CynVSr3FGAcNL5K/Dql7qh5aUfokb4q6BJRwn81T/srp0sAzGtI2cgb19IMUTKkIlTtcRoh47M4PPUpeASYOd4tU8gNLQCfAyqCHv5X1Ixbmf2CsZt79a+1eROmuUXwNt5E9Vn+vPitL1izb7NEPqNrzpgW/tSS6zT/KWWuEAhNVsdBnugILNJxQYIi7JFvfJgiiyD5Lc5prZgia9YwL6nBf0jLW8RiErGqBs1KbQHoPTifSjc8l5Un+sBpIT31YF3maQauuxQC9mZDHFoCf/b+1TD+7tmM6gnfSbqgfLNv5R8kQZHVjWYvCrTTvFZg4IIrB++R3coig+JqfpEpTYe8S/c/YXOiNqptRBKmoUqknNEo1Hmjv7/9i/tceTXVx/21PY=
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