FGbfYicZ6odkSE+/AwikBIx/Ptv9CUkVt3vqDu+VTJ8vgC4aVHRg93s/S9T/hULQpIXi35zmt7dpXpytmseJf8N7i9M+mGCvXZ7FI0/zKKRiRgbtdaRpn9jDsEjAUCNqvFSsTzuObOjB4JwLy2275CDbPPxkx4Zr9/4O5Nll9abCvhr8YvqchulKFAJafe5RN2LKtqDOW+m+yD9Ygda4TS0tqDiroIj8woZpRCVixRPkJ8VITT/ON33G8L/YlIZzxmuNBJWJymiILc4kbODUt1HjRKjNNXgcvzpWT3oxB7UjF0J1ySbw4PQBMjb7wiDtiwBNMhmxCxMoFMMG4pWoaFSkQke36JSK9YsWUXbf0eM4mZmKp6DXCqjPbS+/fTSLVB0pRC33MAMa8HqeFudDcz6N2xD8Rvpm0l3J0eJuDsnzU6IxSOAwhj/k34l5YvCZi3zeJyeNUdJd1QlxGATpqbng6ePBNhl1TPF4m4Wr/6fhm9eatTGdASPNyYmFmGV5Lon/GhDHNDZdTUifGtb0RRRM0p28LD/zlpwqn7PUuseYZLSwyEcNfnnuNkPTYIQbYnsLFTDrOlww7xPipvQHcD72wOCc17cO0v7NRxE/ieYIb/99QZMmLc6SFOsG3ZIGlJAx4TyIUQKuuhDecuLaQHP9ytlAN44ZdEzzgmXZE06D23lsqHtKVyoJ3FuuUhiRGlxr52eGDQPJCV/zHYZf3KjszDTYAb+7p16hTw7T9VArz/y1xNIB3zN+ft845TtMigJbgiqOYIN9AVlqwks8qS1bKWCXBOpoxHWKHOjAWNYEUBIGKYS2Onycv/046MFWsp9t/u4bR8CNlq9QkJR5adnRvF6eI3A1XklS4uLs/qUZAMydrRJ1Sh/hjmPNB4ryWh1kb0tlXXvaEFAjmoJV/i1R3pDKQadPX+7ryrhWTzYNMRxg1qLUA4otrgZLTbd84UGpbnkP6MJ3INNAoyGxXjUAY7AETJhQ9di87rLp3+hbRQn5jJks2IybdC+ifEvACBPHuKq6HNRkUE+9Iu/VwaZeks6aXkhLs9uFWW3mx6modlBvVzSJA0nnQCBoqE5TVSYpBSh0+QsriAci3OS2vKKbvYfCVUIfbrDFtvgsXq1rMmGoBJSvKsTh5bWVOcnE04Tpnmd/TUR4gAEYAC5mrOfsMjKIF5p6LRgyYNPqbS8M1LzssWRV9jaPfF2udz6yGnz1EOtMwNJ7JAkT1u4r5fvMB0x4gMrHG/NWabE7Uva4Yf+XRGYqntUaN3vU+NSkCRQ2xa9uWLeOJIokKAxZ9AfSGc1HKj1PuNyYJ4knO3DHopNVv9hdBdHkDCx5kpdOdbgL/gaxQYRoW9Z7Msc4ctQlp3ut4N8SNTF6w7M=
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