3ebeSPOXRKcAj/rE6ZpMG/bUwqVqcCW4m1dY8crN+Bxn0m1m5CV/obwStZNBvuScjhcxRZow1LEHk7eJI6xUWOh7iC2a3P5CDxOmVPG3RTlmr2OOLClT06M05btdIsO0JaHhv3uNejm4szJ7M5XxLoL5Fy/OnY0jd8Ux7WQ/CHpfpT6lIcy/K6L54GDM/afF4Ku39Wz5iGvCrGMTRkvj1AyuVYML1bxEUGXgEl3/AdsIRHtH1rTLFXhjdcZ4PPAT0tn3RiWSjFJ9wXqDHXY7EhZR1MXxrDBTIsy0K1Sa1xRAt22F9t8g5JafyJ/qZ9FEBoKMU12ihfY2rQ5s1KRK6Vi4Gcjxne8AfTVcF6l+2XNGb1RUpnBAqU/fOOfknWTilNEDfVqtUj2328F+9iG+qUX2z14TsDHkwFCoLep1dsEWzH1CXXjur7uAbcIhIwxEfVDdJlz83Z8Xcf4j/ztThJuMRZfQ3mceR7MpYkE71OeDUTv4JkT+xdBnnojXV5cRAfPP3Ae4NmFFpb1D6PMw9T+JsyD/884d1e0P6k4CtqYtIj56ggICDl9D2C6HmJro+HZ508BLnvzwby7Ta3dCiDAru45zR7RRokn5jo2q9p3p9OZ+9mEouEbdkvuED3pIj1nzKyVfwCOyU+p/PIUFCk5Flpo8hUuuPPHcAuCwmMqk0MKlf6jCCpyT9O+mITIBHqUdyReenqOGF3fCtN84NIX2ufDIz5AfWP+kE29f67KQ6q/QT+MdnmYPEGg5STpS/ft6JlitZwITU9ua7a5P8xDBtxxf/XO6Hu2+XK1LiHMpFzzSxouja36x5j3CXJGUDjou6USKo1V2ZX5BHvPWauO7GDMZZYVTAi0MmM0h/JasObNB698wTP9xyzo38giy1w25fr8DYx6U9pCU3RJN2wsvpZmVXgK2df8tjzZf6/AZ0obXLxYphEXLh15TyLkYFDbbGs4Vmu4iY5ME2i7kPFxEHQJ7TcH+mVLYTH4ds/i3QYPceTKyZ7nqGJmxfCBMc7FLM5x8wZ/4zvulI4gFTsc+4oleqfZhKWW/Z7p+TdF8q3WLVE6qDIfc94TFzLz1eHrexwWi9nf4cB1DmQg56WlrY0M/Z5K1A2MpxYerGJUVf7UeQbSIhPy9dyBpGvPro0ssjRNBGoEVCn5yrKjU/C59GDm4RaVZaIGegZVmbyWFHDKLEnvXDARigA4QIdFH8YmMcBAb3MRgyov6WWzQ/YHcVm68JiUQzY7M9O5Gzd+xmGaOetMrifyEKhx32Hn0g+3i88zzrR2J0UvfpDivLO6Tw9XX5lE/xUVDBFAr7+yOZEiEtdETKHGf77afE+4FKLAB2rJUmId4fGA/L0hO49RrJBuLRn0KiAXg9nw=
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