sj6deELgpWQT7eqqksSLk7ooUjPeQBi7JFWdB6QBgz9C0Mm1uK9bhgfQZKXxjSMqNhceP3yYAHPqqkKikgTN3JH78tJgeBrxm63ck+TWP3o88pDjcXHNXti1SPGBkGJ5D5XNAr8pDQVqREGJbQuZkbzGyQbmWY0F9pWZ7D2icGeZp+ADnPDFYSBsd8VQWrYkvTHlS3Pqiql8soL9UhoG3cnUnZ0SBN52l8ULJy8YJo5IjTxKRvd6pM+yZLJR+sAq7o+Lri3OlzhI1GKUa/fKpuUWG5Mh5Qc7VVglDZouTcyT3c3SFbGXmaJ5Ed2eRYMv69n3caW4Ff+fonLpglBhQUHClqiEEitdro9HcpTR1lX2GYDdJhoOijasR3xYz/VTlQhnu7AWNgdrF0+33shsM863APphrdqGaI+RyZxLApGBSOlqsNUNvuZGGDoPGr0ezkoM6YAxAmI7pIxCKREyVKFlm8+H+yN/RPcuqObkA0u72hneG1HTABYwL+8cbJBDUX8vQ6Z1pchvY1YuPzbrBpZgnQBh6qy1HHDxVXATT4DCFpNByHh05l55p47q7YzrJEqjj8mrMavmeqkF0WvSo2Xk8EyGXIhcHyMrsHrdpTP3+SysvUq3kRxPPC108qopL0zSBzbTJ5zTh440ANNwYx2Tr01a9o8aDMhfylJJisxLCMShNshWqXHO8czy1xs9U67mgo+CLsYHnyqJRWoL72fF2ApIeIDM7COVcIwY9swyBlRRoGb5t1HygnhsjtPpxWTzDd+OmhJQoA7Shgo6y8pS0Vb/cUCLmCXcvDJwuaC5RrdeY20h67stvKQgS56jxFdwREC90eTP5db/a9quEhvbZ/8WLKuPmpu/Ue5QD7R90GXWy2hy2/D9E0eGDV8/S7KpTCHM7xwsklhAC1ziD1xMMYDc/dfM2Zq2KBebSQkFTjjMaLGGOw6BQ+fSRXltm14JK5GTlWi2ramVDJvgLcyUIDDerz6JyOI0yPDFfyWu0uEMj+d8zcJWe6DUPpvLqgeMWhxeU14Y36OtegRSFkqly3uC+aWZNxx6i+i0UMZvuR56aNKzoZFDJ9at3GGZqqE5+jKqucAwSBl5IZriIfNG/Xw24TMl0M4k7ZSRaxUahlst5zF/XcgLwI+1fjngLqqgsXmKR+5pYETnhFJ6bMHTnxKe9hiwddI4ikpnewd4207r++oT8R0V3EJN8Hi3rrdLHb2CfP6Q07E4rEeODWwmcBR35V0+b3apwXvu+7FsaN1XD2nEOzSozF8YuQ9rMOkyeex3uGKdqOIeM8RhqtBoFBDJvqH4ueKnofnZgeGJKBdCBMDOyKcMIfhDyWrh6WjilKO5dOPEQI+P4VIsD9ud+ysfuKNHf8r+wFs=
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