YHhlf5TZGLjBNwBRnw57i9z1VHyzZbHQSC8pPMOorhfHauyky3efIpKdaTSPhc2PoxxIqQWGSckwucWpLVheYb9HxfE7Zjj79QmSiE+XtuTwy1Zpx8kMlQM5ZmclMoUR2Z20BXx3gakWtYKaCk2Sy6Em1UXLJze+5MVQK/060+Ipu2B+/uhc7Q4S7mY47CsG52Orar3bHmAPA3TRDlSLDThaeErHvqKyNjbfVzUT1WA1LEXBESqzlDalRwzFVtykFoTiizGyYRkRQqFXf7SBE7erYDIeYIDZ93hM7yJcWXZEW9WJDGPU1IfE1rce8p2Qm4m3v1jWFB5bJ++nPN/4Yd0bG86I5zJn9+wQzfqzZcjJKM5boo8kyznrJwGrIQQD/h5gtCTzeF3iEVef3noE5wbRXgPHqmL+TmuIwSBU9IEFd/0mc9gyEtJq4v/HT7SCRyObn2XLx7/MwfkzZ4CZxV2C5AMAbrGlZd+nB4Oi1crJX7uOrjGjNMm8Oby2FfPaEbigWgGVlrqGAHA2rSbTWCnFksP77HWnctcPrvfBKe2XG0f/LSuzqLbEaeDfWtnsM4EApE97KI7CdXs2xPoBfakrsH7zIPZgOcUqMTyPI+iCu4RBjIyNmOcscsO5DS8ez9BCp2XvYsfj4kEXhWKmA/+w8BNs7SkUuALkQ7VlFgMXv5pbMLirNbe8b7Cs/f/60HjwEtqKKJGk13y9CmAKT89e5cIznUWxFUe1uw55fWnEQ7DWbEln+xUErF0wUintmCDFCaKsY22Kj2q88SWQFVPuMJR8hr/EBvI+Y+2MvtdP297Eph0MTHRiznBtAu8nIjpCQ83CnMyTS9jUgUwP6mW1165g07Wp+2pCzA9bnGVEwgkkNPg4FnDmUFJD4IJ/Tio5QmiP4rgsQT2+6iKfbck+tMVnuvUe2elhnfd6oONJg5v32yACoIYEeGWBRit7vq351K+8dZ+tP3VCr0CxAiz1J6BFoNmp/mTbRiIX9bWsn3NjIrOLSCzkZv9ZWR22i5nG5bMfd9HH39Xq/hMBVVCUXdRLYnTDvsxBg9z3bc4XunUbIIV0aKmdz5KWYlpjQjRQgwsnKZUqSMgn2ygZ86yNZxbKi8mG6j/EXYIRJbxkeB12MEf9I7+Hw1WvjP3yR4pStcrSyBMC5I0SHmGo4d4dKzdCrV6prQhysZh6xVa4t+lQjjdUi2EBSlFnJfRkAUk5oOemq9PPo2rYiqxB4GGz5fOB+k5dNfMNRH4APRO9c508otBuCHr3KfLgHTOu52IWxpjzk2nffbq+8Tv+CIVUAXMrslPC7o8/1QAnhqFdzH5hr+LMnfB8HgvY3W8Gp5LAh7LmwIq3uFrLp3u3OmUmslXc8o9Q16zhor4=
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