23LHKVjwVZ7V0N5BRBatdL/eiGo1iaaXWgZJSyp2n5b4TH0GNqOKcjJgeTRyVe5lSlxxBr+DRGz6rcMDm36RLL50bF3FtF602UQNI9PW3/t2J9BnsN1htT/7mTtVUBHXyaH69j+6ynpUNLg8YWB35vDSoB+xV+41tzmD5YBlT1LrBFvEg+wJQz7xBkDo/i3nUCb/KoiMCQORJx8GFNXUAn2M0wWG0DAnNajpOfGWjpQE0OBPq3O8JznfoFFlR4k3fAPJMVVAhOBnUMfA7JiAsjsv5WW0nW8mtxN/8mJQr+9QwqLCL92HpTBgys2+5pzsUDrYgYFzYhEVJ/pI2OsF2YVIX85UUrODDSfjOsiwkngAa9drbPBfINXAdpP/uXeSaSrcL978LYhJ9Lf9wZTIu3MHu/X3qop8jBbIMeeEVXEm6MCZsmEUfIP3L9NsNJo+e0GjbsWqmLEaqQD0OaOK9Xr2XPvUuGVAIYnZdYuDjrci4dSgDbhUS5nw2xHCQQ9/J88782A6b8Egv4jCLQn2JUBMP7v4ArYGn89eMLddnPIKqHqzBKKEbqcpfMRQSnxM9sJpyxyq56yjOfMvaGGxGHaYcb0KRsImUJRpnZwKENrdnYWCvtIkJXWfax7+iAgDMbuYC1IFo1QmDEIgVcGmGtoXtYBXbw3T8+AIXRwpRtPXHqeI9tKYfv64NUzSTD4O48PkLjVR6RnDQ98w45YSeDjjyJk6xCMLxlPhFayFAnv75IYGKdTFbDLxvjZ+zUt246Ck/SzBfQiTOaFkUVaaRFfoW+kHnNw2Qq7Bze0LZCstxV2MFeUTL+VE22peru4MHCiBDV6XM7cGbbl1sZppAK0+U+FSwopy6NYdJqcu2xswZJDOsUeUq2BKWb7wu8igJnId41iNZo/mZC245zSqK01KJypazoUsEEzNV5Ruty4DXIuuMqivShFvbzojDm82xCDmfYOLksf5o6/9iwHIF2h6u9gCySbJrRVK4pu4pNurZsIBe2eYbvALQsulcgMATFljPmx7NbJx+hmT1bGYw5E4aObWdAkKVhGJLVXk7neo7DOrr6+Zo+kMyPPJ61s+9ZtqzhgmiHvNd/odUp+ejDhBosBtGDj7fgqSl511D9Mok5jaHRwq4qiCqouup/rfDvQbddQK0PYD5txXeC2OFWW2vAirDz87EhtYbck2ruIS5N3z8E5dBn5bM/jSHM17EPOQoJq0aA8DXrTDqPIB5KWxksOXUdU7v2XL6881rM26bGVUOtLZCPgxHyzfZ1fasydWbmhLxZipbn2x1Dix/oEGUgWVwDpnwxS+odv6VZJTkFlkSRoxg77SlDFOHUXCCXeoPWQyxytEXd2yGGlinr2o+NPGxsCqDW691Ug=
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