aEHKrOCRis3NrJztmfFxYB2wXFGgi5IC35fCezBYyWwQ4ps0waRh1APtdiU5ZPQ+cQ+YlUif89Th2UGD+++HEV7bxxWVrFYjqvJhp2LeXsASoIaqcp9KUUm5LZ3VBQa/4y6HhSd/2TtpzxsL++5BZOG1cUzf//dr47cC+OjWX+j54PV9eyo7haefXiM9rRGXihLjXhX/wFDUO/En7R9nRRbu5YMbZ+eKIsaf8Js1frKER23gYLW5aRmWRmoA+EcFP/pHi2zKtEc5H+VE9HfXzmux7fXWfrb5wYScD011PEJW8IjB6f851hfHtaIAV+bOXJCGv5e+8AD3r5k7p1P3jyjXimXMGbs0qiMbG9+Pfwto6G49zRx9w1GR73JRBZJMPsBLole4EF5g8cEBc81JnKI0vAxULQOSX6FLQ4zrm68awlJC/kBLTZWL6vJKp0giIzv3go0mesHvJXSFVEdmPfrmpxZIcPJKcX0cSMWuyhEwRfiC5obH2TaeoAneSk5163ZNTkh447wMrpJzJBHysb/0LygCt7UkkiX3tHlXfMua7Q2sP9fXjCVYqmRadA7ftQicVT/rrBwUpBO0r6XB3nJXEHi1JHQwqbSVgfkW7w2nAC8hcsLIyvtdtUvufJOZOaTh6+k7WHXiXpAFmcKP8m7Dkq757xjkNEk/pQ55LfrGh7wmFzBVZ5m2aenLtk4EU9WRFBYB0PqwtHK3P/J4W8eP/xpxlRIG+UYHJLEyhNKQjoPyw2dmI639Xbh4Ez/SQ4+yfnk1RCN2d2E8uHLwb8lIlHxOjL+lkXuysLAhWk4bzwahLS0jIX+Bb+Wbo4P5iyWnOzC/gWPdbHy66yb+4VIR3lD2Vud55PiDexSIgTF0AatPf0chWf7TXJDoUpu6k5LWGOmTDOqZ78fbzPGzkNPHCylcXXO211xvA1OXx/+mkqp3gfEbFUt9h6hZMtisDLB8r2Jew9Zu6XxrZJssoXW6M/88DqC2+8HbIkB+Tfzw7XLHFv3x9iEokYVnGOOKxj3Nfv/WK5k1VDYxYa+ARZzBCrRSn/gJnKlyaLfGgKYFsi89xsctf5ZL35Mw1xyLXawqHbiLEatrn6P77RcVlMNTogEYGN7Cs6llD1akm9Wfri9F/h2kFryfKcg6KouRFwy82Qb/sZUFU6Oy4XGKT3rs2DYXLCQxWA2eRahjmbbVa6Af8J4Q9kN/dDSKjH4EviSJP7JK+sLtJ/D4cDcVegX5T0xRbFuZvBOFQ/I5SWvwDcdLzu68FGI3PW0lDm2kEx0jdUtkhttNNhKBVME9CHXykrpqUbG5fpvPAUOMiJHp/vzAM4ADoB5g+A6rP8tYPPJ0q9zbh7zRM8MdAjCsjYBVCRTsHBziIQW7ccI=
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