OR/MKCqJ+BvojdCu7s+GMZAByKL68ikluvnnEP/CvCUec8erWOG7ybz4Vt+n8ZHqrY4b9wlDcLEzavGsELZEQNKC4D6aIJpDRlCYSnM/+1l+PHet42+DAODn8w3gb7VdcO5px0FAyPFCaoB3w/w5L3Ee37u8kN27gOQKgyVttDZ8IZTBC88fCbCX3IZ9Yi+XTvaTwe62lCOFpBXyinjiU88xKwuDMEIvKR6QezyYcx/XRO5+kS9ztlRxiFMQw5YLTWaknf7G2LLiremJX73Wb7NP34HXH4qpU+/pJEoSKlG4HYFsWFX0dqb7yHNzCDwr8XJSt9fkAQpbzLUB/nUU1kvoUGGP3NABGRi7EI+suX9O39pTaHTbfFIHStQTd1QYegaD52ff1jsyO9AAOdEd8joRhlWkn9BWnl3uO8RaJwoPIZQat1rINYf3WKiJGpNRHVj2VZ6x9HVdgjpiH51n6arfmfxJi4gQ1u6UHG0ov5S2nQhJmycla6oynTh2b2ui/pEI+ZS3FE8jij+jJliWUEItfCwVlyt4cmoVCQoJwmaFGwlvwtnDN1ftTocNPpC6WsjuyuEbViA6Wx8qlJZCSmVVevgYb9JmZC58xz+EqXCgu/APpHpz1ZOrXufu2BJvTSoxd6XZllJUcT3oqdfBLAzGXF6hhhQenMCN8kL5zgYzue6mM+MvEwr7jeXE4DgzUJYhwhCFO1hhkqyxEcwS5COlyCmcqysmkGTTWiVma1eZe5rxkblTeOI0kap1KR9s3uz+hQNExXaw7DCfLM4ThU2Sl/sttgk/BYDwsZciKbD6bmAmsEczHmTTl79UJwThbRMxYMQnmF8oZEjPbC916ItBgR20qaB0r9iJ7MOANJOoRL+KflmO8s4wAp0m2lM3MxHfWxunau5yZgsXtu3rWEvuBtUge/xGlX5XUJJE7I5VYZgL96DG4VcDPALzyzKDW+46ZZt0FGPbqR6lJYHuF0CL0uYHN/AJGEkovDY1zb2v4BauEthVbmzvv0Q/Avs0wnY/2mV7S67FNB/lT7qpqqUuyxHH/fJdcPMq3b8e/ZnzxV3yWUb+nfGz+og4yo++sDOr0dXn79U/OKvAktY8D9NI8+AuEdpbsgbsnzbdD/yOTH2iRo/jXcyjaXDnrLm4/Db/SWNiT7w47k8ROdL/oGUccQVtid5A5xZwQPiVf+6hKnzU6F95yCxjbe1Uybs0sPUSkT+fbeK2Y6IeX1HpO1YWVZX1X17cXRaMT0jfpfwNKen9TiXCPcMH9k5H9vgi6xxRTC4rcMYjVCrf1gaxq8vIJG1AOYUbAqaYvUtaztApLruxHQJ3yFbgGgvGoQ+8X2Dz1mFYTPb3f/gpaPgHUtSd8wO9tpntOZ9tENY=
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