JzHu4CqUMPqlmTZBe+BLdhxVgbTB3H8syzAQJl2or9vRjzM9jnR2+r6nqNboHc8yv7JbOIjRX07wfiZljryWiX9QxiY8v16WfzyQZqVXBnQQ0/WaXk7+OnpoIWI+7bfSFza5zjTwTCg+gvzaEeGIj7THRqw9PzhzzXatLBJfjkELTX6Tzc87upHui6uZ1I+Kq6r/biSk3o8IVVAtAiOR+k9klF6RMivcceaTXNDgte6Ju1Jhgphj388Bm7eUH00wwHoTiVA4vVP2Ci4caUZGRPgkalip6MPl4cZM9sleiQhG5zpIjbtMzCwLD7yhc/OEr8R70PoBukFwZMwTT+EunIiRLOPf5GTA8faOu4urhbm6sU3Mn5QYMRihBKmuK1O9zAOZY/uT0vRRvtiR6QZVNwPRWzDVvSsXiSbAHDMDbyYCIkZNGXrpChwkBvfW2DqMVmfTbMLWwcMgk+2TJ+uZA1p9JaMkTBjcXXq3fk07qsD8vyy77/OInoZxgtzMkhF8ns7mTcM93yg1/z9z/f3YQN0GwKBvw9tiwC9uLjxeq3nQP5LJ/ciNjMofqnmRsryubFihNlNmrulZOmL/LOvKONvewd2s93+IlSSXsn9496YO4wPltpBhUE4BpEz/NWtgWqvcCm6Kk/vbrA041UG7/n7ZUNtem1bxlxi16yRVsvZqzsgheyCtYiHEwXBQS87s10KOoG21LjB3B19nPL/uvISRiEIcCW/O7im82Dwd6HWknsQ98A5DqNldc5nhl62yUiEbUTHtGlO+lUPoqqphWXhg6KFq9HzmqZyEAAxdQq0ix5PPU2qxUqeT3w7pqHyb6YmxyImRTyzHIplo1DckvBifBdtH6JpSiK2mxON8c0ym/2IbW+yV0P2a80g3XxlVwPIDeAFjYzF5+gsNnfzn6vh9i/bfupdRGaHH4ljZFitmTZMXoOa4x5d9GZMXDAeHmSM4BL6cW40SNHJVw6UcKl7A6WTXxvEZPCSlN0eyphaNlYeuxe91ibPFz+SXh5Ev/asRgewbalmDwh8wkYRwRUoDWbcVTXFbMO6G2mhjLHKlI4vJ2s3E7N4J9eVmbQzUvh/M+yx4ylWclp5qikuPH7ZQHs5s4cLmFJ12pstBUyWBlO6awAx3fPm/eMoprAy5jVA1HJOnxGcgiRqxiD1KaPIYA7jxRPZz7r/mxLqy2XfQeLhkKR4NMKTLD3+1wg2JkVweb14J5pW6xSU8FyjPVz5ucCi9cpRRrN0hkIF6sTIcApJSWZmulLwRt7LC4fs2yr++7Z9gE4JYz6VLD9m9AKIZewnOqGkX2HolinKBuKmjiLuxX9ue22UZGVeBESsUDqXJqpCPs2HltfdRm972lfOPO9nNaAwWDYlAjNc=
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