uBYIPspyuS73tCLGc7l7qFoOwo+A1tqKEQgiXF5n3I1I7gWs4ZKCUyhfd/i6CgoDy3GSWGPfPgwS0XIViRfzVMLrgabvjsyKdG3c63txKTNuNN1AcLM5GCdp0n40ccO1z/JtX2QH/OruihnjNqOupayC22oX3QTKC7i6zSwnOAou6c9w9EzalCnUBJGJjulgZPFIVlp8qsRx60rbj1+a1SNIiRrXXyQXrj6bj0HMKerYGaJVFtVWXVK90gbgjhOtAqyotcyrvYoorV1wSeLK7FmCZ5QIUlh137vez9O1SuM9Z2oXL9WWLQ7TbKSYg/FmTWlIOs5+BN+eSjleETLUrC/sIRPFjx6fuNU+rVACMJsiL/8jTH4/71HG684Y49FaPo7ZozLE6xS9HN+t2WcgF5iXR2AGVElV9AFkas7SUnia4Tsp7gWmCUPDIROB/+CNYxohuUnSqY9WY2wIW++7+J5yrUJSHuUbLXDSMak77Tt1ynWCXQ9IeW4VqAx7hXJyzQON6r6vDCXdfxDRsAYFbmcdZYTsT2suQloSA5SsdNQe3odIlTBgjEg5dBObS4s2MWheVVtHd0GlrVx+H8VRX1bkwuCCnmwPhcr+y//yeGo5xaKlFx/xGenelFb7PQRZYoClostz8Qo/sgZ2iGHWq1/XjNOZInsPIW7LWNYGzRHSKboFVGc1g8OWtEoqQBuPX8DRvHK6N1ZgxU56rQztUcUOhV2j7e/C/Dr9wp0o8BY/AmE2bmyc8GXwiOHcQa5rUpZenvsFme8jjpN5HmCS1VIMWBRa74GsaDh7RUHz5xuAOHc11KC0VGtW8rCe8LsrnkxAIblZqgNVu7uS6+Kw8s1a8gg3d+W+Y7+3r/t3Bmawv1STMcHBFktTcumoXHsdcTul3oatWNnYAamm4gq8VUTCE6LSNbM3Cd9Gdo0pzgtXWV/s3iqAuAF+13Is8jBbbkvw7zhsAGyC4BlndXX2t5blLsP9g6lTWGo56m4hYOssuxAyCd8wP2o/pUqL26vHDViXOSyUSEFR0x0Gypr6AQ4PL3+dCMIXBJ+kT2t6ZBBKc12CZAh9E1tgl7XSpY30kQZ8aToeyATuMgdDTUTbog+y1Qkq9mIMOw1Tc0Dqj6wQKvzghTnKNGxCYm9dsoGx1Kdv1sSg6ZqDwhsFQhhLBu0YosvGtyJr1f9WnDXWkGHh0UKLz0loAmKWLMbcLWdluAbiz4Of7ElOKYy9a/JMFIxbeZU0MhIbaOY5r/zf8xztpGhdWVu2ied/ycvi84q+V78kn7l0NudWsnOKtklBX2jx3Tja6JhBjVFAAbVVOoeEoLohI2iQQRz1UHZWPIutKi8dEsOeqIcmtp3P63CuZYPZppZ08hdmMTWIFgA=
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