ZYWuqweaDGyctbmcXQ7RkFel9hJkHy6DPIErUUbpaYzIVZyX0877zY5T6DdwktkEjbnLFTbly4uzVy4Z2S+mW159t3Sqv9bgEex5Fi5S41Yuqh0kHx4zv1USjJH3OsJCrd1FjFwSRlTM1jFxnEGZHLD7I9hX/xNduKX3NzPIIbGyxCTyJKRtTLV33JkRiRnFApYQolCR0pyX56shjFVeREdUG7SJ24gaAu81oYVu3RAeTptvVI8sqK8nrDhGJSzibn5qJtqyNeXGM1baHY7xbhDugrwz9uU6xGEBaI1kdcDhCG6M2oaPsCsUcoqDsHEaygVUDlFe/lXWAYS2dL9jotQk9MCf1mvv+rwPuysT7xAvHYldDSEh2X7TKyYMgZMmzFJRDKGyZ8wOQFNZN91981feKmoB3WaKgD+h6aA2xVLqN4pZmAmNR23btefLOoA2naS3o5oUXYDHSSkFReiv1jtQ9h2nr9xbhWp8diGkkWJM6diZIoTHCGBrXx7VOI1c9A/+5ejiYUEgcP9C8t85Rxs4HOuu9fJ/R2wsKGuRvsJWTouHJ9ToEOl9SSRKMLcCYxNZhnxenltYXvMDI7Hn+oC3VsMcytZLPdOBWDvz9N4o8DEsWozYibTA8vucF6qW36laP2ZXmqCmF5JieHXDZpg2bVAMWbJsDI95xiL6qQBM6NLs9RHiFIrQ8fZ1/araf75l0H9yjwSWS2QdR+ivBcBGpW5aUZkTCWSR0/F2gM2eWgNiwOV6LXwXf07zHMeeSN7XoF2fu8qYqxdyjvAgN8QfIyPkghx8uSvedlIQ/7vyPh+I0wHxTtsQlulwVLUBeU6vIsOYtSbYHsQogoeyhPSq6Jyzokn0H4cruukAAMVg07z4TfKAyxihIBNyByN5kJOVdVCoQZ6qlABUWJpueFarOuq2liR3LH6cUEfMSXNICDTw3CuvsyU08VTCw8BAV+GW4JqpbFPEauGcMDPUS+7PNHx7VHwJAU8S7bt7OF3TddkQLxBCwjcYQ1U/glnlaOYQTVLnFjfGsLYv5JFJI9g4vs1pirDuHB4Ju58MDvY/0OvTwNJG180T0mal8sQMqJcYZWRGz7oN7cwXxQGA4O6cQg1a1ZqyFyzJ5s6KBQQfBynrFy/0g0GzP8sbE5cDUHX6PlA7wBe20d0ivF/CTVbBNT2iauXVHnT7Xzoz2qT1BhLoaykN9xJYQ2DCnvdmqI96RI/HKcQ4SiKOkIt4s0afDn+x5cc7V6riWBcomv3/kYzuceAtKX5VyudUMrjiCrSVG9Aqzptq2p7ZD1SPWCgbwOwXLBf7HbybFiJ/2b8tWbYB1And+uED9iJ+nMs4jkKUpWXkRx81Jy42Ag8E2FpER0BgOR8TUIrJqMM=
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