Eo8TiQubpV18FxYsU9jIKYaDlC1H+BtsVKPofd/CnrAj9fi7EyZ8fqmIS0BAdpTMweFLZ8CQg9OiHHUuAqDqe5S0X5nkisO3nI76zmPzMhDKztYUXXY7za8arOuAjlP49yZCa65epOdqTA4VsP3V/Vc0sPxmNCKeiIol3Qh7SB+4z/t3+pNx//MfPO0KgUh4nFQUen8llS2UAws2qLcyzxtBKdRAqrD3gwUjEwMnABoa0t24mV2Zu0Neh1E5xXC4tbaUfAC2A51PS5cOopgPGKDioM9GmidE6+xkzth82W1Oyptu7onOfR1B7yZqh7QR7xnQIGEaegT/IvaAcPmBhW88l0/8wFKVf+D2i1+o/uDkaehRhpJMWZLWGZJxUuDSCb9m0i6id6Hthjg0U/DgHsnff5PZMqPHF1oUCoCnwAz2TM9Bfnw5YjO07OfrNnllMLhzty77sYbxnr44GKjy2gs6vQQOgowTw3juXR7U0X4nvkddlIeV9kUbxo0YQaQPQ+i5a8em8a8x/L/3OtoKdbv6/6yCkmy3ea6utfwTkw9joUBkJuMI+RV1p8BfusIBi8BG69op+oUMcTJGhgLHB9PoqR7gAr/P1kjiEglfdjnvV8hlUFOghDnhHApK5ohNgPWgRQkVLO4wtVtSrfDvcBIvcHiVhakg0LL/8903JYVhZ3UkAwtzFFgk7Ks3GUJibvXMBsczlhDEGv0ax3i0lbsplf/4S+BIdYhkPm1XHQr0BkB+SJrdBOfMMawTFuF6TazJQ0UtW9GDY6OkeLVDcT2LqYQO2xgfIR/dKnd2ARneKjfimIY/6kE8F5jj91MaGUFowEW04vqW9hdUK5npxgcMJKgMXIcxRWZmfLzIDBgqevG407KRqh3qww6aZ32sO869LOrCCG2GQWE2cn2btT2WWCJTW+ZkQLFXFQsLrhqJhq5TyDsRQMCpqvkFkXecDv6LIqVhuxI6uU/rXWo6nuK+XLTJGbbLLL5+1NCQE4iq34yjwiF/g35vbZnvDGXJD3azexKbIi7bnqtnzLOOplvASBKSiqDhpAQrpP6dKVyOwoqjiU5DLUepGFCfyKfik5woDuYJwFiyvDXqerRCqlbXrmTP0Hyoghyh23nRGTN2eAvYPxcYvBpae8COSU1V8O73H4eKzUy9w0fzXCead1GkWmvRX2hM+f7K+T3Bt62eNcYK4j5BOQKHN7kQht9yM/6FJWUdE4n8TtypH3mooutFcUuzTqPnMa7NHqXuEFrmsK2wDxheZyyih/tyW4Hw0Wgw349sPBbAmcl5uDRerOgiK1EKxJbYR049KoT2jHUetLEHdJPlyaPMOM8hxQQsXwtQ1Zcbq9y2FW2UBTQUxYqwNfnTy8L3zbD/1WQ=
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