Z7k2fLqVuF5Sf4LwbEX0RIgARsDxaDqJhE5j90zaLNOcP21fADZCm7NaqYMeM5tOLyiBFpNRUpYPOZFRKF4WeBKObpjrz+6sEi4jidX+5zfokePzb+dpt40vRMiiH1hsjUigE4qZUJRQAZ+tEhU/ELYEf98HI66kJ9GGya8aFroW+HA0k4/SurIpWsYsKYinJ/tjJ7wqmLqSpWC6DQdGGbUixTw1SHvsMniG+XkC4KIV5H7Zo31xp17xotUS04N8MKTxfq44WSXQSKukEaHLciAhQKc6AKFEYfjMq7aQjdT7oB2VRQgDUXnH98H+oFmtHjRLyReESWpa7f6ZdtnfKSQHIYtuB+a8Hgaw4thxCYHeiDbnXcDWakdFiO7LYQHM5ZbxELenYINnoJsF/CgEHMheKRxhqz4Oi9pCspQzgpUwkSLZABanBypf3/C+pZe7Yg65tVckc+h0fxPOhqj17xRF1I/UhtalwAtw6qhclAbdiar8zzt4cLbf+oanTfZszACb5PX3WXbtqrsnyEocLCjw700tlsAxgUp05WzAMJPv2xCCBgQeLjDR6eZU5nvlEg/E2svqSL1+JB/nxmRV802eIjN3BKFJGIqOX4O2UbPgobouhC8vp3oWJBgL1n7poAC5ZW4Tknp8TGRzUldrASLP5LmrPwUkKSvt+f+OjlVgrkOSDow1Pv7owmTCD/HEiKSYrqRBXeux5mEj9/PzcQ9pTBEWNGZH6gG6Xru3ndvoaU5Qi2r7YGlN3vEDszRqe8+Ial5i3GwK+Oz/n9g0xZlfO8XcDO9V75YIgfEkqJfZNeLU2xz2b5Ni/xuiMJqLrx2zPtRPxH+3uf+W3VaCsAfQiXf1OMYO4k1TRPA7yEA3ZPZaDE5eSlSLzj2A1rINy+2qmnULIr6otjebnNGXhTqioKHKa+LFS1f1mA86Cok+PpBHK8N+xI00GBeJZsnIymiIxvGawVfSrH/2uqFDI4JnXrb3VgsLrR5dCfIffILKakylqiJoIRULzvatr5GIOE1X9i4aQbfMs6q12FnubiOe3XWW2qoMXgPBMwwXV9PFU0IFYHCzTg9cbwJ3OxdKqF9prk67An4vE4eK1r5uot5vEvEttXNBOhFlfHaQPKoMkEdfB1OB2wvkLuF9Dw77KMB/+55q1Q8DYSYsbRVi1mWQ1hjbrH9pLnWofMH85O8B4K11A5O8qaQp7xFljag886NSnuo3Fr0a1xISZ+ZJMrTe2rne6QFs0iCW+f6buFohOERTXXqp2Kb5K447BVvzN6VqjLxDtb1cDxwoNvz8LJnzZe6Rr8n07p2qQcxnIoyiU8BMOChYEi8iDjamCj3S7T55oNEQXGSDcHviNWXEghKMDvMTDG468ptgbIc=
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