XEAfUcfHe/I34xvLCUdSC037zMuDfbsLUW26zoY2CFd1M+d+kheQA/YlwiwpeabUzfhmK6NjQQBtWpYPa0TswQqArrKVxig0AADFfBGn3Fsn7Y+aP+zM70UpqjVjjGStMj+9/Gd/EAGwWuwe/V2fHZwxkI5Oa6bHdoJYA89r5OgyMLh5BI3wpESW/YnZXIb/Nu4WJp230aG0RKLgINVVT7n/K6Iqp2C8WqeqRLEfRTsErSMKiwinu2kfmHyX41pTXSmTbTitCwanc8Z6oYmQVwB4iPrvYm8e+XN+p97OMHRxD7zbnr4UKYQ8BXAg8w/KRBmH5BbkIodkAtCY0KmeXsDP+iGWcCQYlfOkk03ZIN1rq+KF/vk2dREGUw6IXRyxszOZ4bYigOJr0KPfAtqBMY4HAzCvP0MEwMGFHd+Xxx4FtS5Iuz2AJmQ4yWDvWu/oB5hGSMpCwMGmO22WdIrd+miQbfa1i2ruQELLDe/37Dfvy2aKqbBmnkcbXGokBIofjUl304Qd12ahJsXMLpj3u280nObOQWzkCDmB4S3Ye6ZrpjlNcwOHI6LncLf5HpyFNe66RjBVh3VOvyyqyzuZ8cdxHCdhOs1S5c9unZh1V/asbBjTlli+KFcZZo55fj+B6qD0X39csv9mgPAcp133ZkjhMS1WCEEbN3ORwNfF8kou2KEm1sd7Pl2hBTIn26zavTBrAA11xuU55qBRYWiNL9fkRh7hFPA1dypq8gPwwfu+UWt0tskUpeUdLxbhy5BoWgT1ybvKI0qYC1CzcXKNaXIwoZQUrtIIwE0CpQ0cxG9MDvNgGkxBFafj1lh3pR+6KeDstd/ZUluguVhq0UcQ6CV6MrZgXAZQ4lHxn6eXmNsfNR/V5ilqKM8DF5BLBPN7ay/MND+pELkDh6+52HKyldkp5B89fSUt0MeSCHD/Qkz+ihuLgcJrHFqVbAcT4zAqf8tE0SuhcJ1c1lCzegyZD4OQR4LQ7tdRGC5rsy2sAagIDlSfMSvIzw0tTDRjwxq6E+6o6147B1DI/3GLfngNzdtkd+pmDsTXF/9q5gRtndmVJTE/FrGUuAQnsNLeGDmw4WYnbyarjhec+zBynR0tBHgG34gdNWNUDfKqHYhXFo5sz02SdTTdCoMGZ6J9//4uPgqk85lX7NtwFNRWQWOmyYlIere4YvXzP3Z6traPemNOctHMHTGzFOwBX/ZWX/UXhWhl9KqyV64SMNLDyWxiEyIMOIyJvf6SIRzoBhyHvW3+nrzwtoqKTML1r0Xz8My1vYtmcolirjT5v60r9AeN4j3wJ2jGute3Rg3IXd00uiN+KMNZTIuH2Uy3hGXGnMRoLslCNlA9UaAExxNvReFhGI5w4001p+ETir3A19s=
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