khQaVnaGOLe9d/MfZKSKCCvVbEb1CdtCNj1zX5TBzgNyfYZMgEBH7ipS2DhD7k2sSJ0aO7POa95O8YUEak9pj55AV0qqhyA0c8b5VNSDqXlZF/MDXanBtMGrqcEhsTpQRL1NdY2BoJkhSUjQ2yhoycZGk9qvJCwRBpI7fWqKuCuy7i+g5K4vT110ZlcBJZxzRajhK9rzuv3sjQaJlJOHG9iGv9yW7RW2mHcwSqW5FSx16UVFwGevPFP0XhV9GF8aZ75cn66E5XCoZNSt7av6eBSJJjeFpwqOQiw4zIwabrIJs6XgKBzJVUidaxw2FoOoGAW6aTlW4seWzlrrFA0/9tU8swYUMn3GZCqZIiHm3Ub4CLg2k6AN4JDkVNFqBv40yqmhtpSwjQhImvr68yAI0kTXcSMuwreVWGtRPpacLhA5UAAmvyIUJc2baNHOkj0r8YhhlBnVrssUZ62CH5p8JsTMQJZeGlNZ1Ffk2SEMuEz/vuQBCOpY1OuP5JZYUAWH+qURl0R8tN7sb9vz6RaOpFGm4cTzdF6upE5/gyDZQGeSNo5jy3N9vOy4MguCrG82BzolYj0h35QPWIoK+UUsxcpd7Ot1P98fQyueld78kOhLutxN29JENfNo/ZkDB1Suka6ahguscenBI8wQApXvjc28By8flbFRGG7bPztxvN+KW79lR3VXxSFJhE2LXl51ChraKpQVl+3O8GcuqRI31na++Fd07pN/fLORcMV/iCWrHrTCUkUH0ARP3GAog/JnfSGny9/N2e8BzOCurTjcRV64oF5cI6ho53NPiRl+fjV7gW2FY5+J5pHFDHGn9yEs9xHb9CSjceQdhRAKBal2GLYOKncro9pyzn4KwYQg/MyMga2PZmCqeNi/O7Z8B+pGHJIL/QuCCXbhwVxlNvsGGTFDeW5e4KxnlJmKzRlrF+gNTeSFsvvv+i/btUF3QeKB/yGrD1Hq0Ai+bsTEXmpZsJ/zuGEme98/aUKGevBJT0+DBbe9dqUs3lI6Tk+IiFqSWB7OYmgTJfmVQ5arXspiar5ico9tkOLq+jZ4ydf/StbDyy1QpEFFdXadiDv9Mq/tDuw2boYa14scuQ77gEe+c+U6oanC5Qs83yc3BRWxeYPovnvGpUhoe9Dw9wPJfilCvdRE/qAT0uPOQrOc3RwYViLXPWeF2RkJwOAYhlnWWKoCDziXhdXe1A5GgwZ0xKSUzmTE7W5FqQH5feHNNCp1wzRxHydD3pKw2BYE/vvYtzvIGUCldl4c7pNB/omBC+Y3O3GhDrylnZFGyg9WBjqzmzLAIAc0NvRZhr5zL1BKPXu0rQX24xYqONoAp+HbLUF0EMiliiIsWvXW43Ic3cnPWuDH5N4zPiVZdggkNFo=
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