fzFSq7+shZMsmdbXhCoRMuIWQDNxkFynRxW2d9/AOm617uE+2IKQ6sv37Ms6Pr36TzIrnDD2+2JEr5Y1cjgss8474z+QeJ3GcmdLWLdON9ke2vOBXZQoPGD5wfV9o5Mq/sxC3V46bpQ+d1Lc7xMBXt6S8f6lzFf80DAmxnfMJT6spwCWRAok1qVsygJJhRVPIgD/I3ITEArOTHXVpA6jwnZfQ5gpKsQWw4Mx6g7iXqcC+80sU0XO9DxP2T2uPaVxxFeebrHqc37IGxEqt+antYW+cPeXW/+qM75ShO1rJoLmONKRQumWvKRb5u0dRgVxugLG4D6PXEV0KkRNbbN7xEkQhbUumVg//DIlnsyGAU2aWDx6bLe8vKXYoTtDLBsMeGv4Dk04ewYK3QZZvwwTm0q6K1XNOXTtj8dfAw/LcT8zud6JUisy22pOJ68jr27m6/cErEKGUyYjGxDfoGejGsBc/atpPAQ4jHciTHJieSPctMnDDmf1uAvYVQg/dIfTMh1CvCgYAfGj773P4PKFpS5SVoHAXI58SID3im807DwgY2qiZrQU1aQaphSWIujvmdhyJxBzXBXz2qHe86pqT0xOcsD0u+LeqNki5kkhnjvA6ClurpawgRRBplrY3P6wxaeW6dWkUOlAu/jZ3yKs9qKb9V4b7U5bVcY+dRzFzeo5K4yo4I7jKJFovlrf5t5nd+RGCVocuAFHiogmwViRd3JM9PZ9l77CxZeqMxdYHdLsTy3yLmUCPRmv9n99E2CEXOPN2ye8EtMCdDj43DYHyQpr8Gjr/k2nJMTEkCXAd9wtKGLdf9BpAVsXsStPDVZ+8ZAoNFkTr3UyQ6/PSpygLodymKdK8ea3tqED/kk56BFj+qTmG75364EeeOBdm4zQz7y5VnxQDXtNq44Op6Zo0Rt3+DTyN2IJhJ4DDjmiBMJzmsPtjA+zGbi6c/8+b6DSrxejZ+0iJccIeA9Aeva8YfxbfcCqukQTUZ3Y0WLRGhwDb4UWvhnVpfv2hqqPHANnZQARjuaJMzZ9If4gKUE5lzSK2SkbT1TjYihGHTcLgn/WX1mQDQOqkIfM2oa0VxRMwO49WK+V+8At+npjohDNj9mnh/VJJYzrGrDywvBu7WoTD0kNirELuAKRq1Gf3LCHmkReiXU7poo6OtKQFTjg5V3ERJYks5jQhGgocEGcL0F5E3xj3616KUw1JOEs35Bk4uJAc8DbdYnZeQb76KYEqeg+3Xg3yxZNmFN+Q4pfRrmJEEGxPBklcdoVVn34uzkJp/2OxQNyOeE694b/KQ4CE+nkX16s8vWT/1rOrU5FEDX0h/RkWJzlcsr9sE6w+35B8aHwvO2NqqgrB2tg2dRMMraIgDq1IOmpAG6JtTo=
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