D389MVvYXd3X6NTNm1MWGwQUXHjd0a87rQNM3Fa8YmbJSR99QUGyOjHcRNKaAFmHpVKJtTfe88vfscyGL7a1AIq5hhVoWB3QuzZLMaTCEWdgCcqOjpCe8Jw9aKglx7qBRjz589DH3x10P1cxIz/L3W5GlPRsXa7HuqblQXGqWkngCLc1jF58QgAxk7a6t4E2LQxjFA5ekJUYnasMr/nHSWsx8DF1PUOLm/i5O5rp3i6oTbftnjbAgZykZbK+hlGFZeNsKzGgJi7GIvWhIFO620/YPXBjMPTFmhZU7xBC7ap4r38AT7f331/QmsbrHYjLkjdaLuSJAbP+gubPxre2Plwd7RkI2YdVr+0jtrGoowyclFyKMIMtzP/bf4TPzNwqGep7WKWNalPp99Em0JGvXllqEE/h2lzvpTki6vC4Bou0CzS8IsHIPW543dCEEPAVfYd6VV88jFug7MD09xfxinjhVpp1QzjaMT766hQFUdBtJUXyWBita3Teb2DTnvLqQfnrT6WG/yLFD91PWXZs2VEZnAiivRz8USJw+DAlwu2IBSQAQvOWR0PEt5p4jYit0SmIFfX+wLhqHGH5vPh2pK09Yudba+M4TSSnrhb1uf2Fguh+9z3QBYNmtSI8IMJwmmdddciJdQtHExZlo5OIdKeaxc6jgHeSxoe5wWKA1RMR99GEm/xRZS8dIh+vzptj60S5VN3X5EUu2I+I1HV0eEDGD4H2RIbHVrvuTkiCWBJayERQTV+P9tvuGCjp1eYsk/cK4Kz21I3ye+cQ79+UhVurikfkgahlYPYmJQ7pPdlWi1OXHuI/tHfHGWIqBjnugDg5gcOwCdphR1p1hPlyUf/EXiAN+8DFmsEgGI25j3NnYakat/XY4+NYPBXcJpwC0DOwvEnuMG78vz3+s3L4aoVhzR4pg2fSBRe294JGzsWLlzaOGRKm/s+VBJtetAi+i0tx0fdqSozxW6CDlWMhC4JTfCDGw+S8nSK4XWC6uPfwXI8VeBLjTO5r+IHrkoPHqWrzDPzMx6/JqxZSKjEdDV+dR3G8SSbYCKmeWJEr2V26CyIKJ+S3q24qtay9TYwt/g2iT4u1zfR1XBMA9KxnetM5Kelo0Z5sJn2VBatkyp/YXC8Fwv8MqFumtC5laZErgfLfR2B0jH2oJqL7Mf2sDae+oRfRJfaNsCgt0UIuJbczYOl/4Jbx0OML7H3EjT6s+xKf4UPNnSLJuUwZJHa8dJS/YntSFjtSbxgi0TjVsOI9uBO2EruqKeotnjddyk6dQghlizFPIywWVc1A2TI0CxY6N1S7c273+FV1zBDd1OktpAiREtcK/FtFn+x+iMMiUp+8lwCot3bNDtMPhze4VLkXwkvRjOB0k2nPH7Q=
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