2f/VjFEyrOPCdmXISbgaElf4ilv4Q90gYuxVGquL5vmA1MA4r+4KOeKljmNY1q8C6lH1rQWEoMfLDYcaC7QmWJG6DpqbKWIxuIXhMrKlSnw7X9GClHGg5E+3fNg4Ln46mL6fzzieNT+7D3K599xY9gNx96tTrBRqzlUL+0Ud/8fcg7+XpO1xvVwvshBnpwORqRaOynACH+WGNXGeeLTjjhYgLurmidsTcbQ/j3ycK+2Bghd4lLtuiKvBiwIvq2Qq9nliabvwvOchu/cqB8etYjVeWey4V2Dwr0D1Zq6sNYxFiLuHYno1Aq3fAlsYA9vinOAgwJY4b3CEJEHqgRUNW1pj1+1Ml1lRN11eNe4J3XMwBtqmK3tab8Uq74OugVMThHAMtGxNltnt+61ue2wPN46VjRu/O2XTCs1mB+/woUvsLSIOGcR3BOCSrco7aDKrjQ8TP/xjkeWpZF17yL9UlWkCckyLnxhlejdzj4yGM1OLHHMf2/S7683KIqwXKUx+n729J7lQe5U6Hs6Urw1M1KpN1A1/3rl5ulQZWUe9eABBTCX4eMZWMsgE15opIIiojvbeaMJIah+JFuhyk9k6xLyahempRESJ/F2r3Ukct2tyjUoRr1BA6ZoBOKip4eYp0ZTOIbkzJxAg2+oWptykWua2Q8T3WCW/HAJwHxmtiYkkwQAOQ2bF9nzWFsXCY2NqXr/nxjrLS7U6ompVp7wdRDTneAVw/ev86vmn4cW61/L3Hgql5PHLSVEDsYko6/ThRHd2bXgUm0/l1+j3lwdDIi4qt6uh8b4Ea58vEGs24SiqGeM1+2TqLTTT4d6YvLu2MFQoonkYhHN2uxnHlWhxU5zRdPwyZlbUTamv8DnSizZV7G4F6op6vq6warjkZfkp+N40z83GuufYpBqpX9n1qMFcuEwpUTBHRlwFVhQWzP9JWKs2Rb1qFBtEyEdlUd7wMy/A+vWvtepWDovhXU9FnrsPcNL7gNqgE1X2+VrN4vNyQJNH+H2VPqz2DphaLS4r0wx5MQ+qTT1vF/klE9dAjrhQGGvuJeeMdKZGcsMmo+vjDEHNgtTB7gko9uMsLDE1gz3N0MDkRy3zYI73D81KbPltCGbRpS8nDEtuRfD/jLsU4vn9NNx/v6oPWjvGxTLfZdbf8mlFyjf9mSHneYVzJt12uJFZaLqUM8GiS3Gj5VXFTCVYrU0d1LLZzLsYelNJ0BQvukVY5vjj+c28VxBUqlyjd5UrlQDya7IIBDvlXPx4PXpyuXMuQwL3oCH0OvHG5Hf0yDF+v/lT4Xe+w4d3LBgnGcGTeCnxBgKvvQWtli3JX55G8NQHjwpOoR1knelIqd88P+p997jSDuXA+wpSEylskt6pVTxAjZNyhrE=
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