2bkiMffr4xnh6DI6Vs5ZQnydk+eJOvwuk6Us7OBITnKbbP0QXfxkifAorRqCx+OLcfX3pgBquk/AFv3Tj5pUCAscOpYbON/syS3BOojXeQM0TjEKIT1FdhwvyzHKXKrV8GuSWfHj8+YyoiuEDKhAWbVb6XP3x3EBDA4TrLZYAW9VzGevcPcPFqLot3Ay0TUNY3nQJldB+DStgzvjD6tFi8oG8vS/rTvRvWBuZQZITIdgXRmWDaZEyMgHB3RAWs/AWuP6/Hklm8ahhqi+wHIdcdPji9M3K/LILuN8Amax6mzMlaMgKi1npE6ozEW9mCGepzmRibfAyYMl/p4sq1I74g4Ss2hIuSt81kH/61BsfuKz8xH/GNoFOC4+NmYj2nXUkztZ/+M7e3QGCInDWGhFtitQKMV6Fner59FEyi0qLRn3qCHP9knatHiS7XSOrczUbU4/Mf7TN1Y8t0KSKsTTXWKKMgPW6Oq8CHMik2Y9AkhvnqFlehyO8/sa6xKytaG3EL4fde+CZCS8tRzXfFMEG32rAVioCE54GeOrAQtMyFZqpWIGoUQbRi60SQOmPwo2cvb569eBA82BpmSfhe4pGcZF109auxhtAX9ef0zqtrrGxCH2HaLqd72W5jFv4IEZMw5NzGKiTDSjXw5+zwMtUK04+Zi/BGOysiAlmRmTqd2sBp70pLMgi3bD8hRE7hqZHSASceAADLVTPfGnqLaLPDn17D/xZUkSumdeDnQFnppOST/TzbDw0Q0yNChY4Fr3MYvI7W2I+A9KcNTfQJ+jRR/C2cu4Se7DKgdlhZwI3wCBuqIieRFa+TI2a9AbN6IcDi7kpROc3iLMv7M1G3SHh3Z3dOdS6RXzLmo/4qUt2VEekQ1opnkWuqZQJWt83EByU7Cj90lKSQ3m5iDpyIXPt7UU7KInRK9VAv6QHhfw1wBmPq2yIxMbOjVQJS+vpJUaZ/D/k1BF3BHQqFbNzKt8n75L8Ye7qsSBWSwRw2jccItQNwpapeEV+tkKi5SvepcVbAfodCJUQM0kd674Ind/p+F3yjRgPISFIdjhpyEzJMtICueXAwQidpA+P3EVRmtbLwOwQxn4XiGR/SR7UMWC6Q5YG85ziVo03sKpSJsdocRHby/WEMEPSzno9+LxYaRvHeIugPwSPH66eBNxZmBNbe8kQt3y+9+BTLDhCpYVvRDvwZvMAIEVh+zYnYkGv8YmmM5l270WSBbbI+Cv95oA7d9uxsTRFc2wasL/ewt3k4tnzFhLEPRksxLXX7plJE8+apBF7kOcgNJFMZiErhnKmeUwjOMNpwKWHkXbeGQJOFla4VL97wICFEx+TliNZqYrMvzQkXO/SDq0TtX2Wa9la0o/FT5sLPr1yWn6Iaw=
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