1NnAnGRXm4vwQ478enVzJMD6ild+M+pl/7Rwb5o0WcS0hfhRF77vk2XAqHS4cWD+iO38DlZYLMC4ssLZeG+fZtyQ90btwQ9HwiR/iHJMRPOCIxFv/ST6KLpQFxMrEcCUlHLib8tpHaauMJQygT57K59GDQwaUDrPiT0J/JjwWyJWVVNmntpCka8qBD+7u9rwuWJDPvWqFzIQwaalHUpLCA2E667oIEAViCnCnCAkYS2lYPFCuGP5ljR5uXfafRajZiciIx1sUbMM+hBeqlN9gCzPJCKK4wGqVR42iIzzkfjiKcA5byRRlIedQf6zNo1nMDvLfQbQAe4CnVZOoq8WsRl7Xtk88hUdX1q3RuA71xAVy2tYiAyjnkOTwZyv7hdQPFs9rwd0T0wUD1J746bLPOsg+MY8hQfsctt8mHSQKN+R+DdQUmR5iwUCI2Z0x1uoEsIeSpHXeVFlRwqNDiGZdYL/9FclEmbHZ5Apox4M1LUDFe9FRzT5J/EVwG0wgkk41rdXb1BDSOG4RLfI6O6wDi9nf8ucZMNWnHlxwLLQj7er+pd5jwd9IdoGMIeDv32dvDrdjRB0F97RawnYpqvPZQzsCG0ePFKQp55EDtvqs/N31/xlrVAxbNxLbITe85l9jjZVaKKAfMuNb3ylHVK3rVk2/0Mcw8h/g/qVnSMrw9EEvzHjf5RMBV9vPaYdTWu/qan5ZFvE+dMUFWcocVfsr82GsA6ikFxsxHaDkb7S54yzpEdw2p9vNNvyB0zUsVXNb13g9x8OvnmFlxS343zG/2Sk40XL7/7vr/wxGmnLjgV56LEZaKaVTMKz8pOJXsUE2VK8lGSN3SOjxdbsCEssZHBbPHgxMd+aKSMFyn81RBdL6Volejm0jUzQvoU4aiIpDZNaTJIrJFmgFhCwgTLT7OLyj0pNoIwr98xfNc3LuwZooX2Z+UgdFnBZccYCsFUNWsE6Ku95Lr8RwxhREilkHgRmGm4mzwuabfNBtobaBCny146GY0NadOwfm3PIcwu9nSIhYQhlXal9dL72I0onLRtSMf4ntCfOYBRo2q/VT4H3K3JAyDJxFWpIjoeds40DcYvF+x0BoZFoNRFm6VKf1l95fYeMW6HHk/+ij15TBZM572PYxNKC5LbcHfUSI6wEPnRhI5CM8PHEDico601SaUqu6KMDpwa7a9HkW5LNmshwjBNu2R+Vs5XtRycZvqOSCPMXi3xVRfAi3VA0IWFNEUhBh2OOgzy2yrdHcVepurkVm8ZRkouTZyLG2KssQ9wzr/p92eZ5bFWBW1bqEIyVshb2xT95KfZm/qSiBxadnFpk1UmH5L1I3weak/NfPNjR6owkd44pfYj8vaaTxMJbVHwf7256xtRu/ad+pqM=
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