U6jCrI5nsQ0k706naVB7cIjYM7sfc4zKJY1pElVwu6y4JOZzjW5bMzeNRI3NCgnwrh+56UsRrSmBZMgPjRL4poR4oH2bOwvmtzfQZi6NBtIV6ddeZdmn7XjteV4r9ok4pZ9xGBCF+K6tytWXR/fbgT+elh88IZ1oxkarGbyNf6aP4nTVNgkWj3fvr8tlo10w7GBcNYyitraPjpHW5Fpo4Fjj88ctuT/JS6UybfsU+0a1USr6t8kRLGaiR2mXHI1CjNMGau8O6au9klKxdqo50jg1WxJBRkr4kXbX2JtXH3lzq0PvpkzpIsD6Dc8OVgbuJdEWl4GIUUNRjoYXIfF4UN/OuRUMa3gpisUFzY7bHnB+MxlasB7FUyCr0Ip2YilFeYTjitK9Jgo9Q85ZVCID9wy1GvRsGt8mKtHXimma7qxXk4bbVFrhSpoLWM9LxU9QsGlCrLpbEfc0vzYdtIT8TBOEqdVoNeJJToAin4Ro9QX5wX4Qauuz14clLeqiX8dSnTfLdY2AVoVyJaC5ZtP4fycKnN5Rrj0axttgT0bwplHqcnleDMQ8M7lviBabkl7CezkrTw5Ze+ANgfVq4rIHTjCA2uI78+o3trm1k4fcbY+55nR3r1/yUHLA2CuGdGbVqQM0I5LTEfq6L3QvIjUIp6cM18xxgYFjdw+6Q3SNGaehFcwK2GaK24N/4NTHTx4E/+POWRVsshE2f4N5SDrrX4vNWZxZRbUEHwLhNiAu88aMcNRxc/idypFZpR1ojp4Y22wmOgeuZXt7zcf2taYssGu6460+k5o5w0xOwMSTXwmMZpTmDKA0dc3iKJ9+25SPWev3SZsfhC9hHLNBbhDNk2CYkp0AO24ozH4kkYYWm/4M+9R4O4HYsYSwVfwcs6iuZPIJ90mpQc45UqUgsawyBdYogG+E/jpjAaLl6N99u7bRJU2Hu36KStVBaypPOZlxcUPTryTUK1cBRY7k+B7t8Swj1M6VbxRUpQJKFUtszcEJOL5Dr1PAkq+3/H4VsPn0DJvBz9Fj7d0r8Dc6dqNAIyNf9MsTMB2q/w01ibIj8zFrHJd2KEUS0UAlgdVxcRXXQVgk2anVAhPgEad5N3HZAmPh3NkBVvvt1f7YrkGg8ojneQKpn1UApFh7JeTNzLaH7KQ783k+ZtjNEQyv8r5XsVzAx2WHwRu6/uh3Z0j9ca8tfjGiFWpaaSx/qvV47X+9pgIy2GZMfjwI5efs2v3tsVHpqmeEzZysXB0BPYR4f3kgfRF46XyctikDm5imjqhvWYh9FGLnsNAbOTezJLqR5vGBHFXIK3tw2wEey+ASxhqyJkyPFvqq7pSEO1WprrTaAOcu9yoHSPxTlWJvvlNfH2MDFlmbE7yFiFIBAys=
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