VcMqSk99Cv726irE996ZUG6AprI0OhzA3vPtJ7pyYP3ysXPi4FW5NffAKrK7tmC2qiBGL1LZO2TmhDjPrh4+E6GXNOuzVV1C5IEej70mK/GibjnjH9DWVb6O38lb5Rq1ShLSJetqTRWwzq6So82726yhgPx1OsXL0i1BwhAMZOTw6YKdS4BPKp79vKO034WOBpZHvpVeSP69lEp+3KTp0VxZ94CMrLiGQeSYPkcow4OaJ/fwioNE3OQVSW8Enxrq9L14tETxr/i8yTmtIyeSp1cCloEWm2N5iSB12gYudi6GWTYFjeU2NRHjC2fo9ZCIKAP2t7Kx2ejDhWSLEBfL8XZZrtM88RyUWR3YUt0jGePNbKDNgAw3ourqSORcY9NiXJGiPd13WA1ancmYzu5dJhsvQH2V1seLwpyZnHKxHTWGF+WmqlBzPTI+fVYWc2KVwni7yH+xRtP72/M9ZAGWISDJADFPXG8ctrmbnAQn/9GYjMRklK3uW4k2R7O8eq/DJajpbwHqAQ2R3e+LKnFCCRgZguJGN1fcQu3N0fiyqLzJ3Og+uL5D7Sq/RJmr8q8wDgyTUEflh7OqT8UN/AjOMPm0XTyZ7N0q19Bl6iD5qmx/8hesFHhNmoTuAYsXvjhjX8CVwaHBXBIoeMBDwflcqJReboeMALzlYwXRn6UTJHCwLvidoLJDbqeRtKOkkZg7On35IudqhMEok4oqfaTjh6j2FOv84oLQ6yj0a9d0bfut1gpvwpd4/wPPaawVBJsBKSZ8Cym5m86+o2kCLp3Thbe8iFQt7nGdfaF1u/fEyWv2tHKj3QNXLdOqemhAi4cKchRWT0KHqm83At0jypw1ckh4XZURuIx6xX96L8GFN3kR72jVrTdk12ghYlMgH9kEBUFIh08brkOj++Nbp+W/ZcZx9jOga47NgsVrmLcEYC3dL3eA8FUkm47xe19Ze7y01ILmPbAivX1AI1aI1liGXCBcjIFJ/4AAMydzH78QES+8AZUIT08NWdAelyHGlRBSNDJIT/qVaF/FL3DRDuBnRdnbX+/6rlAF+ML23aRu2IGE6h5sBovjZEmjzF55/qmWMSru2Jh+kp3Co4Uqg2sWAvx00rYvkHCpnvaJw5ecjMx3MeFOsLYd83TDnCERdST19IEowR6z3VUD1s+V2UI6azDeuvpQXH3n7lDT/HrNHmcsrlVGIZjIGzqLpsB0rEKwt6fQYYJPX/mzYWg4NX9H6bybXuggVGWVMKa+ky/L0w5jY3+2cMcYtLvruYhJRvdVFr/DN1eXqYdpAS4B702o4XQQvg6sclCWcSAZJLkTgyFGh5AVAOudIvnr8wo57cLWCbaB1s3sZV5Q09HoApd1WDqY5N1WsQPdJ0brxww=
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