bv3hDxpj6gzPnZ6Trg9wAErnNBF6447o2t4T/MvXR9mCvj3bAcBMNZBZMa1YsQ7rYe2Ixz6qMqVn6Do3g//wh41lhaFxImz3C3V6ydbtmEB0BWYSlvd6jAlT++KVDoaxWOSWJtnHw+4/tWojdREcSaCzlVgaNjXpWrB73weoHXqvD248Gb+TwTqpz/dyWieAQ1JNYqIvFTjga+UQtx+cIRzyauB4ZnbYy0VZtHB2K2mNbSUXAl+fg7M/CBq8s5wHUKQBAFYJ1Jc0S8s2PpnD3PXt5mDlovUrriK/1rPGmjl4r42doZ3VSyT05XZeqikFavCak0frdvlNJuBGDtQlgjYIDxh3oGIsc4Sj9BCD9mCLmlP4Fv/EED4vmn9ck54EWCvjNrsbjHbCtbseZR3sBP2ww8ZTi/sI0+Qs0Dx/qacJq9CGfm90RLmX687DsAlrZCxSl2VJbkfLPFhPEu0HxaPcz2aucv6+x/7YLKuADZgKHmIjZrTHyHbGw0mUM7b0sKyUFf579jmN4hASXMMn5HEOCR+VOmXXTuU/0HyqWVhx+DXZ53OEUpqKfGP5TZcr9sbioXb4TlpXmQV/AF5nbjkew/DOb2wIYjqVvFm7Pa++m2mI3HqSa4MScdBhOuE37wlK8IyrwPJxtEEHoKWsKVXKUlPxclg6iQFWsZ/kfSMBMSZoMe60dDYMpJ18RMvoNw7BxFCfVIIGyn0fxueIWCoMYwD8hx7qcDOOZlLRbDMCtZfFF2ZzYx/YFal+4HaC/isnuabDAu03l9s+up73kOOiUpE5NxZI4OpWsUBBBPS4EFvCzjNgF7sIUAwO3rpduaGbkIViLlKZNgazwg8UzxHwiiKiNTpe4/Sac/PAZBcYiacXhqxHcDfCOpJLWJx6yCezDQVDvRWn0WVN4UpiKAKfETf9XOp6dJl+DHanqB2AHt9zqpXISi/LKVo14l0CUTanZNHMUYxgX7hiPSdhpkcTKya/RX0p2ZiSaI68B33AC7Cxr3boqAGFup/Sme3XXVydCvyz/sUBtqKVx9ZEFIJps8GQe0/EBTfY+L3VMKeZxayPzNLMWEP3e+kDVUniJbht7uNdxTpJCIJqzi0Mw4B6UDzOGHoC6xnnBMjRU/k2JeQFjg15HIoCxZ0OgVlZtdyYhFNx+L198SqQLEyADxGA+KCrMADCjGo5aGn8hTk4jX+xocgQkUh2u0vx6Re7CAG67ZrdRDgiWFmtNYstZIyDhUI/br4r68DrnoBnLDADyPggYCfqalQRcH+fDrAWJpNN4KGOelgmEQT7UjQRIdS5XA5WjRe9wy3ciml5unPhpmFzwLfibFPs1BDf7Rqt3HXZah5xFW00JFFm3HC2CKEa8M9/oxk7nEjAE5I=
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