XEfgxfOdA9vxv7geAsV3JCMf55ZLqczMN5bbTRl8gCqKCFgoWiqDjPM/5qUbCfcPMIONBQzynoMAAy1uyql4WcXgJLyRjZzQKlHJSfsXFNetzWHeZSKLy9iDF1cJnMD6DiGKO087pHtu2UY595N2zu7RJUD0IKflRJuAjLZ12G+SE/HN6dSR+ICoh7p1Nql/fTwYgF8snblPovBJj8WWN5VuUcLATQcNIC43YbpkIYan5ZvC5GiKmA/e6fox+bWCihzbi9f1yYOUvFfDlAdxMKQ8OEK9FnkRCres3+s2fW7gxVmzF5irf6TB6lYZ1UQ6k+KhVM4BvMPINyAHvBM4aZsn9W3GvoOuL0BQIARxA6myO18tc6yE1XZyJxi1nSgH16ZtouExuZXe1L9lZzR2hkJ9DDSbvR4K5JoZNBsgeliH3sKOsnXe5VfFsjltJUXM+X/hTEDxjyblbma7y0GOaZADjNt5mD26WF/ZHjxUO5Xte4augNbrkUHJXIYFuaUuH67FT2F6e9wKkhDnCIPfEZEtwk3X6+kCgnEAKjWNi040C9zk1GZ92YNOkiYrxzcmC3JbehdIdds67OQV2pER+QnDPE8yfdoaFgnsqDGQJbtDgqaTTMfqAidwkGU7UoSdgEfoJo0hn/r5xdV/CvEYLY2aEZOiElAeqebBZ+CDQsPlrIQ16FiABIVCDoKSl/DsEBKHvoJjJF5GW2Hd2DHJ2KKtnOYY1R82BCBhcHYPb0EjuuWkxyN8VO38pzMoz5KhS+lbiDHKqJEwyWLPQ6XpXf4yu+oBQm8vx21s3K6babTPtEn7nBWVaSpS3nHapRlG8bTV6Cmv0RJ8P5844U6QZEgvk9AT6Vag/Ch3EckIMOnepVVu+rtpn5a4EOdVJtF42IgRUe0TVhbVzXkKSl5u3DUcNIU7GT/DhZC4dRlEf+ew8waXEtBG8/olaSb2hCVDpK+sx5lpzvTw4Gu+UAoOoHBlk38Rq2AMMuhY7pTVnmmqebehGiaWkuer8hsnyaiPH8/pPLWSfunE1LC9Bp+EOXiR+uzql6ff9rIlQoE1FkMgATSTneryDYpUg2URTb14KLUYMLNR+cWsTZJYSTQI8PjZd0rvi+PSC8Ztd+AYL8mQPd8JqZ2778mCcBDD8r88AZXDfDiZVkUQqmttEVyr8qECyM4uQ70cgcv6C4D1DhZpLOFagvAZtO165utlvtFgPFP9uOVita3fybw78QHdMUmFNnXrQ82TrjcA91ewrcGlpM8rcVn/Xw1FKA4cIe/qvjes0B4Rwg5048ahZ2wT6cN0o7zEmqTID/3hw9MaOazyEPJ2D50iXxKhZ9/9DGi4Sw7Kg04pCDDow5R9KRbEuYaQioL98xl8YaDw0DA=
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