Zb6OyXbLYigGKl0N3EyRE8RIScChL2Gc4aTv619FKxwsZUmRkD6qSwdImGSRjAmTJlhmTfeztl8zrF8NXQmdu8TdNNKrezIg13xuTGtmiMoRUlcNocpYteZtZQ4cMW+A1FuqKhYUjdiNnKnqgRu6ayaO9Lks3r04ZFxszgX0HeQJ95gRc42Pg7AbqKD1TaV5NdvJ6e76ohXuMPnKjGRMsjhbwoH/TQS8Iq0cLROFXPaMbzVZjveSYQcyxZ1WRyOiIuCDC7Iao0KpMnRrMFC3fC4taxgfYJAM7ukniscTu8sSYlxT66wg2nTThvM7l9r4vxSeXfcd0mvcieUC2s5c1BccGCx5/ZUqZxFcn251ItrDSUo4kCwIDzdnq9NVRIXLQMDS2/xbXlrJiP/Ga1ajVRn+lke7g3XFjptdpM0VmmA22EwOG7ye8I3Itnuky8+M5dUSCv+L0vg3NudGHAMEJPqi76QtK/xLPlurQ8UtGSkj3cfQwPj+sYO8b+BtunOWsR8UkHWABlYdZ44kro/D0hZDO4THPkk3+JydNENPwRD/6aMOvwvPcobOnmclGeGIJQLw0CRgEgjlTmonHA7zlbcTfnghgfDl5gXSTiGhUPlrRqVoqIyLY4o7bK/V6r6LQiSpruMsY3trP5zji4nhf+8/KQdoIs7l5XoGwE4W5FVjG9rNYE7tDQZ8UTJ35upYcwClF5Zr4jj4VNZoErKWJsNfkThTz1Pu8e2a1IMIDVbieuVXN6jroCVu9E725II4EhWOyL+D3nIU3iNBDb+ebWlsxISMN70kVoeb8ZOVr1srYGew3/KSOWfDvqwZ6CIq9FPmagsitb/vWyL1x5WlxxXyRjWhQAsVY52FjDlCT2QlU+q2EuhOGymsq9/HkuPAJzBZzRC6pc2sIxd39YsfMxW2j61QWn4tXM/3Iyncxg2FJVvXQB/kbLkyWohv6EoFXk+wqu+Eq3hOAHh2ig8npkNibj6g588oxyymVVbKLXOkfBJ0nhUifuBK5EEto5WEz9SAGXTF5wkaxFpBrcCMbjqe1WKfyLAbd6vzrHsobl9fyRYJlMfs30hTk+vfz0sf0k1nBVlELyAxeQ0Mx83Yp/jRLdPmtvDO8nC68kkPUWRKoz1GPGKSs09YSUlQml4SA5DdsMfO6svE5xYh4xSRXvNWu3zOxL8CLl1VHkBEeulKkimXw1tNjVtlNCtcw6gsDO26pOfu4qQBT9ASdFsbH2M5aN4rxL+Woo1ebcYekjgwcRN8MoJg0j1qPzTxoG3GflM+omDT0xdkfbzV33IrRqYhPbrquIeuF0eQG2Y2ZEFihnJvfPxm5GtRCGbKtQUIjP8yj6Hsr45TwvutyA4po4vLqadMppWVtgOVwPE=
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