NYvDagmqPaY4po0K8f/1mzHzUJTyGNFM3FylK7+AsSsc5Fmcpk9pqdj7uF9o0CRW/+2dygh1YMn/bC4F5DIB3phsMi7o/2tIRucPwyQNLABml/Sls8Ph0JlOyvQxKuZDnUe3JsJKojDCMvQ2GCOhaRahPgbdExLUE+jj5HRHFxcXyJPrAKkGAumH2Jc99TPCRXQFYlxsWIl58WQ3sxuCvcJEZwojBzH9/MIS7DyENBHdCuWe44Id2ns2g4gi5prkHT0OUQtg7PZw3try6DaO46EHDNMe+37MrLUSS6KAV+jxCSaiwdTb0fqV0jdFb0FRuiUAMto5wuEu9VexYWyysd/bneiqiBLzLvQQHmUfQhg3NZQ+34sSH7gv/EiQoFZo/CKu8wjE4db6s0rTwt86RBhbVRUGpTZVoSe8Era9pygCHtBToTC6J8hbrm6AR5qwVkxIriQTPhq14LwLaMBZZGid4p+x3NY0K+3VbUDVMTMdpozP6Mbj/aeus9sPkavL+CM8W3Qg9ZJXHxLQYptpfMYexq3ETiWMzg3dfs5uJlpmp/NfnxXiMTPywxcjOBNVLwFeQSAvTLfUPFU9VK8GpRICScLLQLT2OKO/1PdYlMyA0QZackkyKUyTLrdXi+kR4JcLGoOQDVFt+xabLlpH4Lp7IHSaeNevYrodQnej6Zl7V44pahyz5DtaEymjg5hYK0BrkVKf5Zxav/g/Fc5iDjOj2uH27lctm7i6iq92t6mj95olKBNzpkGqRXSmFDQEQEfAJCMBEwLrNrE8V82IgpIMKtDDDdCz4l6SRo8RRt3PXM1b5/Ij84AVF23rKc9xJnrEoTEjsFbRNCiQIo5qqbpn/0tyAnHrHlvrTrUIf4fVk+fMyPAEj649l4EcHfnYB7vPs4LAJ0FnfL48LrNyJZGMhU51DC7wjsVkOi7vs3So7tjKTQkMk9y9Z7oNaSU/Q9AqMB3FvfhGfH7FQVdETnxfPv4B2fDnFxHFPnom0s67PGUZafhMhldavEb0Iz3J+Mk+/uBfDy/paZJ2jaxDwsAdY8rCrSua/lzRGXYWQBQiNYUR4N6P5sN3KAlScLY3dF+ytxeoC9nLhBdk6LBpq4YAevQQm/NsHjZ+ZnOkcKYhsDueWHCdnzcNLUhmoDc/jg6Vco/DPRcpNZGCWWNN6CqzSNPU3YRJ04ELHixm6u532/JU/8gXwE3Qo7RytBKNyXBP+gPV2eHjJntFcJY7Q9ZtW5c0BpwzEP/nnbEqFG6Oi49iucGn+MnCUDykXdWSRq+TEAYTsb6xCTuaXuNiYTzT51AIzLI/Hsrc5P9fdgn2u1yedzXlKMwNHwC+PyqjRzQ3iRzuIQvGgKQnih+sqz5+Tp21LBGlBIOEtfs=
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