vmWqfM3A8M8lNP6bW93jGLZHotk+GCMJH1JyVwsgpOqXi24H54jxKTpD53A5q3HcQhYYKeivbL1xqRtkqd9LE0ugxbElQTlbsW20+NXFGgly7Ccu+eE0HbkaPneJDQubQ5sP3uTDktnJluxdGuH9HvlsxMcVaF18kT3Izd17dflo0gwe3JwTWuFM3judR1MHZhS7+FhJHOCt4Ttrh/qqiZVewakTc7NcpCK4LprOUr0MVURksbXDT6KuVVXyUk/U5TOfwh9a0yRVxQUG1xMpLEkZ7i7dy0lteObyHs5fJN6yiOp0139HsISCmAdHOUCxyyxqe8xoQ30D227HYVyt/sNLgmYtzFwntiDPzanvaxn0kimVi1bMC5cSBmTh8XOHqmC0MDe6fDkI0IAoyEqtRQIgiglbVbDYKodeOHrnaWglfB0wKtQ7MP/HB13gwCGYOk6For28kroSNx02UpV5L4G2R2GmpSlGqqvqPNDN35rnhTAv/cKb/SpkUGXcwmc+FV3b1R3NQsTAu1Jus+N5/yf/h/blrSGTOYLMLAXFhaisivRqVqKtVAf57SIucnFANGImpWGNy8gbzWv9v215LKvAFi5sNb/zijb8q0JpnIO88e9dDHFKzIQwh3Zg0aCtdfjAUcNj6egoQtX31kZGlvL42NGcjhjKDuWCISeKTwkQg+fceL91ZQzFHGMwDjYUY7Hw0yi7f7kF5RP3TzVsvfIouwslWaxY3ij9av9TgkZSiLSEwpgaoU/WUC6vmyoaUUR/QWlsFt9RjTE/Buc24pJT+yEXa/TPVH90gkQeg5fUC6bwwDhvxJSHaFCfB3t6UQtuBnV6WDlPKzbGHBzVqXM6rt93ErsgLqKUnpHQTcisVR9oVPAMPIJoFkPwEsIqhMTgr8F9WATOMO5kyRJ1ZmY/Mw2+jjNh2yIBPhU9zeSnlErdQ/C0Oq/D6k01aoa+Ip2tITUw19y6vEeaGZhoIMyEIyLIc4w+/k3w+HiLT0KqHvwvD7due02XNyW80cw/l+WR93EwTZkdgg21rFHYea7AlWynFniWl5/k6MBXHusTUNcHmV46O3iU5ZcBAlTCpbcTY+d1jUOexZ9Gm4/8xuEwRbDbznWgUiGJVqHbGYwBmx/AOe0/Q1cfoBXSfCv0CLxts7zdLTJ5a7B8DkPRpkCRTocYeyHPSCrpSUjWveDAkXMy8fQdZYgDdgdCsEaqwDmtEcQ7jiNOlbqjxPqelfcCikj+3LLx+f5Wr5L6MpdKZh/9+9gK8Z2SVWMj6RkC9NbBDNNRcIJoH2DOwHgCLRD3elNu/8vVQajBdKqoZzIHjZciPQkKe4cd0AZSxb+SzgXaUuPhZl3Vk27shchkbuqQhLx/h3nUmb09r20=
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