hxr3fIOlHddkaWQ5rVh9cp6666gwp4Z5PyoqSCpPmVFqJIU/1thNWnSkfknq5V7cxuH5GM+AG22h9Ccs8vLDhhxWeJzGmD4OEjTVqqj5B7QO8/KB71/xHCZGNF2XYB6vPYKbNok0qEDuC4voGlqyA3QrOfLOilFJnhlCU+7pfOMZlZu3AIEW0M66VQ22yv9MdjqJihCS+kWKev3YT+tT3auN/hOCPpMIfegkqBExEGO3m4+kOgJCvlir7bRtVzvrqrRUOv37IvDfxOjizuEUNIj1mWifpOAYhFlxh77VZMf0lw5048FS2AHDVvUVFXCvsts5vH214IPV1z9XHrxZRqXg1XPI6wcViwitMt7YmNni4s6/aitGaB/vM/zuOBvkXWegATTKiI/go/MsAVyHR//lEC6tRJHAeP3c0seVvNo/cjT4+3J5yfOWqJTuo/5tv1OdYRBxSU3LSUVJzlqD2pwRLc9BqFrjhh/3w9maknlzSoqNfj7bmLldTGxUarLA+Rg8EZAUUsCDxTVnEeYT5x0zkLj1i9WLeo/8YNt3L2pNgw9sbXcM6+cDAChNGQdVUO+iy0y/DDz6gqoh0Wzi0DD5HKGdWzJnk1DSatv0DSovq5tHvJTXde/eQ6DUt7elQV2JpAjCD/dDhRxAxbpYMIoPclqdjcLMkXPcU55cDrUg26pDoDxgNayDaxRS5KbAnqXAlHQXcIpKc8EPHpSZ3ogX5bDSys7Gb4Z1SKBUsgmXATu6rJo5xeA8i6cX3AmbrQDfXtbxB8jt3Ed1LHgRRZJXNBAzBlExDm9XfJq5eNEK7HP2Zg6LEixE3VOePf0OrCNzak5smYOA+BuXOaChfNkBL/LNRt7ofADPapVM7vUyMzz94NjoQLJsp+rxJShUs2y076hchHGQKWK7GVUxF02kE4IP+PLBPMRCEEtDqgFtSdMz2uTuA0ja69FAm4MebBdiX6GDTPg2YnvizdBIKtGeA2gQdpY+BUyY6w8mVfGeOhb7ru32YgKEJOPA5qcPLrgLIDEM4gOBSl7OXah4srU6IKxK8Lyd6oX/J68kSXP9Q+hAK5N3zlv0pLiAYbY8hgbSfj4zosNrKAYGezpHocL/Oadb8F5KB0U0lefJt22Fc2uYhXr+8cgA720jFQytwC0Sc9XnkUCoBVmzPWPfkuAUiO5pGiJBLeMhR6D+FRyy8EYQ/nl7QVXJF4X9SKZw6fZ6yxd/6dI8HCOa3jt+Q7xNgeRCU22thLf21i2aXsIOxqJfq9+edLMxBOiJPkXBoOWd4sBxrM7gcwZ3/7cKV9RI73tsZzOm6H927EHbQt9UpP/aWDCUYIBVxMIKPZutX4N/3Sy5AMueH/krtvxNPHNc5VcUnD0iLFA2gx8=
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