JkcuUacJI4109YvIJSilPhjlMCjADtY5CunnFq3ViPdoQyi6nh6LC+XfC80zZ3mSEtMWf+xNT16cD4BhVM1PpAxkoJpFwtvIBdbzkAItyczSR3ZxVJZEwKTVd8erpwFeL6qgJdBzN2ARgUGHG0nQAG3G8wHsGAaIW8ZmmaPZzyHe6HTXqmYohjeo/V/dFloRncgNRSy5MxIFXpXJmCfH+ifryW/7R/yZokPCic/p/YDAlR8tn4+qPd41jS7QhpApgV6Lg5/XxHp2ieHrGA7vV4hipzb2S/HUkdUJsL3EbMefeiumld6ABgOWOlm5USkpxGk6Id1V82mSJFkX+exYw7vHksj/GTvQVL9RluXgPKRDQK+qp7t0fMbFtck0cv4XT1ZNJT5e0tDdilFZXCtSGzdt/bi5IzP8WmTXYl+aVqR7nrsL9SV/zhx6xM1CfZyGCSKQ3mhc/LcL3UkAzOqtRc7uxHhc4XRfcyBInYexxRA9Otmpm0aRzJ9Rb3DsqLJe0hTU8bok1EyXAhs9+sssXdYtOV1Qgx3iDmD9U9WjnbgHjIf/FleTkRCdJsUtUe8dNjWrG2AddyXPjsjolIAReIQ3a+Bsr5Kd1v1mjxYuHSknOWQ9tkiYAM43NX/nX1SCDeLY2RlLkY+2XB5dae/uNz0kgn1fvwXP79hqtX8Cb6jZ+916L/nbUHHs6sz4iXIlXVWLtC43k8jqWgQeNGX9vLp2KayM2eLVb3VknLg9+6iiyoNGPchxh3qKD1L8oI/tn0TK0tYctySW335pNddt/CSHhejVDahZOvbOv3tzUtu3gsxRVTbl+AlWMpZR5lnG90KOVxbVLEyz/BTK3XV1JvF41PJM5qT08tfFVS7fUoEadub1lWBL1FTZONIGr54H5ilAIkVc3n3UccQGNa4hm/yvWn147UzZvhiyyqrTZ9oeL4uq6kz6FfJI8Z0yVAYrpEyhfsYB2KhJuh3cKSZ6Qe80r7rD5A3k6y91Yj8hPhQVvkmixe+XK5RJQlnlgi0ZOXz0vuOhylZmKCMCRR0em9QspgRl+YKavQ4N1B4Cpe/edZ7jlnp5DmKpL0BY/w7mShXIw3wOctTbCv296uVBO+j6AnVaE9JRKUwuFZiFk9mIkaZ2etqoz7iT4t5haeqHNIuOcDROmzDxdZFq1a7XhFmjfGpA7D5q+ouBhw6tgrSdf/AtSpEtB7EE0l4R37E6sIFQEJreiOCk2gwW0J86XBduT9MO8Ibtjo2H2tICE02oSs4lQvZPhZO0qbN9cM2rBcdF+8Nur6QdpjFTYfhdt4HWwECnnpWN5Onkmqd7gU4+cPjRD62PooGBzZpYLjnUSng20aAorbRGwvejsX0PHxPJvXVCoqF4JYc9QPU=
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