rTijM3UxaCwzMnPbAqeZmg3eb/hPMfs5uKuRXwnPKGSvuNfa9CkDqtD8ERtJW6+gzzQoezS3AXV2qHEGRE4fwLxxH+C2+2ysk42cme61L9uVl7PZqhWhuzyc3SZeYFUxj15L5A5kexCI3koc2FnKI/fu6njbJ0kUtactGfI4knKthDbo4yDN+/X6q6mXcJPlNjDjm5XXOJrFJTfC5FlaUKFpip/TUCFhqwAsg2VsM1E2MS/GUCFPxdh8HQyfrd+P7O0MKjuspWP/DQkK5TK21TqRa48H1sedhq0xLmprzpaMKOXspYDHKo84taMls/BCXCKCw5roblj3MOs8E6RyJzVGcQYjWBmMmk1/uwtjdmfknCTOW5KvfoQvbXC/zG6e9eFzvXtErOo3irv/QkSqNdYxE+Ns/QtE7BKBqqsZDkBgAHxlf7UqzmhccFrBvSSSGMQteYg8v1YRP6wQenSZnsD1dm/fPOxqXxriwmGJkBvOEx0NKyEWrjkpr9yFOPPm+Y8j2nE704wWFHuKea/LJUmDxpQZNehsMbZoyMmQFo3WxD/gnXqj3kuVtFafnn5Ohw025YRLQudeNUi2XxLZntvTBioq5PSc33EUJs3dLznQVxIpy/QzLIX+RsSg9hPtDr9valo87D5uO3cfSs+m2ONMDWUOMjXeB5FM09MD7AlHt142WA7+QfkixRLJw6a2GQxwqw9ZB7CUs0SoqMFsfNSl1x1+snL1ke/5fpd6knsnbn/AVWoulHUJ0wKzrGppTcbrL86PJ0hfLjvbkxs77VqRoN/vx9Sgv+FP6E94MF3/M0N1FTs1raK9iPuF7mtnFNVBEQnOv50gV5QLbqFJXFV8YqjZNAbM/kwhkWD8x+EzyCqc7/d8M6do7uiPpYITfVxePe8SSJn19XMu6Qx4QNa0LKg5Pd36+JXH94HnLxBMrcPsd232LhOrZ0aGepp1bodrVE72jWEEa5757Rhb+tMr6kXYP4KoHo4rQ09wL4Fu1+QyE3kT5BysJ9eWqXdkGvhI/x0l7lrirx7vMuDzgwroz7VThHyVuJbTvvkyydr5otP7Q14spOWO0uCPrmsR3ttix1ALliA27+VuCemMDyHRlE5vp+uIEEy9pbDprLpa1L60cgfynL3VfVitPhR6gMUmIO8xdFGlxDNY2qDLzWCk8AaNONhXXvKsI84wrUpaCDaP8kRlERZYlBcvpbqK1HltkRzZkKYhUTm1VvrUXqWa/wHG9LBQOYUKLE3MunQsmrMb4WH6nqy5caRBMflAtWOKy1fbjCSul4nZ97mdKUoRxvU17i63eG1S9Nx46Jz4MHTITGcTtU66FqEOe+F1af124nwWMfKAKbSKafxoB9+GM2CdJiMQrR+lJLY=
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