qpHgDiQXEdZmv3S7m6db+eDRehb/+wtD7oi/+INIM+51gb05+y3yFDgQmJ6ZawG8CQHBKcvNUxUPQpyn1Rna288Oq5n/7g+UozIn2ernVBPuFNZtSRIZED1LNiliKO2JLIVbqzSFTbhZ5IoRWoPPZKWUe3Ez+bvXHGqUjgBh3nyVEe5X8zNemMCOuDcHaPw14c9l9xzje8h/QZeff5qQww4gpRk3dZKHKhvrW/4NYKVUWqxm6dfBVMh8lHyff/uXKNhcbuRzkBLxKc51o1Sk9BMQjEal++fyUjCtsmomL1eOaKd33cs3TAL0NIJY1jipWD1fbKScNs6Wa2PgsicvaxV7W6Fvhr2A/N+X04bKTd3EpNfhmnqbBllJJab1hq7mrT54ght8HgEDJ6phctXgIyRKOoqIaUMclu3iJEj/4SsB77OcwD7X4tuImcYvDVdbeqMHXd1QlWgF0i/rGZh0hdSOgt9aNOaztu0Sq+7XfUskxnULdmJtAhLMwA2X3oPTXXFTz6KvhAy2A7um1grpXM+3Jcb/+nrbtA49dxukzmLgwJQgHeTXBvOPw4wcNqru2LWJR/6zPBvmuZXC52eik0iliBKsA9yJ0KcPlQNw1mPod9jBKCY5q2W2gqqPW5WB1o8S0nSr77BDzCH32rcDcMau68InvCLGjq9pOY/8zI5wu/XL+nAm5fV9mRMd3fo4tC4Lc/dduNxAS378Kr8XTGY6YRRkL+JgGy1UCkS0+qPe/H/Od2efZ8mPvGYGCWkHG1mER4/qwfVzzG7PRfhX2T5r2+b17Ooz+kzXaiFpFJKSNSamLIMlu8g6p0GG/7M6YYxLfoKsYom2pNYb9VhD1J2UQFJgzjGBzm4VBc7VDppTtjgzxAPlqgKPDZK5W50LgF/mqA6va7pae2DXbLKqoCq6EvJhZJZHI2UYSqoFXmhFKfbMUoLtpMZXN6W7hCwZFV+BaBrdxH23hESLsyeHx27WdMvXdBdoNIW2a8XSgv1Jiuv3PtHqFv1rbE2pFHeLYTUNb3serrpljVfHomYo9u2m4KOGVRejxYeH0dTSA//PyXZkUBhYzjp+dEZdUlOSGQPmw5LBMeanuutdbzMwCS17r1+VXx0EOMY/wCDLoMPVnv/MZCMEVuPUT/E+LI6+ooO5x3X9hc8T5Gl6L+72Ahqred3+ddZBvviCm3xjeYVSkAm7ZiUp2mtyg5XUQ6MBNINY+ZuquMjRf5RU44ydWuiXlNEv1BixYsoXSFBn3xmYgvzDWfk2XranOBjbVquJrHA+fkIPcm1R1bqzoOCydQNowIHzGWkTHPnPsXuSwHhjzqc02WT6jRF62iqxCySMNbQkujZmrP2wH1G6JUZr4lqJPgaTUDuD5HW0NJE=
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