atZ0Zeqt/f8kBcD5rqVpjdhPCrnqTPt4F+j1pPYkrnCxJBCz/UXhwW18SgahV3Rw+G1ArmjfqemKrN/1np3lyfH2MwziSOc/dxBErbX9MF8MK/BBiMZdgG2CLDjEj+a6N18d01TgZ7wUYQ4Ru44cRrThSBy7tPL7VLVVV68s0y5xRXCQ1cFofcavpcvmbsWzz3WqcyrIyFUNZ0TtxA4Wwz+OifkRxzglJrpbQf/OtPVDQokFabs5Doa2k/YEthqHPM/JLC5+kKp4AxDr2Zg5dC39TqHzKVZqLigpJtpny1UB9yAhSG8vZ7XBJVrB3RQTkOZ5NkMH4Sj5/u4DEIy+KVbFVumnkmyT6Wq2hR7tnZ8Fl3xen9r8IoQ+X2hOCJRBXNdWzB7VNMIUCP6+zklAL9Ha9GVy2DHLcl2cBkOAw1Ipcs147XCWyxgG0xceoXxLesYwZVOCQ1tF4cNvaqx7I8Sop18w5ss14u9b5JyYNVwhQqyj/qytMyvM3qRFwxnHFrigqvKWCHVXEzUAjYOaGyI5wOvI1Xa/VfxTwhR23jJU+dG0Vb+KoWDarWZtQns5xbX0gSQSMo4CRZH4JjLD5LBXVve1TeahUAUN/Ws0B9/SwwK/oAoStGarNwvUV1JBN+CaKPcQ2qpPYsrYMPcYh9naMhw7UFtjrFBycN+g5fEblvXM+1qaU0P8wkSDrPYqbW+Grb+SUn911+LwqeVjta3Sgh6fBPJL/wqby7mLoz8oM1mc7rgL1zGtAMC1sqmSkjfhUwf0ifEEeBz+sPxZgtHqTKZNniTBvQQCSjPcMBMXZPAUVroXUD5/hlO6/RagRhW8vhsh8YVl6/Y2Qqa7RgzYxDi8xTDIv7QTNXcFsgNuJfGLnlqFsyQzSM8fGiKmllc2AyAQn6tbcCv81ompMnI325c1Z1rgZOYKEi8U8uuQpMF2I2vs2V7taP8jlPGtBUs+akbam6cjgFZOmHDU8IbfgVI/1J42hqgG1lF5ggl80okdqqyM8xePJrcZcrxALbLfK6zVwrAHJGhWTuSkQj0SKqPy3U+sQesKjkafpd+F+AuQ87T8OEf3CLirasgmAegcbyJSbf5JQBq0JEU/p/viIBXwSFu27L+YaSCn/j5DM15PHlv76OhDDf1WSzLYHxjYGAFoGovBt2veUITpqEx9EJAeYKMt6BxggmdscvSsTszUx+XNPLhoudohYcBFU/fZyJnn0i3zUg06rn2rJxrB44ec7eI7ufc2+imxqezOcNZwQsfPln5iP0ROZIsz7ibj1IylBl0tAUvZVs1FHRwD9tfo2BoamHpo7cqX9jAoLufVIV3fj1IJ4f2a6HeB8onHnFmODeE9Mpat8irbBPC0aVhcpZXfCAREHwo=
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