3SvNaevnesQLJVIsPSgDnmyvuMCtK48DD5gjug95UfO7/wEyLBWGzjpzNaSyO21CBzhrv5E/YiCSpUbZ2AZsfT9waAcrVTBCzkfjeBZY2oWB8xD4iWN3/i3nvZSpVupxe/cQB3SWh6Fw1kjurBPMa47176Az7iPiMVOFSzzYAJvR/8MtoMwrCXbxh6LckAmaOrRaDHDOHGLHTDnCAAjYHC+QFCEXvsr7ga62krb85cRST4NQ5AbFe5pnbCVzukOv9VoDlwZ0Fh3ennk/v26Au9DYnIggPmKMFODJGL73icPfVyFIYJglYCDFIDk0YNjsBJjT/Cy5ZRtRimEn/o/acQNtS8mb0gtM3yqCy8PFIceWvInQXl9ILHJyDePgBohLzBXzNKudljxxv8No16k0a3mOGT1FcVkAg5CSjyZtR1QzbjCbADNFwvBQHiic0wQ0+lUxeLrrywOnSbgcBEX29oN1v/X79n2Eu9UiPdTLOf2BzvVZUxucpQ9pbphObPuMdTOvvJvILKZiYqBZES3bxTfmIV7o1bwYB0AOzJNHD+Svf87JcomDPa8QwrbEQaP5J9My3aNEv8EwUbtfAl6wE6YUl4i4rFN2H6Q5u3Em39PXRjTmsTQrNzEtLTd5MABSWAJW6v5bbuPDjo3y9h1TWrgVLt5lqyhraDRq1wo6sLsi1v8WRR8G393ijXkntsBPtSMoPiRNsFXP4dvqFOn80QiwdOY6OpJd37rRx7gwpXnl+hNsat+CoGVIgrOkyjK6sB5BgcdW7/LU+ckbeRk+fSpV56jLZl4cwQ/mny5Tw/MJ4/NU6fJa0ICChD5taJ7B6YscCt70seVqfqR/ERkZB32zjDXQhQiSzyOyuIDEUVRDG+Ku+DHTcaP/bmYyZvb2Ylp4LZnx2yaVLQ1+0o6rdBzR7PszCAc+mAO1NrJsXzgUt26kRPDDW124Ygp641gzXvxw1WEnWQZcyp80fqG+yJmzKxwvUSGsJqEaw7qtw/SV95Wekd2mJ1NxTQL68aWhnPgThzfQuPrx3TabR4XU2NpJFAtwECVEzkkCZslb9qSK7sTQUVHkT4Cs6wsaMRMoexje4SiMKm0VQXCEjMo9M+LpducXGGU9QTNh0d7lS3wsj7VSuhYcMTK+OJq6F2Y1VR7USgpL2AK2lTyFRA4XhEXF4LuC5jd2L/FkzCJ/D9GEGNHPBUzeEtbLQGhcce0ud9H0RYFxNyPFb0kx2UIlSIZeyJeWz2uFk+lea8twZniLqFUuNkfQc0WGiB5a2ruGuk3yagVQm3s5Y3no1hhdzXxbaOvW0i4ZDn7d0nII4+Cks/+/Gn4oqF1tAsu6OOB0Lv3wKp7P8KWczykQ2zoNsDgrKZycsksFZkY1Ze0=
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