OHJ00X1aqs13uNSr9Z9KArKzDIGJvKaWVZzCaOUAl7gVXFI2jiAbX3iOYfuzBhBLhpVQKja7m+DeThHVx4P/kMLAHg7wio7Ag75xbJGsaJCSo6UgE68ZeHEu/nNvnr1c3L3FMsmn5+ukRNxmdXgynRQKs2PSJeWejOYB2ufogtn9Y7buHc8mU9flq9UnDSlcggZo9fpdZsp98ztwO5J5nWVJiyDrLMBajAYYid8g5kEhYrYdLvJDIRcEfBScRxQlcvvz34XbzCbsIz3uI1tO2UmWBssToEhe6LlWCMVW3JPkKAcpkvtmuLxD9+Eka/AOAOFeO8Hhgei9K6xtVFnR8Vfs1VlIKZGos4xGleSjgBe+bxyfpwOUIXJiVYRx8oFXKW1jheY/cf7esK56X2Meh6Pb8/lrvHvQmqyHLGICD6AXfr0FwtCSzkQAJtdE+yEIGSmica/czWDwOWkzl6EkIwS0a8YDzmcXWLSSoFNY92+YRSGZWAX0ZhwYgBsXGFeBGYGZiqdOLBVOi9uUWK1jR6hMYpQD7ikevQjQnbD+1Dygia71P0CUVo2z8z1vQp9Je71dMoP3U20vmq+E4lML0FdTFKicWBVFECwVrkj/FzhZLEjmWY184kfMstrXfXI3kQYW9z07m7Yoc7ifJkB82HqiZPhChg+wT27+S368bNALciR/fZV8Xd4QUjiS4/QVp07YPPCEKvf628PZDV9YzjT1rMHwyvQ340tsTHr2oJQxnRxVJygJIP+uni+qjFuqIqHcn9IlcwLfsH5LZLMoxuaeruWppMIpOvxsSDkzgEochq0yL80qeP02yRCMwqGpeTidr7VE7i0rq3uU8nSRkIYGFS/1kv0s20cnXmMoFZOBK2VZkywJKExzXp4S7E/cI23vw8PzjrCsRcSz0gHkp9ZVDEuCAv8HSWZRBeMP3M9ooBC8RuqAjRKTsiOO0D2CmeGuM9ZLH4L3DpshQBpfDJWgEX2s3wKe+Y5bOtfMcUQJUOfiiXkqhGHu/x2pGFI5sKzmGpfSnh6yFE6YRGp1sooNObYIi5iOKfYvVH3Xe1/CeweRqZq/bA9XgU55X10x4aHOPTgpqXcFMWs4eRDvq77MVK60NnC3dpRDrd+PPwJMH0d+iH0awvW1hUw8hHtZY1opRwleeG8bmTzNE8N22ak6DAzNVhT9m4YnN+S86bavv2GScmvHb8SHS4BHk0gWJbEzv3xx50aqdl8V2KzOCnjWEAOpnXSCUJ17iRPKzFt7Aij0YaVWd3O1nyEOad82Ya5pbr66dLcWvag4QNsEgfAT3V4+D64agD/JNAL5uX3sAorWjsZ/Lqt8X0jVfFL48+11HlYPYbjM9yGNttoc6litbGB1/tdIW5Y37E8=
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