EGpDjCHF/yxGh87tZbWeFniksDwrM0sW6VEkNBa6qSS7wIp5DpaGBuVz70sszihTCZcw1tZZsr6NIAD6h55wHpcqWoc3VUipL1jExsK/hWwJ5cyNH7cQR1DKtHdp1rSNrHWpMaQ7XkMp7d5UBMTn+5vknNGHa28HqpVJP8xvxZqHUJoJIndpY1KHzG+mak3z+wWBZw76u+u/fEHhcgEkJ9fJExP1uHE4k0az0Nfc1eVifNgeYd4hNoa131ugvwU0dGQJ05ZONuQz18lLi782QTeXRkdspjLg3K3fdWI327ZixKoSQeJIWmScTXB7aOfSyw47XU9TP1JEecTiiy6gtUlbiLBFHfYTF1x0ycrXR5gWHlpmv503gM7zpT82BuuDHNKcCLLFXrxlgOjFFnpqZO0Sy7qs5eiHQoYuQr2s4cnJ1png1rv5zdfJqUjhZ6A83WwOb2p4O3tcwbtR9a7axroGhHu8eyq0USeWT+j35iepwV6iZJf0GWVC0ic6M9oDTYGQMU/aEYWJp+FnZYiRcWFxRmc54ASmTGa36wV/Oyw9fNmf5m/690HgqTqoGzeRPaYQddPC/KWZSBzib12QebTSL9bsWMYuVX+HVRWfzljhFz0JpIBHPiqSaa4cI4m7RE2bLZP4Vw0bscKXc14CfD1zTmTl544aRG2W+f5xHPl0huoa5zojxQipxrvJh2A2vE9ubaO4u6PZEVc4EFWTIMHQ33nJciSMFlpU9j51tx2cmILi5xc16+1hFdxr/7TTX9NjSmbCcTpI1Ch2EH9/rHMO3UZLZR2eaOHdioAc7OZiFFMjML7CgyIotBR1YEtalQ7bcJQdjnrSU7CY/FA1qushzYlFV5Nat9dEDKo7+xspSSNkll/SxRQqgwkmXZS1l8eHB5Xyhq3IerXvkqxJ9enjW95OpgNjZ1fnjyFzri+FgeP/YU9daAjm+7QhbW2bmO9tcLvMPXcXiQA14AOMrbrEhBNd09Y3WKgphuTvsURjydoK5VUsOh2sXnwnqGnDDhM/cRuCCHSALAVnXmKfTJpi5GjnN2mMmRPkFybZdszrQp3rJ5l7TgD2viObGsLVAA+puzBPEHH6x9zC2YDVhK1OagGZUVnfuRbEBsSms/b0g4JolvcBEHVxz57v2U6AL1vjDIui/wtV4EeoSSHM56pURdqRB0UtlEnv+AyB6OerVLoPXpBbfcJ948ZS5pQx/zfA7dayRfVXIMCyQGvU6l/iukGHjuOPep1GJUNf6r1kYB0/T+jHtBe5yq76H5gTS8n+CsGP4vwTVXS54/lQ5a8zU7wd/bKU5UuVhYPfnndSFTksbHb1qJa8oWNEJrD3lIaXfakNSA4aMt0H0tH9wP7ug/l9/FFMSIkCpGY=
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