Ys86D3QPCz5svXeIDGVttsm6oiEZLZ3P7ACjSTl2cZXNO6K9oV1j9QqmN0b4EEW7uxIJMx7in/RGLc+9y7bawyq8LiN78dTPEg2CjS03rIFC4YrNVtYITeHC/YoM2ppNOePSywYpYAKz1vkUTuZorBHdCM468oQl/DOz6CiGk/+XKJjDqgKTHjN2XMQyxwVNvYXGDH5rR4zn5JEimsoW9AR98FDtTOq+oi8JxGoaSjUVUmRouyywukPg3cPj3LsJlcDs5jbZNisLT7Zs7wcU0JmWgrefcpKmf7BvBdzu1O+gG9/jjES3C3cakIhd2QkLZmukaGKqXTgRKpwlwfbx9obcL1DwA6agF2RnhiX/HNQSIbDfAjH/zhfKVtAdfqAPNoaywauu90p9/wp4PF5PWHKxXXYIQyuXouhRlgncgQsxEDKOOo5CDrTHBsoNViNsEimPkK3ROoq2tcPGHffRzKLOCUktcSacDQVAicAdOtGt3nXBFKNDr3ldsb3NVHIZwMthS4CFna5ormjaoOyZMC+ivinuaCJfeANQl+7qPF4CDXZ6Yga4wSWP4apVibmuIcLDWfawNIe4YhYMBlYmAqy7SWfuIZTfeulYZxlMFswsI8Q08LmmUqj3S3VTe7aJqE1iZ0s9PGrFbRV7YmK1eoBanssh9DOQpAWA6FNcMfcPqRTWk6ptxm7yKYvsOumtxPQfpsjPelKFiPhlNbSChDBMny4LPVm+QFw5g/ZyhTBxe3kyj59UYhNNH8AeTxXPIiYhA1dDj+l6Oysy8rK1IoCuRBqa6t3ZNVvfcb1b4Pc3z2g9ZKngdVE9eOKEozBNIonAPYpT+h+1zWNfIv3F77snSVoNFZ3KtkhAlqvglDI/IlCnzImXNgviLDGX8HYU3HfMFFoE8z/vRxUTMRfya8oiTD6vyx2pLaIsVrY7uPjR5UbxxSjmTvpUrL1kTfcqwczd19XTIEUgWenv1379AZc7wu4v4D9fix9NJkeLeu1vfSQkCifYC9DwaISEJpYDdxotocKIDJDYQdxZC7PgP1APR+vfBnaFTWvgcJGLLDvzeabsiHL/enlcxJSCOPbw+RrIxyA2Bvo8eTUn4+8pWdlLeEu/e3F3qbpUHHTUw6ymV3hJ0IwZcKFEYrKIk309wdlS+Vp1E/lzXDb62mUj9vMsr9Qh1HeiVilZsmqejKY0dGevcn1+aoDpu60r6Ie75hW2GkDkKp4RYMVl+mXRIrP0a4ftIq7AqX4uqLRxTsNP7hhEDUDp7k3o3FeyfhzbhcL6Cl5F90vp7Pzd36JfkDcMh/fXWY+sDDTExQznfCcAFp5Y2OdWRzb1UnPeMhEhHzCoWWqsvpR7l9VaocIFsyPcclepOvQSlyjJ0iE=
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