lfWS9yWbBWazF7SIpRi27KQveXUTze8qGo0YSRasGO1f2+75GOnLfHfEvw9+o+/+/hEAzXB8AvVlMKFM9MKWdgNFvWUEoztCjLREHyMDyUSf2Yyz0d97Ocfqe8zrdbi/p/rsZBoqOMVLDJq600p6c5ZHDYQFcxsuYvIHcLFpQ1zvgdIOuJrtukRNns3e+7Uwsh7FarNwh3ZqBPmIvOuS/GbBIIWzrwWI7+nOFgn7YgGJFOcpRWYSaC99PRSK5BsqnBAiAcAWYHk/quahK6x3mJjTU7LbnFReMm7aE0rs963cgUMmhKbtEmPIMIdBau6uKw4lq5VFn0JvvXPESscpPJ0bwGgxmG/2CiL9ijUeHggVV3tcHSXeZXL0FALbFiThVl4fzMEKDif8mmW/mF4Urpu8yA501Dav0Qc47zOqqHEf9YoFGD5GVZ1KKAfq1ctVciJCZr8uCOAU1x5995DuvMUq2qN9ts2fZPSbiFqbUgXJe2OrRe7hgTv5CbRKeWOspfQGhMVSSSs1UA1rNpZNiefg7CWaDv+yn8da0p0qIRaJShMMje6/AL5l1QbQeyQ74tCwVBU6NNexM9wMbmLWZqfkzPdA/YJirKcRBL3u454TKtoXuC5krNz2pJWCOGtyOt+M1rh+BaAuowj2jfOM1cpkrMQQ2/KO6ZxUUE9nIXX453Ji+jKQjZZOshcPO/GzmPYkQ5LysiSWsV11XAnC/ey/RACjSZYFvLH6cJeXd19V8MUT7VUgl0WC9OehUWJdp0vr9xbc2iGPTXqI7KasC3Ol++Vv+DvVCPoAs7P+N2YBsy7TBgzbVMkFG1QXxpkBEKzbErc3aZcs/USWIUz7xWWq6lBdlLrhnjyO5rMpHP+99mM9gYrrqaXkkdImB7j1+oBtHymRHwe3TYgA7ME80IEyMw1wDnBg29XkRIimJ451T4hw0F3hD/dzpDcy4MVUDQ8p3pvXvHm4TpX+6qaE/U4H5iNeVTjtQTpYpSNYjvSZV4JV/I1I0A6nYVHgrM4s9tzDCyK+khUnffRS79d1vpn9lgU3Ppf6Rsq0IbGOL4HbhCo023kviUpa0yEYTrRkdDh5zjZMTKdmDgCCzAyl+mMIGT+QouVPzKaXEQNN6xoM8P4kL2Cm5ueO7qdNp+MP9gXysbcVhF6DqKtCKLF+qSXXBmG3Ig1vaPpmZxAV7GsgEcb0mjJe6IyhR5ns/mewAOKOz2WaCkRm1mZJSoN2IX17pH9zji0G81czCD7HVirG76SWWyLZ0o2CvCP+8nxnNciRY1dwsUFjYzN0xCiCKWj72fAJbPmEPuaVhJKeggRa+4DpiQsjkzl0Ba39S+PS7ac1gouyxHmj20OrqdZZqtZm9wfX4sqN6Xni7kI=
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