HL7I0M3f3g02+gzCccG8MXnZtWnbW7mSlsKvpKUvCCS6fyfxHd0Syy4+xNCc2tOI+udsHrXFPshC1qe1Z8n34cIblmvaLKAWGocWcPkNxz1GfYcgYsth4Oc64cAjOR7cYdLvQH66Pdf1ZZ8KtOdbeDdcAwLo5LrSK8iIIbhq3uT3DWyeWX/cbW7mWhVDSE1IltdFl6SiuvXMcityzqwy79LbMs65+d3Aowdw0XYohiCgiGSw+P1eudHxzY1Yx+Ye0zy4SPuDXhMQ8yhw1i5M0GJ+xTQ7YuSKm/BsQiZYUF2trFMevH5s/pGZsrgWuYLmL2AFd0ZXorsk7MUpMEOg19VMh6l1sxRMUnxJR/LecSJQCws/5tVC9RBk0QDoo+zpVPXcQ9OElBAkBGIOhS5dKjBlcXvhXkjFDVBYXHwkpzCt2HnUxg4In/ImK1ZkMuiQss27/PDg5+BJlHYJ2Z8EePSKZFGza49Drk69RXZALHDlv4Ogmu3KtvNfCKUq8i0cUSKwabe5KCP9yjjamdSRdiBsw1vtYbg2YWbhCjfMiGXzCTCimt5dvUFiHvmWtojEgx91x/Wlz2G7ioHMdMA8Pu4bEppERwXzBEcJRD23tjF8gtZaOMrg0luTE/zSEylPvjMVOMJs4DHzBmmw8lqBeTYltamUSkpbv058bWpNa9/Vwsql39luZIs2gwCDgYfEn74nbQhz45noxxmcHtrQNE4jOhdlWjCEbYppvitSmupPhNKYEgiU8FqiW4g9FwiI7bWaHRMlar3ldSxVyQHu+5t6ZnsO7900A1+AlKbwIfLa3uya7HF95KxVUr12fEzcizup44p7hHkmutir38I9Ese2ymFgLfMaC3J3PZjqHMIpjM5g4cBZ9Kxi6tE+Sef+1MgnhR7thWAQK/NuAyIvzW6vv6E0OLS4MC7wHyRrxOuiEGKWK4yIIUmcvKeBhDpKwmretHmDoKgWPwt/WKWWp56bKsKaijR+ttQqOxguggyFYZpZhjktimav2wPJeGQ4Z9j3Wsdj5di2uVei62k7wluCeDWVCK92jPi6OGoYX6uG9AtInQ6mJd4+I0RPLRqs6dqm8RiKy4QHpjlBEz9ro6dHCeh0CtnKXi0lnsqTbOlZP7U5rGMYutHpboErd5/FU1J1HlFuxKn+FrKKCw11NaomdGn1EWzDfohJeaXb0EXmNBptvhcCyUQG4QDoMURAGSH6oriAu87EyRzk10ZP6zd1WTtn0c1XkxHVxQry/VX6mmoHS+zE2n2Mn+hIgWVTIlvEpiohy1Ya+bUQ9TIbaNCs5WxV5IvHeJ/pt/sw5sfaSByYpsxKA1CYkV8w+p1ZXORAwKY3KQxjaeC1eICOFEcPgkDBy0nmutiYYcA=
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