4wJXOI3ihhq1ahqksv6LdbxUQJwYAA5ebeZ2a7D3FyoZ+bwFuDY8mysPbkib5Sjh81kjKPRvzR53U5NsPKuLbtdYPOTcWjkR5R7uWYvoM4hfEGJGZV83CPtadoaSr7XUwSVYB/WglZmJX6IpECV6sDov+i0BysVWQEzDU4SV20egyMrWySa/7v8WSFvNUe/CtOpHX4LzYJKD3xvwppomf+9yl7mPOKwRbb+T2o0viBEoxTx8hG8i3OGivmiHojEERFFBoJVmD5GglwLb2MyKpj2oxyInJ2dkwdAgQbSPa1J8I77QWQRH33heRjH9M11911vSwfTyEPf3WKlrjLxfqop3vQ99Zcz+PKel/r9i3A6UYpAxp16XUNZjAkDMGeULMqWuKQZ3PnuyP2di6CPQ2/bu54B8IplJom90xba8yC5odiPyhqkhOsXthJIGgUt3w9UInt5727ZCl/zzWp5sLicjjlCdsRFtigpDEWyB5XWvlWFaonH+HVyIVQxNqv0M25sfi5LZ5dc+7meMDxSXkc6y50fQsmCBQxuOf3wd1YXjjmu4RaioHA1KC8izvpm/VcIXjWgWBf3P/WCeIKsO9qigE2dRwhNzvbYzxoulDr5GzQjeq9Zn/bagEmZS7bWER+j3qP0RYpimNPjCfX0NR1BQGuma3B6TfZX3pNbYtydTnDfzE2VMrWDaIinYiodP1NiFVCY13T3UNuj7Twc33jAuHzI8WNAr9Q7NtgN4d3gKE0s9E33Bvs8/tt/G7iWEBdbnt+jA6g/9Z6JQUB+tmLcbKCgrp8NYDRhLQY+NTg4EfVbIzOJHktWs2RBOxChBlxLhEdTzw/18uV7k9FiHvTTwwUdqceIjpmXh4dRNKXRqaCxCazNO5YdU2epcC8M7XjQ/0Oq9gLK8Np95UC74cMa4LWW9JuDCfB/1tBtRoUz2vXOBAfmAR1BAQuYXrx+Y2CdKts89Ry0EH6WlLWcep5ZiuFs6gC5u/xsgs/u9MwJcJTkmRh7kzy10LKzZXQqohN2RfOMYtYlG8herp0y+yVDdzfkOdm++pZjnu8WuFs6hyNU9OzprmBGzxpMqVSg8ovsomWiphtli8pIVco42E1T6rbd0gillKHm77PdzUCuBUBGVBstkSEE430wqi8if5JMLOa2kBxo206TjhvDczl+00h6OcqPfydhzIDrS3kuseipHAmucJkgnICfQLvJBfPRJDOBvw4nd3JCuEHBwwJPvinzvo2818ytb6AZ1mYFTLPUVzSEaPK7CXozKaXRm4pgnN5XAApkPz0wCpLLzJuxT0fJhxwn6VFggahASLHAcZe4jC0EOv78Lstnk23p7x+AO/taIxbaSfxq5Wm66my4OH9Oa3pqZyYwAK2g=
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