dgv/06ntcKLJlmQeQla83j6MEbmQE4bCDApuptKrYbdYp2xmcQDVXb+oRwkB0w9IYIPrR9mqneHTBoumY4utwuecN5ifIizPuuXkYYC2NYCampk7joZZB5f7pUhKG41wQFXrkSpuuBiHltrJXXlYI8Dx600XfN2Gf3UkgiQwUrgKko8WZzVxq0zboOVC+FlqK5LYRD610XCfi3ZM1po3J00n8JYI8iHtxkdagii29wnk9xcCrvO6+/fuT9+tNOj0UFGUPAqeWWOf8n2zwK/ihnClOPkL92mrahE1EhQfbn6mbhU5fVIAE6eVnpq4tNChjr7PojHlkkMkDc/vtT1CvcOmf+695/TIEPF46mw1EEQNZzsaEpzdyb3RPQzKflAJ/5A4ksrPe2csjnlu2WTWB2vecgPU0X99hNwwfoGwG5SgbeKNUfdoDAfOV4tHqlp/AXiuxuAbslF3OpfsZsvZMyNshcXXeEHUWcATgUdDzd+vbNFKOWbUW4aV4gp6KrYnGxdJV3ytvHgzOpGawojzyE8QVdZjB62vH3XGlPtUF1ed8LxyB1OPE3mNW0ELC9t5gGhnC5fYzmI1+vwEleaZlhOOiZ/tg4CVdc1PpIDXyTXK1wghgoOsduUkI9UAkaHFqQJL7YM3Q3zuNlFA1UPpbRzHhPPySwl2hbAlM0A2KeuA3HWhBE3n9b0mDCDm36xUeG2hnEG+DpB1yRnsN21LbEqFLFx5zB3ZN3Q2wGZeTYmu+t33Dm9rKwO6Y7ebf2KVNKNE3rSsAd69gh70Ug0teZ7NYCYpCazOd3xCDyc1GijkV9chMV4V3twFah671Q7nbBGW6rZANreKdppITeCQlJAR22dgYmLm3TTGQBEXvrD4ou/pigZjkg8pvkWMd7v3PLXK4nnJUk/yyUqTNBq+yuYXMv7lQYYwf9vZ6uMvPvegpist0OByEJ55mss4a3Ag8T0omz5Qj3voDbCELtB5Era2oQRC/qVPSn6w1gBbdAHZUuk+Exb2adDZHwJIgDPbUz8r8CMNr3D37QJjNof9qDmdpbQ8hdiaOeEhH7dUG0GphU0BvytJxIYwdvlTsuf5DHUAWKrap1W7B6VgJePGG5WSM0K4OaRuUduRnrtjL/xn8UtrYfDXpamV82apTtuAwGkH4Y9HfLTz8Qr62VcS8XfB/eR1eFnY2ijDZfiuvVgqw4w1ULmzBafbARsCfHA9j9FtRWALoQOFS5pB7bfCW9K18I6fi/7WOAu7O/pqwYZRK58Z4RH6h74aW4S9UgHgRi1Yb71xc9NNOK6z3k4rVaT3a4okI3QIom+xv5QNZLIdZIcj352fWa7LS6NEb6XR0My2T9pgFZEP1mzWUx3XWlro2M+sP4RfCBCSxS0=
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