TcyPI09hTsef5hGytX+FPLz5T1GKrVa0SFNXO7YzuweWTk9xRSb3AmSfKDyy6Sarr36KxangmVcql0mqfUsSu6D0+xg+MBC2dGv1oWEO85CkuUzacfH/6qNjOTWxe7jzcL8WrIEnw2kHrUX3D2AXhJKac7+mX4id2sKLVWm1+Kk2MpZLuzIjxUyuJ+3DsgPsRC05TeWk3Y35uHGB73qHCFexshrnSaUmQIX/XiViLQ9uJYXFUogVtFh/XEPnq63OIRr8/skrycvNUTZy291V6q5fsT6gigvzaEJPCV1HFbVQFiEBEyyaacPGW2GGfNAF6ozI0FjQoE7KS9aMUJ4eIiwdVoHhdzZ5rKP3PiJWi5YmHNPBBB+5u+0y0HKHsJieNQCreRn+HCoIdZmy9d8MzaWTcw5IrmuKRbVXXGeWClGh7bRDFtC7UfGpmt1JHX6ToCMvX3BcyU+wTvO6Gm4K13hDaQZpEdv5xfPkz4Mtt3xeRD8j/nlTJtFHt65DU+hAF8SFEYf7z3DPqsDwkZzHH/bwyVSu40dlPIYW2cCWyfPe0EZ7qpszGpFeAlBu/wiZr9/gvz50RokKf98RohWfR0FeCIwsC39tJAd5E0GZABJlZKtzAOfGW7/0DWFiOxllSrTMiN1HCTq0WgD7qusXaVIFLIYu1JThlqSka8TWfTvujraygAX8AZKpKumzN6kdTQtyzD6xJCNgDrxvsM/fI1zCS119LTFjDeZdLy4BpWuKCWNFw4bkBOCJMces5Q2R2OTW8pCUfBshHZdTF9PztTiTid+XQzjsZsr9WpW6ZC4HR17jxOgRdFGb3MhAtfZoLBmhcchV6wwiw+VUZYaeUU6LBvIADTM54U3iVM9p2qSr+uy/5owqwQBhXV3eC0X9A9x/KrA6CCktaKqWkUkzU+o7hP3HTEZlP/Gl/1faYQY4Q8KqSnglR3sZNiHv1xLXSPhVArCf2knN731KkNen4RUBFL4Pq62tSnT7Id66LbLM3lzCImbYUb86kNfgPisej5iw3bfcglYbF/c7MuFzlqUX+/0Xh5eRmTgJr2AVOIFDsXfuLNYaefMJWrnyxQN+ifUjKBdc0+ywnv9QF9Nk2c/4TvPWKvt6AWZUAx2sOzLtzeQFj48OGBX9r9iiHHvsqpjHNusbCjGCWalaEJZ/AXI9navNls0fIjuRhsVTSyEVX61fmcKzLJF/ao4HMkNjfzudAcIXeVRYOEUF7lNhrrDsaZ37Hg3pZ0cdgQTbLY1oPJ8JuqjQwE3dgPleuFrZhYJhrJZWgZBGL6ljhAAyAoKZt72IaR1CB08vIzHJb+xyBvX2j+riHFfgE6i59Ckk7Q/V6AMMlayJEZYuZBOzsUtjZnvozUxD7n2+y9Q=
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