FfkEdDqWbciattMHN4TLtREyjB4xoEV4ECTaPMdzJYMhSpAiierxnu4/VQvWKEgsjv502UnTmZJUluJ+UKjWgIkCCNRIiBms0t32CsNbFPBlrbT1nZ/N3/5M9/GqnM/qj/722pdw2oeSKjmjLaWhXTKE1dqjHZCOpg1i/cfJKs9/34ixplifxg0JO3N4FC1mmYlMXFlP62UsbrR9GDYBejvkB7GYpVbqDO3pltn/IfHOyQSJnJ7cwPGqtLdtJ5uO3lzE7ai+3prmWLpWrhXGu2GCLU0Q3V2gPKzbcc4Pv1pNzkAPftX7kexgfEas9Eln0/j/dW/V3iJboFpvrKaTLZp8NSyeak43LyW+3Emktx3DMuFzC/+IcocUiOgfSAEIe1tbrfsZhTtMEmaEvhxeG7dJ7TSnbdFf/QJqNuyEHQPH9BLaKbDz4ZpnuTO4RodrxN7HDRVOdC3Anx60FtvlErsq2kzn/GRrO/E+VHk70RbWVtLqUPSQ5Q7qINb/UMOP+vex2nTbFOBdnjSMXeVjpW89Set6sjP0NscP/DQuorwLq3Asf0WwAuM91WY/eQQOTRDKTIG5HO35S8z19fonp7hN2jAdtyOJSuf9+bfoYNl2oZRUrq9SU1nEd0AadClY4EG80Mv5KsQfqbBMitB0qGMycgY/tFbD9mvZd+VMO8VqLqd/IFtM8mzkDnJGo1D7DYZDneYv9cFuhwuMV2hbflILLnQPV/kfRQH6O2zsDrxRA9W/EhSjGK++uJEhGQL0qfvNLM9IH/n4fjGm+WWJqhifehu1k6w0iVDxqK3zkdvEMMucFPKvbZXJdCTV9bERMw9XqeisfQjzrVUbmUPMQ61k5lhnspSbkmPksWVPrOVwuLzGJ/J/d2Q8KxbUgEWyaHm/eW1zD/OqXHo2knIBHe95DaZbTHG4CPZkJqRFZMsnhh24ATgYAuBy56fA94G6w/Wxgk1AM58XROvhDP+UUbXWUmOhTRI+B2UzlFBlG+/mODTQGdQFcWgvtBj1nsFm52FklU0KyceQr1aPbkg2Co3Va9E3N3hfSM5+f8R+Sw/i52foDtKSJIucmCKUsf1GDjQeG/OVOCwBy7S0ovvMfNlkVjXz92yIeAArmGFjtv1Y7WwAZJi5EugssprR8rEjtgKqAsbUti0OEPtylpIwaZU4J459TQexB68frVCZ9/CWAdEw4sPo5HoG4tJ2FRkR7Hjb0xIC+IxRiXDuBs/AQv4TcEG03pJgY7D1GeNJU9stFInL/K3C4jWIeveyXgr4V5MNZSfqa39QmBlU+RFo4RwXnCQQjAHx2DpI1K04TO8hCy1FZ5LeIi5idf+qNyuEk1A9NrUo/6hlQyWqNiK57y+lCtmx1o1B1kW4S4Q=
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