YzNH/U8/K26fEsY8mNZ+rQswTh5X3zeQTbnOZbrbP6GHmfbZMDnOUE0SqsYpuyIZsUcmf0gAADtlCAdUPXxIcRQLH077/A6J+EcsPG9orCOEXmDBib91TIS7f9jJ46Xz5Rs7R9aBYwj4V/6nwu5aE8jYzq2fpbI7ALjSGsUl3keZ82WMcmms/lbXiJRJmF6I+JFhjwWxEGWg0qR/tpzLlU8AtZ8UvVAYZIUX2TanXkDq4IcR+z5yHpYIHcdKwJA5LGL1RLiSy47gtuKG7pZ0TBfKWsc74oLUtnAwCnQmUhjOqbGfAqYmRYBA4U7IZRLPaCos2vmJtAF2TZJ0gU058dtufEncftgAOhyuoYuehECuJ+ZqIT3KDDCAOE+n9/khBsbRaqDujSoZJxy0Cr7RSFmrWLWTKuDrbz6Lue160zE6FcuN6G1ocYH3h7LSiynDod3T/dBerbxNWwfP7lVbhlHpdTiEYXW+zocPQacLfYzjmODjj6vd6Xc5M9hrxqndpJLcd8tSmGwtHiGgHnEwhNNZx6mNPW6K/75oLa4OgYC2tMi2v6qWn0W6jOspVHquZlWcHqbf3JI/Iy3Nm2kh37ks2p2AP2BxsrapzRj62v4+Ksv+H3phQw/JDcZEBvovX19FK2PUu3NhQ/t2sO6epBuNi6w6nn+i8QdhbArUaSUBoxwkrVy0s2Klprlh+EaJEGn+SFRfvoco49SZH/Knq/igAyfUrXN+Ckdb8Sal/M1qpb4un/c6k52kDwJX1ifip5kngnQ6UzGuzx2w95pV2j3BqDCAAc3uRFknKBiqGZBER0vcBjd2KvN/k+AQoTMwu3bGUQl/6/HaKwnm3LjSRcSmh7sWRIUNKN62/ddY35uTRsHQsD8BD5R3p1wm2PhM0I1fYGambsI1cXJ0vFx7jYqC/BjGfeNUhCKpLQHaFIxMeJfz4rNGAW+QOT13lttVlBhCNkPe7wMddCclpJRXsYvxc+K4TzpWl21j7qChCcOIj0TtTPT0CX1lvv587va868wKVU/7BTvR8o408hjLeXNBOOyUMA6RwwD9rDdLQB1GSim4j4p4/GvhQJcZT9rxjbCHliuahPqJK+ZHY4gfvWLhWmmHZJSAnsMrs1mDfElDA87YKYDDubL+JGmFt1CtaZfwfrNLBFQWzN4+zuSEVgCav3uZ3yaiuiWCKlEU2kaRMLKFPybLT4Dz0lk1ZVecl54JScnEPub2KDTSdxWyEF2XTQZVZvVI7GaO1RGqw+SeKwdjeOpM0VjqTFW8BikZ9mPKySEHoQyeV5ZnEvL3NnWHCDK/J0SMOtyu0tJBq9PnsoU0gVEnHaIQUCGP0hZVQDlhAeT7CKxkGxoM1wa4FvSb9OKgJ1vnxE/VtQ0=
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