y8jXEPI1j7FiXtzxzuQGEXO1ptTPt8+zVuFIi31Xnt4imJKFK6xksuRVr3M0wa7bcmLsSJT4WmFI24szR3oPRj91TkKk5toLXk/vJPBwaJAIV6DyuIHhOnmwJzhc+q5sL7F1qDVYGzXCL+J6fRblbANEprI701PN/sou78k1WdqbOME29GvekhB8KXbHo1N1NjZVVb/tYCcKtuWMWmokYkMgqSzYAB2jAQ7R9kPCrU4QNZ8ou5h13JR1ScdpsVbg/P2dPCnO6zrEn6fqONrVeZz+PIrDfljX0cEYxVRuIIzKvxLIrTSbQu54vzAry0pTYReavX7LAOMUesuPW5clKzsDjBo4+Irtbg/LxKK5uGd217ZFUQhHUXvaOTSUIcgDP/MxPQk6R//T1q/O40hdhrqjIdzgJaUlGGtZN/i6XTRI1h2kekk623PahZN+sWB3umzFA7Q9Mvp6r35rvlBy7J17cLmVkADc5UGKtpiNBq1Flp6qlZudbdT91mmVBF24nQ2mnMhoWN5ijD9ZN/q7uLhTn84KTRkKAx4YNNdJbtcypweG6+d8qKN6IWwjKH9UbzOJLUnKdfUWHGlOmsT77rmlnqopXXhm9vgvdwlZ3VAoYkQxhRA9HZ+HvLHBVzmd6t+C60wOUHL4OyqDhU0pIu8FreTuaBkTwweDYEDd3PLM2jxeI1l0xgvR6dp5HYjLwf2/VUD8i19KpRIvOSkPo/kUOmdR2Xy+gTFC1vomTuNjM0pOZtG1QkXfnjqkIgxwZemkTswfyIjfBsoV4gdVA4skHRvh2fxtieLYcVbJFRPB4wpBl25yaEKpRKB5nvOJML3WYHnt8R2WMOytCThOquEECADfQC5XrNIIdL8D1ZFtbeHOmM8QN2eX3vkJ4xHfupx+vo+oOFcmxOUWUDtKsEH4SdMpdfWhBPtLMq/6+3cWh0RDSfyHL2NEi7IWYaYH/mliop7eq/TXgtmKdMb5rKwqdDqvKbL8c8kfM3CL7su+D/FiLgUBGbHg1PaUbjUfpoRypCgim5hQy6Cue8liEWughdHsOh/mjYOQKQdZP1Hf79vx6DG+nWANP2RKzL1hAg/IT6Gday18cZ8Z9QZGC6b7xtvBmgjw9/T07DUl1OMhlI/FAN0upvmCgQVkykqyZ0i5ApaazpGkpuOGJ/q2f1s3XWsPjJqUxogvYQAyHGyF7hQT7b5JHgCykuEUMsPl1YdKQxg5NCLPuPRnXccu9UeuQBi4WdWQcnzw8m8NNgWxsVxlV3gcCg5zrPTi1u97eeQ39il/JlYgoH7uEsB3CEOrGK+0ikhBzFydyk2ctYB45hPikpSWno4gk8OiTMZruw+cKYTKHzXtFr+eeSJNK/+52I7Q80daCBml9DI=
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