GKkTBmO636JtBOlC+2grC9lyGxjVyQ7QeFvYJpuIDXx2GqskpSa898/oxMvENQna3ZsLe+6xqlBJ+cZAN1r7s4FMaV2Pu0VWxUOGwXVTT8dz5gV7lMbfm2Yd+22eez8NIH3rlcYCabUeCZD/ktxgHpJ0cuLKMNxBKOceO2bQN3YwI+O4AYa+pQYRHk+lZt75VXEJS3WvG7TK0ABJFlWRu4TYdqP73qURDCMr2LS0cdagKm04b0Uz8raVoZcnYdmNr1FEx/WyNZ9wh1piBkdFurS+tAs1gv4/FnPe6wpABZMf+CBD08pU9hv/ioDk3BD0chP/NPhSrEUjn/ibBIfB6HDv4rvC9i9ty1ahIGFs5MJz+plVavU6hllcF+qmUTLVmxhAjvfBUWzaAkNdYnJFaJb02Iw70kRZRuaVn89Md1tomkRzNfr6BMaNcNoKLL4EQZNYMEFXXs6gFM95IMZQIj3wvA7VUDu3SZy7eXCUMKTC8/IEtTUrQwG30XsCXttO39bTQFvyHvVTcangxE03eG4Jhaio7P6N6W05MBktt33HAU6DzZ/052kCaa+MTM13e9PsMSKhr81nWztzsrzBjBnAZ8DLMRHi07d71qAghkw+VrV9gyk97YfDvRotxYV2FPPawjKp8YBYcFNrm2krqKYOJaq0YdAlsYTKu9pXIJJ8ZwKmPmYj2Hi/+CLvuZ9U4xzX+OxxcH8vMZfcm8wl+e/c5p5BCYgseb/TYBvmo6by3xwJMy6Qas7o8jrULTo3GHVGMJc8cUI4VIGKX4exn26HzR0hFFLokSL9ew2sUAbyowu874u95f//SRjrHu3LHOkdqzgGgLZ2vIMlBENpTj5BLVgDUihPgtUNz4bbxzqjnzjfEbMkMYY7kLhofeXTp+GAIEyzWkU+4EnfMY0Vi2jo4A/pZ1K4Hzl9yQXoREk3bEO/G/UHw0ICw98+TyWm4PKUh4Nr3wqeP8X7EJ6A5oS3eVgaTrvrvzqaJI+vGvVjl8TgpiB/mXQ4sc+xODPIUh33L7ADmPhFNj8qrEovE8N5N4v+YJ17GWwOv7USsTYkZaAN8Ejm4UqHmca0Wkqj83QtC/iKUFzLISEqJ7v3raUhrNKn70l34OroDe1lv/gkPgMDvzOWncnX1VoU1Qmfc20sih0JWz+rl3fmETne8OQzCKE8cNTiSyuMGU6Mq/gEtnKOL/Wevo+34G3lf5rt+0QlnBU+r4+KJTnZwNT5Pwzu6eUBjJvwjM1hf/uN/YoK7CZrDtigGQ5vSa1qx3QrA1AR9mEzIWoTblOvaz9us/iIj+0Qrmsp6HBG2Fh4/wWEpn55CkTiHJ2Xl0/h+a5BFRF4W4wDfmx3zIu3Q1XI7zyfuAclJ2Lw+K9jTYo=
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