IZW+8GVs1uuQo/D6b4sdAtw3m0XT+RYpmT8MGXikRdXCnnAmiqkv/EhgvHiwABSMvXBD6cIhsOSHPQ6/FEP+7Nh6DuAbwWyifNmTfSrLEDiTCue1+o7sCpgJ6VzM1xDhOvFy6NDNiazy2s2aBxuh4tXsRT8NKnEL4rHC8D+2cF93PA9Sf42hCaUnT9fAgssE8ZpQMk8Og5K0o+KC4NcC7S4BpCUA2ZgO9jTfa51vSNQo7uYVasnc9UjalWzsH7jT1zsIPkqngMs6iQoWImgL0BX5KraPMCfKtkBRQJog1GQTRmMmRQ2QLIEel4D72GpwgWxu7r1AhJZa+Tq8EMUcOyhGoP+8MbqiTfkoHE63iAvio1EhUk9/GqAtydQo82u4Zs/r7L/NQe5dKqcjUhpA6tJ1Qn4H5o2+dXutAK5GPRULSNCYyxN8WacKLRgpyjrssedhbNEKyISa2urXUWMM6VocdBrn6lvpAPyVI8unFZlKQnuINsXfGAOAo8S5ELGhrpbvut93srooLUtq0bHN8BBy76zgFPKvLjCtBk3IuN5VFImT1CZN+e18Qg60/UFkLecC7IZR41zw4hPFtYwwuqZBAejSch3UgFx+mdVTFAvglhuQ6c4/TlFvgO3zz5PpxzHREfAgQ/9hPhZeiu6/Lv9/aEo/J8YzZXsO/cMz7xCxWSNApLBxSiASOGr/wp1+V9OPLnkn3EnW6v74jjIJOj1906R6D9Sd6fsvgMmHf/HXV6l/tmBRlPnvY+/PmIdJGBoT1IHpy+sH4fe/XIKGH5Kqphz9fA9PcLOlTKoL9wh9Re2X9ycWNZzFdgCpWsP9pLfum3UpwQFc8A424GWvIGGu5TdDRhPrx/bxF7KIii/z/q28OaxdM5z2HT0HdCvRq+MGV6wDo/VIouruJX7vU0ECYf1WcFGeiQYFLTb+W+OeJSdYQPuwUZW+dUDLQc0UJQmTJCh2uz/AcNXVQbU3peVnLsBbKjY0w1qpHqBghtinsRnRhkG/h8tUmvIuRO8pNjXbYGw+6PYuQaX7ZR82ouDE+b+Z+NHsXFS+TN+oueEQCX6GPO2d1oZQBmedmTiV29MAaaqpW8dScc6n6ejos+ePkhoWlnVlFdNi4fkj4Ig0kdNupQc1jgxpIiljWAA8bb7ifcyOHXpDEABfmu93rdTQQVF5fZDms6AWC+cKwg65/2TqvcfevxBq3m2wxz/ik5BljyZxmxmOxjlZIW+vdfvdQPHEda6keYylZqiyS98ZsVWxmiTn5jKk78kHXZrsBdfC/A0banqw9vlzLaHqyFMcu3rnPj3pplOOGax+VzsXAcNd7/28GQmbUJjDKFMQ5b5PsIFjRQzLj1/QIL47fUVBlT0WU5PaiFvR5+E=
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