MmcFnDKZb4nZfD2tjrdTRDt92dm4I4J4bJgveo2VZUNDOvLeEGixnPRoAhU3PSy5cOP+kq/21swfy9IslpIrPn1yyN3kVIAfOgtCzr/iosqnShCngEzvFlDi9FpIdMNEI6CxBGuUtWWnk5/grtTUGefIc8TsUcVzD20aIuLXARuiyjMusODzIWbARHzbIfO1aw7b6IqGBkhN7BwsdCBt/MoojKWswgUBp7aWJmzXoHkNbzgWb8BEzJa4aTOz6SGseut7KKg28b2G7xYRwhkDJ5LN0lWBK9zA591fqMXF6ufSgoecNPgFM2GJXlnvMAtZ/k+hAQSaiXuMrEPN1bE3Vz7/EbUN1ZGGtdzVocCnvELG5jAfflJ7KiUh+FnrQMGwIhvZQ8Elwgkc0QZmNdaBvi9HVKDf/a7QWxX83HprrpgRpVjKXQQ3WcVLvXb/JPoNmLIOJw9O8fBc0jh/noRCQbk1pxxmfYCGdDD1/i4ncE0G4hCsSj2S67Dz5nvfy6O3a1lkgJ4VbAvBWGNHkgmpIfuhd6L62WOrehNL/0rmQaCVk+Y58/jedvgqI4ksRRfnUEJcVJ7MtgrLMKgRE2oZtoHgBDl/ulJrj4WzUJVcsf6/T/dFUcvYAyThOf/9XNUs77JVvBXzyQ7eLDZJBsDaABHTH6NcM9T1mA2ooBLBwJxszZBcE4CmutSjTc9FpS5mxiwrkEiDhXmTyJoK4ipOrrSPFJZWQa+h1gDzgOUUh8BVEa9tyQhQjH4XlPbLevlVqKkIblqTngF/JA8iLaKvPsY0jxN7bMpS7yaii2gYdgSn6xQ0KxyB5w+zNQvgjcycHDPKh43PxR65vMn4wcsf91SlFeGjPZB8vGyMuimjEvSHN7OdROhd6s+jxribAwWZorI3Hb1AJLBR+d1PkmyeIAYqoKqAQdqHbC93aKIImAC6ikbpuxe5KEDXSdU4p2l9tCh5tLPjMBgqTneHOi/s6gXG0GSqGAPE3sBMqyH3lRFHOkwFXEOBmg7wDjm8RusqFrr6c1C83O/sujODLsB8wSA5Ad2Sv9U97N0gkWAVW9XjomgJSKiJmSGAYbPygnhY8iOLcKdJsz5+VsKMEBwhhhdhkXF+js0aEflUW4rmXCh+I6oCUvuqaWdMgLfR/TH3uFXYIlKFFYwpJo1sxpxkHqUNQjGGVqPP+B0vq1SQfjkEObW4I7e8VP9Kp1xIf1hSEOOqEvEp17pRg9/zUbnzreplxlEyILnnRg00K3X324i9N2JNfWjM/5A29PcMrQ0Fu55+3rG0sp9RGaHnQOAFB/v1Z6lP/LjZwaeDt4h9o8gFoGK6yvJE0a/l0i36Zdh89+ClJ0LXaGe5tP4M79bn1iW5+aayNNYTLr4Fe6g=
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