1dsiNemkuCkAVWMNfCOMVixt39FQwa/0MALUVbaVXKJ5ysGRxbHUqsiXug0O6LoXfMbG+HD0/5nPldJsBcJyxPOo/mSgo8WKfAhiW134hGYJf43g+ON7TPJQpIYnziUX7QO/2idrh93YC0s4ktUvh8TGr2tDLvvrV2hvn0WAQmkyYSXt8KMY6CtfVwPznbz6kFG2bYgQd5wYEaX8ANqO+ZcQIdgRxuq8oU0MPmWkPkC7osPR8vykOcL7c3CtODqUo4QdVFUI/zg2uve+vN5MaRUfIWx9oRqRvTjDbk7FgwL/WQ1iTrXqCCwh1U/2llXehSv+1aYA/r7bUxCHrmYXgOh4mtdZFchTsJLo8m07Ht69zyCaMmHPqn6wuPGNAiAHmEjE8OBCYMV+e9LjWCDCZR4ONWYZQdb5iHBYVqJ/hbGKLDWLhSM+2eE+wQ4iu8NKQKJzMutBk4d3hwa2BWE7ylP6ESxd6TzQGOkMhZYbdFYkHjvDFpj+zyMdtn2KNtr0HACgp40cEycXiqtSWPQ5Bua8sReXSl2FV0B3ShRDjtdL3QqTQaY6KpYUkzsIvaLhUuqFTxymGzu13gypJC+byfGv/0fgJkrMJLXJvtubG5kqS/xfaSE7qeYH90AAXwWeuRzsA6wNTc1azUO5rFureLyoHIJyveRIYmFlBmVEKYu1Lfgr9kRIZDszj1ATOkLTmvT/7r3bJtCR9/mTxayT6OXx77E7Fa7/FboA3E0l9fUP+ejDz0AikF75D30j8EsrqBG/uxYHefeSZx17KJfwL3Hc/a0uvJK38Xo6pOUYwvuBBFZFKRp8QwDBaZ98i72s/MTlkrPCM2bvvck9NBB7akZ5Vy4fKeDzHkGv3enM0XB0R4akHug5cJKtRf6ksagbeF2DC1jNucMaBJauIMTSG7NthPiRVuE7Yx6WTyJ6gWcHT9kLSc+ivZepslGkorLvMTLXU/I+nJiVyI+InPk9GhN5C6iDOq5FJijFUC9RTkECAi+t0Cwo3wMiCNtSyw++02bbslpH8YDUVghxFJoxL3JseGM30t4Qy9tgoqQM86Srww1cpwBqctgcl/W18QE+ALIiy4O+o/jZtRPlk4T/nrFuD0rL0dCpiu9lBDcaO34zWxwgBKisze+Vz7LwRh5TF3WJN+WRB7Oqanx63JUJpmg27xjSx1ZI/QILsnpkPcJ4Dbi19GcRXAWpthmKrDk1KZQRO0K7KLwhErVqzEFo9MaKiesR5BBMHRk9+8AdHXF80ETZ9OMkgq6ZqGyg5m1bVd6zm2DTl4b0hTO2GOO9HQAV2PhEWuN8ESeMcY48/y9hjUKE5KGZOAxQ8dJ2OFmtVxQk1Mt2CaApgSC4M3MpaXY4ugQDG83nKRI5Kxg=
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