uXjtNBC1KevxJER35L7JilJxoaJvwxUP7Bh/77kvBY11+qCeNd80fvtKA05zbhlgsMb9mcIXSx8PlupCS+fkvnMiF+oQ09oXbXi04uh4CETWuhHvLEfK7loc6ITksq3DH3WXeZgrWLcvqUQ4U5W6TUJYU/VWkOgmG8w0BWmIhKrw/8lzEzPH6qgH78+dQ8WmyDj650541LGSrG1ZH9sqBV2/tX59f+6BOPkqzDeHdPQfxF+/3gQfcdKoyylG3foQkLhH0vbAYE/Cn2X8p+Tn5D2qYSiPahrGJCEzMM6WcVulGDvyBuiEAipSf9dzL1+RVyIzT5UT3i4kjZxHF4n6NCHvzp15fyrF3DE/Gf4hp9eEAaPxMwVGiufBUJgeKNwZSBOvDlnXQhVwj5LXfd6hJnjoBl8EDsCjskk2nXE5xcvu3us1+04vrkz+5GEeBbWFVeloByXABEg3/PfwAD5dINfekP8gWgM0h2xbUo7PDF8cAh1ytSXBbGzb5vj3koq4vViVuxbaoemyMoVWEjJhhXjh2Dvl/pZQCUskbZcT8f+78e18DGF7SUjcQvidQVU36PSEaF4wqheAIW1yD0Kb/LObzA2zvsuTjs+vBOnRuJ4eK4qrbzKSX1/7KMpZG7AOQJ5TFP7Yf3gxcYDom7pD1rdnVVKPJnfLLagsB9sQzK148hAseP1lJNEODEhIAu023FJ3O4DzO0hOxlYbCkmNJxe1rtKvY52GZ/NP5toLcR5x+sxMpbZFka5w9cITwrwizvFcV+U48np7Cl6DAvVLbOD9Jmy0WzLxeiwxPU73aB/3+LTZPiZSSLwJYkvmnGW0EBlrZqCv5wqfe76EFtiNI5Uwv0Asdtj1iXkHVcdDnvvAgpAJqpzhIbrW0+2NRfp79OioT52Ql4QayD8EWYz/WWQBmtHEfiQPy4iOYrTYqN8z8q0LH0blTs5lVeZDcf6hM/yFosWMhoDoTBKXrVLB5F3z5yGxsBVLh/dHIoD7Drd7iM0EEeuHNzgyUT0df0yXBh0HICdva6U3C1b/EDE+dLI7Pwx+fxLkURAdanGJpySgIUXEkhqMVUx0Q5LDwBveEdZYP9iQo/2yuOiJWZIWygjnRI4z/MgHo/OdySMK1c9i9v8/NYLmLRp+JQikl58SEvqPl9dDy0d4uSoGVHbA2DGF21XQ3xVcEnsCzUZqOLnvsC9arik2vVxcwYkn6Ph4WG0RigEkwStxb1PUpHbtvpyjRcop2nR2ksxRdnPkGcm3glbVsmyKPOpvBFpguam9aF6nnJ9+eSuqMe9uBobmcv6Xv+5SwbHKK8AdZi6EkFz3kRofba7SJXTzRAfkzBhNToYZlpobWv1UhsYPgte6HGEzLb4AUn70I8tT+Gw=
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