O69CZ+wamLtop4DHrKEWGKRkjOMDxdb4Kn8/mfi+Lh3626pHa5c7ttXpPxwbw/M+B0zw0qy4UYnUMaAXnP40xIbnX2EAXQn9cTRYPJ8YMmKGr+Dg9YIYl77BqNEG73vEEcPguw6jaXRbTwGg0jxug5iwAZiaCOC3Jzvkou9rUP+HnRTndnEe1TDfFF8C2pZ8mpVAkx7Itc4TTicDn73gTKyHpM/gs11hSH7HD9WTv6FVNTv311r2AWDW2gBs6JNj2WFSUEReu7zLG0hiNYuZ4VNgrPbQlfUuPw/BeYGKNbYpcE7TU3Og+uP9HyJEkP1e2+gusgiYDxpnZztpp6TZsUiPdRQLUDbFyS6x3euo0l58amn+YyzYbT2t6eKUiywzUx+3tb+MqURyxvimzERp7hozDd8ZJG7e6QB7n6rmBkqeuyuXxEwA6Rnc+JNBYBotAlQ3Fk9fdhG/hkqNE9k1d0ojD4fvGo902zuAImnA06DsrMpfRSwjAd0HtU73BsH1z0mKMtprmYCKzVdhBtZM4nLiulo2jptLDS6wcO7UKW7UZwfp5iA3mNtxqxxJW2ByafBQv6DHKC57xwjVwZvslv0TTM7w+ZgLUlcSvB3bo9DEvPilGHG1ZQWvPKIVA+y+sqQqAwoASnefv9wkmfDHoxGFdrT9OyOLj1edwexM5A9L9M9v4Jt0OIRcpUgnAHi8WN5oDhz8K1mGGGSQZEAiV98dPvRYNmt1L4XR5DHWQH/JiATJ4qtaAY2Ga5CFKe5x0CikC4OETi9Hs+319F+E+uL9VZ08ivOLawGCmd10NQPdjxiIaZolU6Yz2Bs7Bzh344Cen9+zLoKjJ/FCm6OYZZGi7eFxSPNJThrQd5qTkrlviSoasAx2XrpyNGL8xIOX2kIge7sKuXuqOSvULCZLWrCiYYNPN5akizpA1mTWveafCmBr/bIuLuCjfshEHLZINKp8IDqg4545/5+/IfPDkjFhqhqVtmTMCZ6UnltChBJHKVNDCV8ks7oLKvLHeBBH1GcfRjvFbPM+JJWmwO68QykBVA+g6Cyd0ISoefSoPckLzbODbubqx+cx7zAUU0pDWTKYG02p1BYoDcf4P+LRiCLj5Y7nBH1S6Fah7LPaPDN1WBHl7aeqEjnpEWkoIxqc157Tp8xiSNSKZhHLcWlMFeyL4PXQyjPXLBKtYPtQ8DbLTVN+u2iuaDmOvXQkCUHvJ4b26YWfQk54WTbcTZgph1/7PQ3kFmC/Zdc6e/VpYs7K2wQs2aRbDP1QekTm+l7YalAKImO+yVUKo20nEQwAF5/imLBvKAnsMpPeChv7ZVKcpN9rAiq4b8Qw/VJxW28Mznyeo59h03OXWg6hkF3zFYFm+v02jD7Y/npxLfg=
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