maGYtir8Ne0lmB9KwUdA5+RJFiibeCbG62eNSwEkQhxRal7zEgVrn/FRkAV/GT61DdRTqdWnPZBroI/D+PLs/uWgyctEotQvY3ahiacR9Zna3blLLJ5crVduP24R8yZzb81emj1gKuqAc7AHjrK7a7ZzKGXCaiXrTEnto9+HwVnIU6mNNMt0B0sy9I9mw+iiU+d1ab0LrTttNrddRaE9nYFmmVG0zQEjTxq8mryW+GRtPMwYhlraVKvrS4G3g7ReltLdP8hlMPwC2PJ7dOXmJbMNKNoAYcWYOZwWgru9xOjM3sSd4CUEBV9wHgcb4kOoyaNVrGaDmsoVDGR0LlyUttOaXE2Bw66T5h84YjdXTXS9ipf0pgFPhqd1mIsz6t2qf4TWomYZaFqvZi1fRq9ReWU3ccwwUsLk4Bx8aSbRoaCjdg2FcBaDC9oXSnyznQ/uAuL6bSYcRiXIRcDT0MCMC3AXSb/WU/O4T/I/c/RLCcSzwxGghQYh4+iL2AduiM2o5b+eGQwwbfzdqMUfL0f/rgAkSMG/y2kn81VAcUH9uHIVE6+Zn78pwvbSlPR4QLsWQ3wUiEf5Md8tb/Nt7PVnXzMlSIsLA13zk8nsiESaVHEyntpzEtYofQEXMG7WVb0r6QMqCUSQe3Qcst9NCkbVyMyEK6LvdoWxdU9tI9vux6wiu46GTALRVWBbnYObtSiR6s6ZANkhSJdCszVeyRaxR/0cvq4ClsRGBdNKlNcckgQS7woo+Y/rOZwx7PRkuErbPeLCF8EfXSXm7ex3llgyKWvzXhBLqWrW4nMZWovCBr+iwjlP3+DaaUezsM7WYqpYmvYQTQuON2N4/oFU+CGCkXlQN1/XSWrNcFqEwzlkIh6YnSOZkAdAIWqWOw7TSthjzV4b0T49CppbD224m2OwFtljAL/lpDgd1MCluLO4naThH4okM60DTiXkko3DRT4vcprYb8HnZmP4xrNiunacfnFH17k1Vq32qZOB6QvElv+0LADqzg2/kcKv95k7szZ5TfBA/q6PpGSB9rSHfRYZUxWDp2DWkl8T9Z5sIo4hx0a3Vefx/pzt778kdywFp88Hlb0HnJt4KlunT98yq5srV2hkTKH1uNWAAU/btP4kc9J20r3gBKaQZwJL3EhCsKkIlvsykedLyQHV7dr3ybt0O3OcZsrOlBn5e0tn18UwDcO7RKo2ry7Pd65jmtJRH99Kj1ORzEvSPVw0zsXn3CFQ9EbJDJpTH2LRiTRqfKXX6vxiMl+TIvy8WN9YKP2ThoNyENJj8br6nUGJjj+LW/ssaS6z0qE7BwxuFYw+N74ZLYvdP/ePzX1De5i9eUCFgGpzKXV9Y3Y0RwAoj8cHq/48CgNAgfwPiMN08nahOGw=
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