sPzOZdOJN16fVo936zA+8KJ4EdPo9CCXw85aPNjJ4hr5+kuaMovtIYYyCsfut3+EY32Ef0/F2KCz13k/9/weMBaBtusT9X5WrHTDViPda9hKJdv7IDXE2CjkaNypKasSBUw6kuaI5fDi+3jDp29/RKgCskZzoqvYgWmSJDIG4fZeWtcNdswIEZOpTKui64U1UdEqdEio1WTpxjxRkXNO8VHwjldUU4LHZiCr8G9q8gN6F4Ekttfr53AoxGIoyavHtLR1SdryO2iRjBwsLZxd2FINXKOXv30wKaBjXuOeyF/1mqius5IYRe0bT9NBQIZb8/zfriF4no3h88RLjsdnaBko9lngrKM2JdEr7b3OYVvmIOe32bi8GbKKQda9feDDNFqcluYBnEKc10B3RRYaiF+5B/zk0zEt/VZfqKQpREimiH+VkXjkvglrh3irYx1HgWm0lJfD99na1Q7XePuTqy3gudXt7x/m1e1Xj6huNolOldeAAxy8xGLwS4p9DmKxgL3pMpLNHQmtaMhe/fVOihuBtb6N6zwKL/e6+Z3ZbpRwQ6NdxweFaxJ6WQkcXP9mE3yU9+M9ftpW2BW+qcWHKfTcwt/1pMFbuPCOKAwL4icke9Uk3zcr6DJC3qL2Ve2Vv0gt9WvRNtOE9LJvQbTL/r9KTtpffEsD6PnTXKii3hLYPAX7wKK6T9mWwGJHlKN6hJpNQ8uiOm3YteS0rRUiqvNTb6IZ9CFh39t+t7MZvn8uAP342A3wFFQO7dDDuvTcbuFyhupm6lbJhlrFS2c7f8LoVcMUw3bOGsNXfEgopQuOUS9RkDzm4siCOhz9DkIdaALRs9ObPKywK+EnJg43l5scDaw6iKrUc5aiA/EbrmUDKxW/ORBZWZFCndJQ/MysboJq8LzmlSL93cSWy3WKqAHw0iUP7xZp67ZUsl9qAUwU1QQiAAib+SNXWTwDDk0JUahaSaK+sjRKBnbOU5KZHSZLFOs1KDrgVID7WHv2Ujk5hniskVAoQuAAUeJh3DdiSCk2E5Ywme/fgYK0PMezJWKZ7F7orz2Jg+iQvQNTn4PjvBaJ9u1EO4xvVl8+rtZPebZ1J6CFtgau39bSFl3ibUT/0Zb92aDr/F7uu4a5pEWSTVBljQkLiHKFSmi2qxF3LkC7nZ6OdpV7+mGvpqKGjpfiuj5tzX0OLzJ8xaHJNWNcMrA/z04Rapp9+eJmGG3OhMq9BsiHpgnFicUtl2ooS1DM69l6L+ErYrVVc+DY1BlMGL2hoh5fUzrulZONGVwS7UQtd0G0n6DbPt1v8+yujyaFxUX9ZrGY0S2YWzqbnE+YFHSwcftILYepVT/qABiYKBAEep1ZgVAwVhAEP3CRgxYjxp/Gw3wxhDvUEqY=
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