mftC69zEqJ0rGxLXj8zFG+GWGrgjSn5Vcact0xEtbgwQMQj7atOrP6pB8Tu+fZDBRqh/IUxWT9z0Bzvdy9zRJWWSoczALsCUFRsZtGZMgs6PtkBaX6Pt7sdutQHunpYpPfYy37itvESHt5GO4DXh/8DNpMsSFUKPolsOq9gVTZdBMJzbatIS0qLsmjjDgDviMSa9OD39BeS4m5Ji6vWwp4aGS12pul4kwea6wit0CCICZRJpvbr4JrPNaK7R2luIW99S/e1P83ZWkO1jxsyBshFKvJj9Py8/KZ1TeywhUgvlqS1nfHyxYzE3iBH+D5ZzO5xG/IeRmINZvYHGNqWwWoRlh7UNj9+kI7qc0YkHmpz02qrSOZDgrspQlXffTIoirLqY+tTBosrqu+q2gE+WNi9QDyNogP1Cm975Hwah5QruKpvVddzkY3G2k3BWIcYMWtbI5CBia+h342/5B3Qf/NhSMzhdR/eR9r4pO3OgZyC5XYwZn7qJ6fMUN7sehfYCB/OBCUwvbaxC0LlUH0y1sJqNWbKiLjq7Mj18v/8pkI74V9ClxHh7VLnEm9Iun3qpNb0ErdJkvlwkGfDdG77BAMd0juRZ3/ZMyevSkhuj4TBG+oCl/eKk35/suzmfE8ukXmyClxJzWcNJ1QcoYdwxXyBtA1pM8aJi3mk9LJdCYGdeGurQgYvf4L1wDTFAwS4XzeUV5fbepKdRqn3fX7RTDQ95YiVJ4MOVobFseVpNfXEt/ilbvrlEgNKDfeaCo4QpAPGbLW5HVkD3Vf2OS37V3f5bj7f08I2Ef/IShzsqqqRUJ3CAed2VFzR6Hz7dqfDIOa9/rT1zdVh5ntvqSRG759yxQDjJi+C9aMM3Qu137ug7AJI1SEgcIDqpRtYR04I+OCdHf/lF80n88PQzeOcG/Ugjl7qlatIDB63mQ12True9c1SpqXJoG6VTsY1VHSDLVuP8SxPvcmA7LT7HNdbGLtac9wb+cATSHTMoVjr7xOHSFm6TnVo84SsOcKhm4U4Wi9Ibs5X85L8mqtTeDHlTej/62GlXphhdrjY5mRu8oldteypmJyqKZvgqCN1+L3Tl7Fy4Gr9/20DSf1Aqq8WDfJ4ky2Yi0JgVw3/PXnueUWT2LiBiwVCpDJUKQ9K+tukRurbjP4L/E8hZFON/WzODIAb1ZWujRhh+tberKWDnQudjLWJDRxusXQaBDXn0LUURxzSQuqPU1eQkszwMdbdUBIu1ZeEOAM3r4OxdAiksb8DIfQ3K9Tagu6hma8RlLmWQnNwQCH81S9JjGVFqhYA6P/QmUc0gZ0yaoLflWOh6g0R4pCtNeT0l1B1sbAfhbQA1lanI22uee5P+IxfpmHQhoH1oYlI/owZd/gotkCc=
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