YGmVjsUr+OeFugeMNgSlqCqK0LgsZLgSx1yz667SSY1LyzzfahEiJnpCLDnUnnnCVe5zN6utjahDaH/ciY4ytHXDjtsVhRJXrbcFJ/Ez1HZqYCnm7v/bHKOOHwMqe3T1Gd2gluKE+af9yBB/j0GLGWECYQ/pUtn8fiZFIC3wwl4WoVFcpp4zvGz8r7QZy+hXTYcnaxGcwAkPNLxft3B7XnPe/b8tZfsLsz5Tp6fefS8XzmHQSj2aDAWgCZ+CvbDK5u3TkVC0BzLtMbTLA1N4xd2RaLURMfgegcHyRY4DTrh27vPwS2nm4SDbLWJm6xh4qyashsY7JDEAHslbs4LNGMhsJc3IDWz/VyeKJYyhCp9m+a/0Z4RaMaGACQUTEnOX/XGmjPOQONKZmarxNtN3ZXTEbv3WEODq5XMfrSLWnlkeePJYDTixNXbPIDcYUyTPjxbn9NlOv2nbnU2+QqzXzhrlGaPvXfgY9yzDkOk7gGTd4ePeYFOlP7e/pdfPVaQvj3DnJz77Xpgbhjzn+Ub68HKWLSIxsHtAHsFfWFNII7q5Go3xywyHW5sYg5ZFBVaIIcmrOYePjdtkWbbj/y4OO4s5vr9oS8FpMtNMCfTCTxHl70i1JDjX7oWdLLNUdYsxcEphSlHdI6PYoud/iIABicBzL9+3hehfZI3PFZsjGSXq367iiGo3EJs0UIuwpPKwStkWZR4V7mme7bt0lM15jF0RWljByScwFHKC/yQGc7VfXl9G68FLQrkO/sImpglVZmzeEaC1sdU6vGav9M5uZZ+T215zUX4US2xfhGS3qo0JAriEzj3yFWwYCSCnW3Zve0mikN5Ncu+L79LTqI3o5z1DnS5KAqctU4MzUwqwvZAtWKObu3vM9r+im8m00CtPjYNihhZ0rOlxCyb8XSeWU3wqg51lZ7Modc6XkzzUDR3LJdN4uPlVaZHB0yO7NJAA6Mwx5lLvIe54xnfu+/Yfyd99kPyDkLOUzM1pYR8TII99ua9ObHyiUQeUUJqJBRwPh5/8YsjZPap/87zxR8iv2eJ8RyGpRN/CTZRD0R2rRJraM0qYy/C3148nAVGNG1aYedQNClutaPy29GXSFidA199gDoRiP9Sfn8aow0Vd56rf9Ci9nor6wJkS45wKbFCAIOKaE6lSW5K3V+figgP+A9Ozb3ynBVteCX6+cYi1ck2YfhboNKFpw/itsfhf5y5X5gFjKDDn8UrYggf/MqodGs8JHvpZ4RB9v3BiTRRqtFaxVy0vgsaWBdY90bn7MI8Ih0O46KloB3Vw9mk6iMLczYX38xYnSxqJ6i+MawYFGJDlWPubIQyjC/4smxzH1jYYkZLWwM4YNl17lFmk+CEdRStXWNX8vMzefwNmICk=
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