fQlKK0uXJqsBtPpjlbZJRAeKGumP4aJrLvuwpB1xcuDVDoQ1ZU8B43Q1GpMivwt55EW/Nqd5QDOmLGThFZ91Xj7mmCanTRTHsLx9yJWfAO8z+2WA41WuX5DiNJAIayQMW6lcWjr+CqvnlriTWOTEPP4DCGAuKyMv1GhxR/X79r6UvXRye9SEITOJofUs4aYOeVmPiMf16HmXlhZvgT3QLRNu0Gpd4AhvMYsPEkY+vdb6aExEJ5Ta5IzCjeZOJlk0j5mafBfy0Uh4ZyViEgQpzgsMU2OKsdidx7hdy2KjCHJ4m6JH8EDhS3CxvfjWZADdQQuEyox6D3mNl1/WQvHS69h1Adz+ZRSyhHtXeuXzHleSOw8VQB0VFWdVFSIZ6rIIV4QFoniuwJOJDA22ee36mNt/Mq7FOiTvzuLeQnEFoMjGgntz9/Oemb9DAZOW4tJ3+tMCvgQhFDhopkHaEIS3MUEVHduDMlD+6lC3LzrWWOErBM7IFevBmaWL4ibBaFbSNmqxd1Tk9IY3pij7n4Q1Pv9Wsmeo5XVRIpUs2rmx5T5h1LOu4mVRBz4oqWopn2lI8+bUUrBI+duUzBNyvSWeJFwS9qtp9Mpg9bkQv/HnEWEepPwUXDPS78B+Vi6N+DQ7QSeYpM9aj+mIXTbtkdD42fwNtoYO8AHXEbi1ocNXKrZXlH53ARWAmm6DePvd99eCxXBk/y+UUNuyjeDouIifg+DD1MCubua8T2zye+qeJ7iiMHo63xqa+Ae1jzJsrEjRpr1vo0GLKVdn+QYXnkJvTSVA3FjhWfWwKS6cnNcYvHx+LhWhNQmkd1BOoVT9rANORzLxNkYopAaoGLz7giWTEohFlF+XV6bgS5/kjZ+pk8uJJ3qMoPJ1nGdE9MAhjVUTUlLV7JgNg3IUAs9oi3hjPvTV26rdkWVe0YDxOMvIxURb7iloZsIIpb4rg/eUbT18R4SoiO3XNYc4r9sTFJzBGsA1jFSxqJtjAh5yM300rqgNMRgLQMZF7/AM1cgfmnsZTj2c+mHk7r8toHdgBseLpTkEGN0EWZGmyU4MMEsOR37V2/NA1huPL3+3QzTm5NP//a/pRvFnJRN0PkKnGsoy990cimzz1HfQ+FbnpZyxt0IOcyglDIn5DggCHz50EvO4rTcwxv79kYQiwxZiLoZQckz/UTlp//lSZsK+lGB48kbsTTtuwFbOg3Z7yccZ4ArumB1l/RrfxorxolpimUs2vW2xmOLmbbkW3zqwZFxH14/0+1BBxw6lpgE34Yb0yCoej1FlEmE4xxExVWyuZ6MKM+88YwWdz65Ij4S0YotzI9kZH1mc9laAD46LV7EwuXlbx4q6QWm02nWm1gyTvBsXrNXcZNqSIzOxnwKGhBA=
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