XWyymzusKj1RxFLxl+hcz6Zu4kpOxyINemSYLaX80L6jQqaKVFM+r42xbxbyFniyy2SLy57kwvnsdOPv/vpLsQARlR83DngxLjje9MomOW4TMUFCGwqiLnjLlJToPya7QYzDTO6SqyPhuIUH0h5TYgD1uoPXOwEct4ZPTphV5NWjGqV9aXgTmHeSm8WsT0Uf8RhwKTknhiCG4eTIJCTwu4VE1jigdwlFXx4via2mFRwdkA7lNZEmvqAXFwbwL8uBahpYX1egWWE1Wq8Jdp2TcBn7jcq122BDnrtuOoR7M6K0OYGoVPciqNsVO1RuwKx7029wPkpkdwzq3pgAx9vV6XEnrfEleQE1fIcjdWH9MpTeAegK1PGwJDej/j7c0t9OMQtNzKRDuY2hEtZs7herjdBcqI7ou0JGx9IrtH4rjqfcOOuQp5AX76Mcd49JGxYJahouQWIte3f36TBnk7YY/wqpoTUld60We2Qoq8Lt6RbxIYXYBjpS0K+VP89SQdus2246yeSNIFYSIfaUobu6uVKd/0bwHZJ9eszLPghofyFIZiitwS/lcBBS1WAPQ15q+JntxyLMLlPeNJTEff/bCZVPbnsyrrMXo0VKuVDCNqKE7TRDtBpwOTqGkk4qEFVnBgy3976P7b7aaWJ6SR6ImIzQtuCK93pSquNeAdSDqa6KbSmtysYxsOVG2tRao2aoiJmxraYuiLXPNXq9KKU1d+lAbbJ7PGOhl3jkOICsfHCTJqCQ//kv+/dNN1aotLu0Mwl35dt+0J30RbnUyDMjqFn4stFTeYZw3yVRYyCNFOlj+fml1ceTEUWEKf5tOwU/nGDr59kndizh1ZYlsJY2Y9ufoRqY6/cRogBHj9SAZ/eLy3ULTjiIDa0LPKfLF+ViyOZ5gVja5Q9AJ5n8qQm9R0c0dXyqOkbEJky1Z1xJ+zAPGqAdpvbVFewDZ8rXMaHB1yS8/XXPU3G3Bz5ADP2BYsRA5xn1Hi8w95JiEqZkFQVmOSA5JMWvGcktqx4xHW/tLtR2abA92PHHFfiULxKhqud5ANtjFMpIYDPT4aBb1UJhf8/pZgA/xsM6e52+R1DxtISqrbz+THyFd1d1M0E94mFgl4NjE/q6UwvCV1Fn+BtSjBKPx1C8vJjLnqQYdAd8JhBggQ3AlXdW7Mql+vHr+dVRBEmXuYDjcu+ZmG5IPXc6biW/SAjvfyNPM45p/jMsgdIb9Dv0FkJx8iPjyt1e9ToatCqYUSw1OTtAQWz39NJbV5MiYqqKkjUU4kDQQrboTDGgriMffvo1aLi4ZJ6Ipnp4NMT4ngIZG/6s7tObGXo6g6NxN6UUzAt8J3s37+35q+dBCylFJrvCwnQVSlZJ/pN6z92THx+SECTeqEc=
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