ASmsJCnPVlqhNzTDRfy1hC5l8ogVJiE24jK/BrGFYESXWnGaEoWtEGn8+f4xTKcicEh/id+HslwuU2eAeSpXaJPl1DaGWgxTqiWz9CM0y4Grtm8hygTLwL1WkXXgtfdYVgcrEN1UbKeMeCpehPmz33utrXE5irc4iGtTGhHRoNCC/M+XRoRK4itNDE+eJFFFYq1F4uXIHgRVYKZ2KLpmQaaTfhpqV4HQGRFTS1xES7JjujLIVkmNkRs+ZH1nMbcxYI+14aCyFs6+UcwjzkusKqJwmqLY66DL7DUkkum1+RPG6LdM+r66vwrpX/Ri4PoI+IGBJXAFOL8D9xRt0ectp8Dohb21j+jmcD5ua9L4DrU49MAbs4NRTXeVJ6iWB1nrwjkkqY4J5NhvzxgOvtSiouKjXGLzntwpohzSw7wtg2n9ZC4AA/jpXBzp4cSfejcX1ou8Jklz//5xdYSLAIVbOi2T8GwqpZl96W6N42Q5TI6m6TbZPKRAqRvMC8vlC3nC9F6Ap+j2hnLWU6a2Ga47V6p1GDxlXsYf1fupAtuK94UHDmm7wnDh0DfXF62S4qdCjqAtJ0g+C0BFxktBhdCj5qFqji/kvh5quW6BwwzO9Tu1VHu6C00evS8F9P5Q2Yn08gCymXtsMkR6vL4GdicbbgUid3JnXroQ2BlhZH0Pn+UkUs8wPQcsQFJ2CQAFOKK0UlvSc0Od5VrHAWpIlTBt38wg+qaUIZnskIbTvPoReBBUESfvNB4F67Lc5bO6gcOtWE85BbYoy+S2F3aJRBDbZYewXxz0uhyM3kBsf/YG/vyloRJIEDAtPAm3HWlaeuv6dEllrxcsgQFcWHVf1ItnNGU4MOVwiViPyn9g3zEGFjQcpJOkWczKF7U+4IU29v//GBFSxJlP0lvaO59YZIMLUKqc5dJAMS3KLbC/gtRQox7Xqe7DuuNRkMMb4uCZKEJmvRwFeJmjLvA3JOLlhiix3zawxHb6nTrWm4qmLEb9nhqQQEhXd52A18ZWZFAi+eMvC2riequ2dkw2EORBMgjYLMlOLLhtA0hvBDvgzP4hMyTyAo23XXt94RDv9l9+wGlZiD8b4RnBTQKo1pPD66vOc3vtwhXQXyLXZBAlzFIcveLHpBSKn6sKKmrrJhYw3nrAjFZZo18O9QSwMbfsUoqub2pvTVv2WhXsoMOHvcYfmVklASN5Uxue56OwiNhLoNH+e8nxxAwF48tGELwjo5SvPbTWdLZorDGfKfBlQ2nlBR6HqeOQ2qnXcPRw5Va1z/iXkrRRRnr9buybck8tmBiLyI9/woW/3sImzS6gSzUIpRCsKCxdxyFKhC8oK8fMtytYNUSg279dPR5YKb0W/utQxOlWpOEBkryygoZsub4=
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