kAFwcIxHrr5Y0zfu9ffvRxduwYtpYDb8Qf1K+vqF9mj9yspKrxbJKlusEeJNB9SSx6DEvSG9GZfm8XhBcV14z9r+tDqteA1w5Gz3oJZDWmv2YBt2tvEuszImBALUlqapj1mpCL2JDX8JaR21EDSA2mqyDW95Shdsec5PRWjwGc5oWYnnwRUXWqjPj+C8l6b8yyRRIVyqvgybUrnDUjXHidHuuLHdjmyoCp3l5YfDkbLq/Ux0/BCZmlVATZf8hUyIiNCtEocGXC/MVdbBR53FSapjjIYHgGKFlG1NkJTb4tfw7MphYzqHboeHZYhYxY+A5DRH1GoFrP/q55+ym7vzFU/KAzK513JuooxrPZTHRyOaZUJTqjRh1ezOQrYHpvtJnbWftzgsJCsgnE3Wqn2JdUM592P7gB7ocrQXgJOF+x3u5ViiA+0qYtblpCyBPlj+04aEv1LacsWb1PvuG9iwlR8C9hqISRuGNMfWyvmbmXx4W+TeDP6u4NaYz6uBiyt7mr/7aRtTFdiVVw7tMfrhQgfEq9YUswaAgUHLGApe4AtfRuSzJtvrpML0WjLA20rU6G1DuLAeKQ0bNwcVmV46nJsHZH0qxfgC5D4ozCaXivdhOISyu03uxgW3WYoVKH+DKMmma1BKAxxEFavCjyvLZGG/rnPrHhmnkZR9szC0j8rb9g73shz+89IIiI+mXrY1T0ekGYz3MwuzZSlHeagTCuawGUK2B/YfXlXsHFNJ6pzEMIvpkFLA0k/vnkyRCrzK+g+4atHs1R12bvq3idpbZhJnRY1E1VDh41bhvbjZ0lWZTGn4aK9QM+qMiYXQmyfwbxLWgrKI1AnPBxdptasgxtepkfKf5YKZqiMN8WhHA6CzJSS9zpLB31ApvRL55TJbuAxM93A15fIdbnXPtWBujT2+0BkCBNaRwyw/BcimXXWFbNUH1alpLhKbDBuQ4ePIjnzfAmoSLBG8UMMP27PY+1Tf6AR/UBGeTkoA3Pk+mwL/rEaRORBDfmADo7tMXTCtPCNnqmEN0wYtdCZBJpZooBt4C5UwVqSkW3lv6KPx/RmrK/iMLN+iJlZ5Q5fSQDEfeSJOl653843oN4qBusqvdF9ua610QWP0UTe0VGHTjTLk5KHJ/KHKxg1n7GQsk0GDgYYuIo/yRmzG7Wh6NzIjjrS5pZg03j3ZSydU4tVwIbIOgU1d+S0vipd57Z7RU7MzkJ8UNARWp90xMexhZEICTl1IFXdGrBhc5GIxouzie3mtYY7l27HgTmEa53nzuzb7pVFMLhtLdnVDD5oK4V58alfQcJGFl4xGZiSD9YPIfQouYT0GLMxU6Y8Bk3+DYyVaWzKjtbOz0gKpbkhlKs6wcQXsJGDayMU+rR8McDU=
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