K1eQK550BZblMQxbE9g4+bgHds9pZVY5qPcDzVxLLyDn7e1Fn2Bj0+T76OLcFqEep50VfHDusni2dliXhEszwnPzPIAGR9BlH18oAkqfTe2EU7zE28j1rxwX/REKWpnYfnc2y0140hIFzbDW6bvfF0HMiSXMbaeaBl8FUs+82Pzt0pEMHcj7WMVtO0YB1M/6KTrGymgrXitntPTmjF6snhARETyRMkEH9o9071XN3cXUcg2cd8Jf2oqJKOvLGq1Hv/cK4Thubf6Ho9xB3h7xwgGPSNaTWhqjU0/HH+DrS2CS7sIAkBoeA5LAp4Xo4LVyyQ8llBkYt8QMvZ6CUcgrEQ/HijjxepasOc98iKQ6sERaVabCxHOfQbiMliLF1gYKIWvtdwkkB0stMG+eL+1bkpKvpq7OUtYiMttasHSHqBkQlph6bTFKnmu0dgBfF6Rw0gRcjStsWCcipuDkpXqUzI+JwG6/FX+pRmitCbKSx5J7elkzInuSuIXQqLKmldFXICAjjxR+LOM0XWbWo2uLqA4F4BcXJcQJBWnkfCLNwiD8Er60Ib8Y/NEE+W8/vjZ48pFefe+Hibg3blE5MtNT2c4GszZmBcoK0OEM1snzh9+gVf2cvyZW5yzNTyZS37uk4MhkbjTjX0TSnNZZtATlcFBqcfrmVGP8FQvYh1iVhRgatZ72SoWOBnLKszuDo3CTdKgNltkcSaKzooLnjQCt7jVOf4MaDw3EFO91j1AIK2oNbWW/91ensJaOLb22ftE+MQovUE2IzyvnTYoj9yFwKsoeFsynUnvQSu1BNi38+6fAHhx+kv9ivxig9aoVOQAtj/1y4uDkDm9oSN4Jo9z9Xn7lZwKUyVwSNOqZHoJtLm3d11+zmqR7X38EnWrgNY1RHM0t7TSivfB0J2txs+wu3hOztOw5qinZo3k3gYD1JHkx3GpCW+h6tuIt9rZYulj9frzIwnJh1QtRqVlQJczr31HKVUlEu6XUjTyN9MIyw735/lmhe6EBYeQKnLVBD4YmyFYNtECDD/Rm7Jpao+TPASP/BnBb3rsguy6hPx0ZrMrrD1o/H39yOn+79YhHd2ZW2XNM0YufgytQgeklautY7WXM0qaxn/6ZTgi5LdLnLWFCD5P50x7VahbQMZbyzjoA2f4kgAzvG0QrbSs//dbi14Rg9i2b+wSVp2RDWLAqcBW6G0SCyGpisP+OHSxbCGFlABMAgrWRVoQyj0poPszejzwbkd+ycOxup/JrCij2GYHf4Tn1gQ0/Y+M0HiJdJdjkdmHhVZGX4QvtjX/E+4dB8T9Z2/xVo9dobacCvHea7cldM8UQZPwqi5DXngjjH5uPgcmMSH+/KQHv3NGkJ62ZSx2Gm1ZLvU59vXansko=
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