rlet/kkBE5ly9HDMP7OJFMkcohhV3IkMfp5DwvxLcrX8Pe+UA5tfDbC3bRG8mys46tqa8YmfkrLzQkF01QQcc1fVQV/OZk0msExdEtzBqT2R4mz7HiSuYt0yxaSTcyYHDB82qhar1TJoaiMvGrJvREdUt/kI1rQq6NZKsltyTXkxslNYXLl3T+fDmuMxVoQgv83YrJbL+i4h3DZ+pcvy83nz70mMXEbbNzgMSI+jwf8agaMkSPXgRPZrxjwkWX3+RvqK52qLGtSPqnmXvYVquOwXDdEPadDsFQ7A/QS3bGjvBlW8ScsqL8tGnehJaX7itMw0j8yxErnBhnorDbdhs5CJJixjYasHXieuTqOQjLeK+aCD/+bDjqn9oh316J+HOwUMHGkT2jIbqNwiQByP4LlfqI3HiX8L6sOrVwcF3RKb48yaCPiyoNKsfZK4jhf0BojDKIp/G1W07jLpBfc7dD1+1oZKt6QgSgPJiRT4c15hRZ72PHWsXhu0b2791VH37kh6/rrcLilaXYsgQQEUzAthVD4bLf7YYxE4tBpYfVGx0diZUSoCo/wExtG9+kuQ95DUwlijEF+kLeFKUY4AxijQcomR65+lfKzcQOnzIPUcCmRFBBhq2GjPfeH6XuvWvkQnvRJKQ/JBDv+YPpRWmOGebooD+8SE93KpSHC4nUctdnc+l98pYJ+PC7LjwUpG5T2Jc1Pa/wFOc1Lr36jRRYSREVNO9weJ7nF3ErY20p0nNgNaqd4FCLpK2wTnGr1e+eNQSNj2xEvYOnd2wj+wCsS9N4Qgks8jmSsC1xgZ4W+n2CSh3BptFMIIhlgy6Do2GQJtOye+jv5+kk5O9JPmv/ayoVet8Y53kWULZuoGvozeFj9uxw7Mb7VcX77LktKni7Qk3jS5BAiMag+zIvhfs57iSjEZLp2hWVlUq3fgDZmdyHEEqgKzv75M1vuYMy3cluI4Pr5KMcIoyamBwqHqGDr8U3cFOQ4ZV5CSF8Yx9EmW3fcm67KxjTU5czXdcUhAF4DxqEdPEjSqho8CP3SbWbLWjiGB8BCXt8EzlvJWnP5IM52sedFnNRW7MHEZVavnKYRtFGaPQqwnIoWZoBVwJ4mkvMTXquDPWKSYWhPQ9AEBu/COngy0ueRAXx4aBYfrGjEuU3uhctm3Hqex3ieWWtOGb0G+J2pJwoTvlLy1zOlQa2NKLJ10wQ0CPdkgyxPeN7CgbSFFAhViMaH8uDvX+jLosPW5VUKaz/IBBNAA0EocrQRGMadxC9UPReoJWIxXvV2ZIdvvFkpWDd0ga+nLXlq94yAfMw49yKCkRtL40Z5sWAj1vLG7idG5PB8KHIwsaW05RooE8jpsCzzjf4kr1eOWF7VzK92dIc2WrXA=
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