i7kKRuach+f7AWr+Izw/VdWRjae1MNEwFn/D9A21j7MOq/G/93yA68LPGiRIf6P5jBtREqDNd8R+V5qnJuIsyAdVskC71lJEikgOT/iGnpdLJIv1H1NtMdBNLCaKfOl9pQo4oxSzZuPy6IVQwksktvy+Er47YWceVYVx9xXPdwPvLDZYDq0KUsvmZnFiHGnZnt+vYQZQDSa/rInwgkAGjFs/THcaPme1JG1xto2Bps3aMRs/kX9l98xfhq/EkRHD5SD68DnEonWzYd16C1Rr+lzVF8bT6khCKc4Nssh+7/9iKF+GbkMlaPPiyurEHFUTOM8A4lcSfDkhsRfOT7ItXpu17clmW3+bYo+BXXIIFbty0SlWNiazRflc8QnE0xluhEBf1EyRx8GWoYcVKYdmPmRjAC5Qa6S1omBhwUeo7jEwb+cS/ap8cqSn4ZWdjAh5a4Qs5rpY7GkVK8lNiaU76XgKp/6j6pF0FKkszW4v/leBbLL9LqxGHLsYNJqEJZvY3hj0ISPx1ClLbbVENNVeeYHhQy/T9yedBQt3KCcoS13xtGVm0pq29OTPUh3+ppZavcgm+xjG0Wk6q1KuYeu+blFnWjkkAbDl2J7WGL9vVZuZNPAA/7NhlW94BHejN5ghJUNO9ek6FT0R8XP566kIud3zJM9b9sRXDLa4emcIBZiqlG9IiZk3Z6HoasFS3HTkUQHy+e8yroXrn/+7FMBjY31vmPBgaDaV19AlSbkTyxJo+Kh0+akQyJ4oSrdNyGKK4wdTdTl0gntI3yg04BN+o7H7zRHs68GtL79RPalzKmR2GiyZKWe7WItf36pwTwbDV8YNmYTLi+tZBZnGw0+U2BsmxVYMfrz5IScPF6a2+rIMU5vanJ3kvskmThzfBWKdPjJEEgotpLotT23wLGsWYSb1OUZHAFVIGuv32HLaRIDjPbXd9yklOqRDOjZGiJwiDiUvKMoIOcI+zGqKwnSDBtPv8WMQr5BA+u6hf6uchMenNz2Zgt0+6k4J0R4KmgJU0nVuytsoe+P200ORMCrx+GAPEtJpMVeRDubwbQlROipXv9gVSrW2xgMrtJ1kbyHDzP0QV5FEsQ9DOEKmFDpy4HyG5fi/LlEJ0O8PxRUQImLwE6h3Fgk/Ql93jDTwFiCfaxIVyunQyNjrz14QQWbpIXiK0OXs3rHN9Dgyc4LfPI065GZcvg/qZTXSzjQ41E+r+ZULXSLJUMv1KojFdjS/8DuJc8wEbSLmeWj95Y7Tqvvi+bXORSAuvQTUCpEvyDfnLZ2wkd9DfZBw3lR6R+YkU+0Z1l+3tIvfypXjmlk7Ytm4hzFcLko9LHCesHlaEMouYmORmNPu9mOCV8gZXCxuuAVTx+WSGwxr+eTj5Ac=
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