o8SCh0Cu1E2Gk5IAvhd0EMSvd5Z5kRgkiPmHC0X9uiHPMBQkFqpl/IwAmpfwUFoR66xx+4ddoseG83VYvajdMNoby4WVypsJumY5Z3pNletUq009YZMXWO/mYABVWLGJ1P07ZOxJBie5f9IwZH120qQ13+NZ/q8ySqBxAUFXr2WHOfTRYmfL9R6jKs+X9Eje6e8XzUc4neisV8FvyTd7jPBgoWBOSa0YMmDOC3gz10iAmdrXUoo9mG1NOMb/T9xov14vtgLW1HzWoNLI6+aH4NXUvME1q51hBu9aMYy7dxQo674wKBWFtwIEJ6XLPUZYecJDr/9rSg3gTclN24jmZesndodR0dcclnyqImWerX2m9RT0lKTbGgC/JwR/PLCNNcp6jL5qppMCmf/FyLzwIq4zByPeGkiG9KD3cB22M7eC+SJiXif14YauXSGsaUmWlyhOVjIDvw3bIotHQ4BKySW+P9I0rrObefvx1XF2CmelAmrhFqzQksijxUdmQs24Bbf9tNaBe3LQNorDhfhZZ7rBtFPbIdGo/mW8neToacj7r5s8jLcY2MNfxbszYS1OgK8uR5MU3x6YP4/3zJJ3+OA+x3P1p+HlAVHoiEi6nzK5SsHqylb3r9YSTIAowbvwn+U9L2MZE4vK7k1vMVBX9mHANFrb804kz4t5otpRtcVKp9OG/+qv414Rc1u/85iuuZXH4c3KgnSpzNYMLTOULoP25nH+8TF8bwUpFPSOr3tRMaCwrL6/ESHRxyz99mjrFKBgFswpz/nYNRmtmuRPp5EbdYyTR7Th32b//e0IBTHFnzip30IsynZq83GKh02m7s0cMUqg99oPErf1GG1L2gsrRowLaJmiKkoRUH1xplShcliEFYF8Rhh5LD1oNrWkDu4Y+itqiSoA4jc0e7TqOzuILtIAAwnrQFlDWw2a5boK8egLqdlXuY0TrNiSAgpGGkM2RyOTPU0xp21kI2FjZXuoe5Px4dh65mQcPM4Or1dSNrmtj6OVS+Udl0y1uCyQgup/Xwkv0CXrEhJn2w5Ut5aVAKQhSylULpm1FptRFcJe0uaFbe2NDzWFi6PoBf8559C/+xWpKWRpaW0fVWuZoEOfymPSW9W7Dgk9Qr88N1oz4R/gVV2F8bDH1JpeFybkw5o/bGu5LWZcuh6A2EVnjMwGsAsyHWy5r7Yd/OCvFgxMGSIc1N7WQRBSbaLXg8dODH6R/bCgY8hHC0OoXbrgeBKIz5RlSBwb8K+xd3NJbxF32UZ5H0ONBcN/igSeh4dsq/bYH+6fHNz6eTy2pL0jKPpQ/RuxeL08FPasELA9v5fkteEHbozVQqsyJN1pYaPUCUtjvAxTA8mot9VbOE3tmVWKia/5gswtLxlGY8U=
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