FHu7fuK9RZocMyQQQcXG7uyOrQ2BjDKHeb3Vm/pAze3oYUqwv4+srYy1MKKoKQ9OCtdJz+OyzgHkNcuuwu6gHmVp/xO9gCx0z2LXzT+U4O2f1N36Mhw+e90aLYF2i8x8jnEdiKlOA+aiclSJVcelLx0qhDK0p3gfoUbMxtVJRIhGrsWhnhlYIJ5krk2uU7jhWqg7quUzh088/ZDzK+UqCTyV2UomJeDa+1KoV04TCnb+YHRPjYD2/BHZexrAxY3TRg/00QjSUvlRpiInI6x4t5xkWkTe0+qYW2ugsKKzBlEFuLTZeaZUQqQhKoz6BDeICIpjDGXQlXhCfB2CsgyZDs+GVAzZM0QtnkMVxrgcSpDm96DTuxYnMSUv3bV3oJOLoZ5wMGzQvBEuOZ8wVwnn6X9elLTwdz00PgLHPAyyswPkspl+XeXy+yi9Zg19Q2RpuKOiLoXW8kt51RRdZJ5JYdwW3vVzrVLe83xsszvIYAl+enT6fjDj2/uGonTri5Qokb2Qu05cmZ0diHEIOAYQP47kZKHLzmxFvAAqbiMqzY5GG3O41ItejRy5mQJK4EPJF0+BHqoa7BBYUvhFs/kQUqy7y/8IEIexbGv9EH8U8ifK39M9gdwnURNYJSr7yIOfS/9COayNj3wwkRZFawA9UWSCa/akorEMAAL+Btw+90oEl3O4yTZBFoCPSm5G5s640SVw2jf1LPe6JaLqqIk9S2wfz0FPy+ewWQeDWUEPggQdk+ZZpVh/veG28WeiJ2ULlElLYJTA5QT7On5PbW+8+2+OQurETKeXzim/z+mLGntU6obEISA13AQ0G8IvmNVxmpLydBxzL3vH9oGoUZIA4vN6QnWx6G0SSvffFixunqEVSbXy9gQCpAaXQhXatJXfmJIc+hvimEv36Uln3lQOe+9IBo4TIpuBjWpr7PBnM7SZqXESrm9UaTnMl1t4wGT96SoQiAwVxlwiqOJAJnFUqKb9hLjpk+d8E0tya+uStkJt1hKFvHe9nn22zl+2S/5X6UyLODerGMYEWG1mKAWMN7C/FQ+8/G9LdzCyYl/kTNQ1w/Sdg7TCnVruC7M78IZLBKrBmXMdOs98s1Y0SC9eAzEeJm5yEQwyEj+uXYJnedoTcMlpvfDu1KH8brhS75BFUnTO/RdwWAcdvkQ7b+ncFghtgZp8EzYMDSTUueqhOGVYSYPxTZpd293jQbmoGC6iJBPCIalcGExFGay2wPn/JKg2MdAW56PG75cL+NdX50dxwScP717Zh+f/1cANZmXScAvPZWgM6rlsmVGy3LT2xvFLYAcbbPp/e8VS605vNP1GsdH+yO2KjEa9oIj17YPO1b+jojMThVgTQYyPLqvTlVjm5rT3Iv6L79d5XOI=
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