PcTxrI8m5bpgPXlH501iO0DIZmqmOgKyr+89Ft9/IpORltjQlE7cr2Ln479lhvGsQySDIHq/Hdf8e+fjr75HLPQYUR3J7t9UvHhvara5pMVMylglPmHo4NWf83LtixpoO4j8NYwTNkCidqH1eZYz9FENB9szDl3H+Jnd0IwDVCUPDi4H7tSq7qzgUTHNttkvvNhMqEv8cf6zY3UcHZ/0owBlopr3otRntOHXK4Xp+r7ukRUXJNZJODkd7bgcwiwCdHPN5HmQrWk9tzwrJnW0CPhMn8hPQ+M2aCqL3n0S70WLfjjlNEePQXZp1lBrvRx/bDopKlMjgqX5ZuCdybXGlJS2vQ8BUidIwm0m6/HNDGNG0FsDU68Uy9yBgbsNr0ISmF7OZThaEVauWk8Vc2C9TmObxRiojt4AxDP8lv/KLNDgzW81kmSH4gWjpFxLhqSP44SdFWbS89P3+Qd5fQlP+sOOE4OK0Ad70aBhh7A/VE0nV78t8xTI78azY9zD3LInNhx1c17r9xip/PursfAQYg8EyhtF/XDElayQsrMziJy0ZyEz3NCDsLwdpaiQRvIVzlCFFUnHWUb7cWKlfNbKvIxqwYfy2ecP9f6Em7wMlWQBodHov0ckrSIkPZD8khzn+nXjw5RpxxP6QOhUvlxmUkD3kfPTltQHleamTO02j8XMU9BeTmeE63jF3D57GTzLDIr9o04nvyFPUK8lokCgFo4EfDPhWOfXb/wh+ASyI4NvXtGwI3WpHRZyDY12kpqHmgRBhw2llziQRojT9OxBdoezzJLEnyQR+qN2NseiNo3qJjWKty5JviYaQjNVwcAWRpZKB7qwPwrP6KctqrD5Ei2VS3pzUQ8k4QuQi/HxJ2TKZVl/KztJ1M6LrnoV+77kunvx+/NaQbrpIKU1EKGHgUM5kBP34iLuA6gpRUkxih/DrHSnA2bJFrcr+/qzsRmMsaZ6PJkAEmd684pDiNcVoePGD7e/4TslVYcjAEzGgWsmcyG1MlrPTOQa47zcZ+LJw8UMJ3azaJdK3BqLjiFN6g+wRqhipRO3hcTdkHrJlDChl2zI+Suq+6lhtvpG9zgqqPIm3FrnH3Lb/k9ffjq81XBe74T/l7DX/sTeBe68jSKVlf4PDDrlIUi+aUP/td2o+KsqFEpY7KluJlpbvtycRENKzEjEJTafmrxoSXAnvEhuEpBMF2S3sy7Url6NBAYPAeXBetuZ/vj48ySjvLDHKzk8MrT7hvTRUWKhMrjqiKIUss/YpZl0X/KU/26O3eKEocxbEJxjJPkLxYSksNlCbEWuRuKkb0FKPsf4qE0j/qKxVazjFsD/fc/J2wxVUu1SPCQ7WZisjiJLLrCrgz/77sVF1hHGQrHXBVZCFLw=
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