jh/gApRjaVJ33VYqyvl1PTMfE9mAIdShsHH9lUryKgT2P5UL208+o4Vp6s+tkpsCuXlV2XG85RCOQ0GCRb7azARGwrMf0Wsf2jlV85mEXYwQTm9whMDUXurSS2BMU6hQFrWY2tnCy5t+RllDPV4xsfey4X3Yk8JZiXNrCGTOodDyaam2mOaBU1Mp7zVX+0VSubdGnpsAda9GOnEHFqYl89/4MCKwnwyjEjUchhhHpyUhbUlJuq1lcAkVbsKlmlGA9FT9LFer7mdSN2huuE34XXt823UjBaQMej3kTqYgQJ7O4ixiyqETMbyr9PaxlsM8OVBsQ8SkcuLTkqnHUOyGzjOxlWrr5ZIX0YPO572m0c/VCNJb4vjH4SoDNUx+8hwDnDDT3o/gHhy+pdlyL5bevgcCh48g+BbiB+I+WXNp9WRiejYR+qP/WNUmrFvQ2HC54Wj4P021nPG791S2vgPnSf4lqitdsI1LcxH+L4dqVYflAm2E6h7RrtYAI+P+jdGMBaJevAiHxRacONHacJVYdAwSH7dMR8CxVwl/XZJ8D6GIlulx67szSx1R3A25uoGqfdyPgURMIxJYjEfPW7KuNASnGda562O1b++N2yqKWK1YuP7GEvR39DcDqlNsxq4hAigDhzpwvszcwpK4D19SAu4Ns9YDw0EcQQ2wjiTfe7gelgTpooy65qA6xoZRZ4pSJHoUuCOw0W+dsrn+ZLjQLke408zzdLNZlsAKqnyxibuyt16YJEXtihH4vMMpIavhrkZP0dGVbvpFR77YOReedHxYhpZS05IRZ5wrqT4fhUeyGOZUw3E1WzgTLVe+IMJiYJ2drGsxeUSB4C5UNV2jx9+fcfjdUwopRqUSLHWUDqHeZlI1vYKzH2ovkp/UYoVxvqWC4pXBpx6V33AsnCbxbi4i4/Vhtk2NwTjYkDQFWrcXT6AlzRqk93mbbm4U6PsuhA7zvnCemLFWdNb49Y8AuKrQ2P/J6rnl6wgImX5+fWtVFUlq4H1071RWjMdsOXPbGtFf6S1RIaIem5LKl2Ue8tAwBjRMvNAoAjkoqUNh4wgiV6r7OaCXQxhKUFn5/ggIkAmSm8uNBOj5X4QgU3EDB9mzE4laQepie/7nkgXj4iycuJdgJz6rVHJ7ZvXOOt7IcWuWS5o1o6r6Ia9ojYU16zs49X7VL0qrXg6/E97O6Oq1nmBvHPd1BsjmgMugBH91ycOgoKHsMz94o0dGbKvYlRoLUujokggsniSepWciuJi9GPa4uyigvHR1HsnR/dgHutZD6srJvARfjAOaVbE/z+lR4iCb7l7P5/mr5vIUtaAdhuyOXllkUcAA6rXFjLoJ4b6arXq0tiyrNoljyDRMsiHehfHxxEqwFN30htQ=
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