7/cirhFYV9jBEFUX4iJuI2g2FfoHTIZXjbcxBhiZDkGyi98zjkgpn1UIsfBqjbWFQnb0MFvzzUuUivIer3RjNYa+nTRZpgHvBApMZB1GuvKuOJAAF19IE17uaOGF+BTCekh4+gieSbg4AWwSxzb03KFIXYniOgwv+dZ9g44EmTfsAYixXYeb0TgCL97K6ffKcU+vzjLDvR9eHbdoEZzi4Oz62aG1Ch4Ps5N4XLFGy0LRsHlEdw3XafNGTf0/jfyAf/o+sgj5Nirg0CCiC5nJrcTOMAc148/vcN4oPtF2R6UWFySBw+6rL0CZZgC7VXtcchj2ca8+C9/EToBY0Qm4g5VBJp7aSFVV2o1DvCN5kkgh2SGln+t43vqUb7zQCB4FcvDJlBvOu//yeg4wNjl83pIMRDsxgXukGQcMBExrGnXzCpXoW1+cltq0t3ipQb+lL0z6UKCzU0hGY6bqqx7jW5DOdui9/L4kB2Nk1WucQJOy46RXmyLPvDba6Q5LVposHyR739C/XXuNhk2ADvQNeEdu/NUdmqd4VE2ryOjF4EhvcXVbGSsyoemiXxfDEgH/N/nwfaKCixakQbi0oPDWFoIZ8O8NwWwDYw9LwHP0ydr4sJodkLG+PmYsoOc3km4vXWfhzvnK8Zmgc+vWhnq4IthuVVGAs9ue8OoDXNZdLnYV6G5jqLSMwr+NPWQkhd6owiQ3TBhf7ogOmiNj0Vj2Gt6qlaGRmbx8OxQoDSRpHjHQgD2A0VYRGF6nouxQ15sO8hchx78v6tYjIr8m3ZKN+dcfhxU9Xt+Bsf5YvVp13gKEJyw3bdV/iD7cKYO9YLKLbErXBTvlIwL0qLi4X+/oIg6qP9Jdx7eHuVrqBLW1/clk9yoZEIJRANvrbK7snd/bY+izDcbIbmChtvd1ts2kL0lMMzULS2z3+DwLNPtW/NcJeJldbzL/9Yjao9pqfbtfAwnXEe1dg2O3cxz9P/Uq6W4hnwBDxNOwX6WdaCLg3oJzkDaHqEmZWVbpe17lgQWL4tSRjZfDP0MNkWF8cXVPVQjTImx3bOVUpNwq6S4knuLEAl0xuKm42V75Gw7wjiq+caIxaqKhVQ5NKhl9LCKdOD21Tr5A+lAmG3wB59YRQujAy5rvrFmqquW62OAgZGfieUFJCak69Yzlnm2wROhkOHuZ5CGKC583KNKztChBInS/u1Kg6SXMEXFgRztDcOjTkYs0kcwH64cQZn02W88ZY0o/3AdP2xmJhdNkAvxVt9zW5wsRH56aml6LptBCWnRxrUIL41ayDkUVWCE64rv3vNGuQBUjEBT6B1vdD9b3Y8UIBC+5JBT9WoaKB5CVlZq8LtCcJ5HrEeOL3CtqL4d9pq1SZUFv/r2NiqyfqOk=
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