6UeY/XwudSraipihnS4Gqv1/tMiOdWrXtYmwLuEGUd6WCDuLq6nZLEE2U3CiNzoBSOsL4lnaX2IjMQFLkinwlSMwwWBxv3b3FMfoA57a3Tjbdt/VTz1jxqVJbEk0HzF+wBAfPOyhiZ1o5kEqOHk1WbRuOjFvuKEfSdKyBR6fNngqHJYlTJ7frnuqKXk/PN1JtWAZ9ClBtf1pkmmcgZU1yIQ84ExWeEzRAn4DLcge/AFIR73rJyntIHssQZKACkE+uD+cFp+4auG5fkLt+us0GAm7tlxDyIxAJrBLluuTkVLh7HoDD0BB5xDd5s1FtUVwuVs2p3XkB24g9Ft7YsY7SJWzS7wPB1N73wtR3g2pFzAuIJdvZUkJJkOvQ8biuTGXPlxapsGPoL3rUnHu4dfSjXXc3O60Hj/6DcRXqe3bbxl9T62YwTX9wmsqeYfQ+/jBx29BkMUG5CW954GaowmEFPDvoxJIGtlEXXWusKR0oBOcIUaf/uF/G1o7laLwjMCUoXxYW7uDjzSuS9cWViKyakTjL4hINS5G2SddQZDuvtAlL0eAoZps41uJeV6r4MnGe7d6gf2gQB3D/DgueOehWnERh7XKjCBJhYdqpBLwrNChOMhXuKqF/5zHkXgW+183fCq3rCU5G/+ZKdtZwmuQqdlso9gzpPe7crH6yNf1YEFT3IMO//EMp/rCIkB8tmQUn/EPkodsKvm8XByU/SIbsxU6viHQdZdl22q1YfFFCX8VBYlE0bkmT3nyPACFS/iCtp783k5DPIFWSatM0LbFFEWr67+bqoafMl9zS/K8RpaysQLYiJHJP36AEYdGbkM9jafrqDkXwj+aY+B0vyzaGh3Yaio9cT6ZHlezVTeMKj8zzzn+0AOO8/341dmbhwCQVKFgvEGRJaoKoAi/J1SU5mHeXs+5nNh6NJJrJpEO8Gk5lTdu42rIEfeUhsBKpSMe41cDvi087q9cpEZNPYBSv1jIpmfzlb/B66bDyWJbR1Mq15DCNEAOftSqE4VNn49P53R5HG8GmWex0bGVyLA0iiEE6dCX5fSiEOMhqZBP3Eqy/y9IGBDZvirIXXEA5L4gWe/5BrwLdyJPaJpvfAhSCXX6MW+56M72z1ziNZY7WelNDTWQuC7xnjsufeFK+/Dcd3Gl19B7Fiqmyt/WX/KtYdfcOo0PK3rF01eUlHZPMmotXgykfVtI/OqJ+YsZuyHwxNMZtlOKUagHRSzn9CE1pANh5ZYx/ei8k0y6OAR8ar6YfmQdhnh8dgpNrkls8fHK6AOca22sorenBqNlWTER4id5RX3zrPs9FbNU+awJi2+I9qfS3bqVKXvMe3YrMaMNJj9hQhe8Qgsvh23YS0Ig3pTbVHS5r40jAtfy5T8=
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