zbSiSwRfZBy/JWCXHyIq/0YV476rBmVrkYp4wmt0RA9i1KfqSvA2kZQFBsGhdV+3hWCSsDcv5cUCEE8YsOdLOzbrLwl4PddA5Sw6dlmRdH5xRX/XrpuUmwweK5EE+2iFcQ4T1HvnS6MMAx2sgBk4uDa8DmJ8Nu++Uqz2S3qmG4vkD8pM/I9yLUmbTKp20Wy4OC+Sjp3eCdvX6GLfti41h5QEOKv/3DQCEXVBQ5wOXIg6pHZiTg109YxTnFJJ3dkZ9RA1aBxzbO60WJzfFNSOk8pBvBxhApP8C7eApFifEfsD0L7usFfEJ4RPUyiECBrWr8dYLqSzXsO2qqg8pOPHieR97jDNcJd1f8Dgc4hk+q3l6UinasSCB4SHyGFk2QF9sTHZBQy9XuQzJteBlj+a8Fhtu+skEtsLEjV2OYcyRNjbF9APRWXwSlMxUF6PYS8Eetck/tbisQuB0sqkb+FaDZ8l+eBk0CNrYEpg6oxvyMRPWmxvDx8b20EGbsaC9GBT6HQG1LCr8bidCV2UfOa4Wf7e+TL9tZZ58TEfCrhyIa5BMI08ZXz//BVZ2k/6ovOIyfJY+SWfRDBeJ/8pWI379LZkKkom4NknRkRZP6jjeGJUAXwLhPflXUvgtpUP12yMjkrRgZwfH06KJzLNi1dDKJAGFB0gbqkdjw7o/CmK5drPfZyU+bQCYG0sJH/qTBRaO5hsGyhpMqx8MVEJWSc+8Wg56SurVbiKAZkCuF7OCe2k1OpRa9lbpjP/OGvrEXBKNFNcfnQOm51vPv+UtB50nzJYAUpHO8rydVKkC6nom8hV6QJqQoJDbz5FneuQWOqSSCND8V8bFczwfBYQlnPhewGe1JaTsozY11Flih/SXmIXoqA0F1n7cQJkLHIH1SGbLg+fRfNoChqVSOrBID8CA9Vc6q5IuNZZYkPntHehYXkqr48TEbIMuZWU4/rgc1qrOwmohCb+1V4nk1s1RuiRdqNMqS9JUa44qfCeqz1l8c5jzJJZMZiiHiiX5piITDxjwhTvbPuNAs9XHgxRmyscwj73XcCPXCddZoUCIPV7ytg/pBsj/v7WIUHLovCs1SB4FD1tLLA4d0oDEu0Tb8NyWIMzG6pU2spjmIj8tXTQBhmmeoULarByZjkSyXHuMLSH4Wt1kkhbtTeTvNcsOGgZN1pkHIKQY7k3CsdaMEXBsTgzzHcW7Ua61ZNDqGE7w5bZF6I5+TfmCnm/nOGMs46NAtkGdoDazRlT/pDe+WALp+t/Y3fEXIfFeKXb3ktK/GV5JLka+2gFZ4XnrhpCbf0Y7B64X53dKaWWRyNSsAr/IL4Zo5Dc2nseFQbqaWaHN69nAhLseX6ivf2W27R7LoeRfX0k7qWxd4jsiUI8v2Y=
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