SOzgWjkWLBtTYLSSMXfHIwrh9p0dFAKtqnbi20vAhfgaVy5b2l3UjoM5ndYRi5jHxkpp6ApfvXsiAhlNDRFK9s3n5WRtrIbU65/5azHWP7eqj0A6gFDmHSfkA/sp2X4xGXUncU3RcPDFvFTjsT2xpuzzOZIOiKhBm+U8J7IbMKzuwmbA3oYyyv+S1xTo4/nQ32cTmpDVb2b9Jg7aY2S6cwoQwCxWJWDTjLY9Htp6t4BQGhsvN5J1xUFxaAfYTkC8Vcpdh0xvFegMtgl7DjoZC1ErSyVkP2QTas8EbzC/Rlx5wGhw8u9Rc7qTIEntFV4X+Mq3q1Gz1OtDwWrdWdejhjUJm7sIWBpvqcN/is8L6AN0/FGPl5d6zzfsXWxOEFkTrLodV+8/pgbt704siUrSG9bdbY1RbpRf0QghKycZn/Q/DZ11rf7slopLaDCJM8CDn+oQMZVbb9ES9q0pV3T063xo/QpC+nCYOXMw2wmlTwN5ZYAUIDLpvXqD4Y00EzzX552/EffuUZiXO2mVWDdjvRTe1jkckGKK2Kx+2vwRVYXQAPWMalawOp1TNMhRkU5RSwgT8ZKv9pQ8eN+yxyBjpLgacNH4pRODEiMPJEIQ9JD1EgVbnGcQnF/ycAqWw+VAPhf5iHmy+iOVQGq4silMs/JhQ8wphGUnHVWIFTliP4IMqw2kLKXBlLpzG19yYbDAB9uTYi3supl+21Uhhe+qjUo8NC1uRX/g43brgfLbqDIF0cFupsGVBdCMf99H5fYor9rlkegR7dUq3zh9ZLPiy/BMBiiW3GdIxiDk3q99axdr7q0DJW5SO1rIHmdA3vYorXLUpQMxYdExDqVFqV895PQcW8of0HTwiIq7Mma5+GVWpZtSLXpY7kjI9uuLEhKRGMPAOmLO9EuZRrHfkTwMbuMyldRrpYo/0jvXNrvaqParO7XTy7TtuG1lbAmOsqNcKl6d9QQP1+JBET4+jWwgj/WashG6/46RRsWjddjurH+HvCE8NZD7lVRshykngzao6iGWHko64yZolrtVIEMeYXzBqNyNYYiR7Hp4Tb8eitS6ei/5suZYODSXj6fkCdbfVtdPESLil47ddDf7JPzmiYPloCk0sCfs6FYL4RwGXiXAaroyuuyx7qbXyvfapsGKYA26Yu2ZAwRFCqzKLxa8TZ+SCM2kDMxxhoilBgttbuZeli4UHsU7OOD4DvAE6kU9YgKITPgKVtX5sQvHrhk7sbigxHm7ZVI+8j0msq7pqPrBPoxxDrK+9MjlK2rc1uStwXsDsMogwIniVG5xjFX8DA5v4zj5FxDAYE5DR5ZQBjxqE0VeAYxqfUalHwCS8JxXimfz49xJ4as3W1chwkaSRw1zO+QDVGV0Ji1UOR0=
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