DKL01jVFtprTAGV/nmtXXpD/OoOPBTG/pHAmrCjjpraLGv+EqIvGj4HHrMKsUx8kVkZpejLQ4mSDjDscHboriI0nfqpP7EOo8oQI0iZIyTJcsMaiYcMDsVlLaN11tOYItSu7p9bdi2Gp6saenQJZPId5mzOahWXU/tU7YJx6fejvljll+u6qHosWcGQ/SnN2lSMThW04/b9Qs3UJYilkIs647lw4M4c9WCRlv+QYM9oGQDuIsmNgZTvnKJja3cHDUku9zUyAWd15+W6zcs1T1YQXczhkZjXXKrsLwZD6nCbXgUFOHqICpkmzcHirnsbBUP61/KuJceVzBXnYxnZBYGnX1hA92u48L+dJU8VlpWzQw7e212SjfPOwxR+QppSihZrAQL9+YwjgSiD/XEzNVMUBGY57xd38i13sQLUimUsSzNV1YS4Fx2uKchn4LHZOWXWgvVu4UYI+7T81yhSWu0DRzrOJC71WFGRbworAd+MeiINWd4GJmSYlAAnGq398M1JX7yPQBQ5rBmLf62TeipuJ7z1SBaVQggX16bsaGnWVhSppHKzDgioxaukpuYUMUdYpOim6axKOXENhKvri98I5rUlkHKJtbKfx3Cu0QPkmOwXSK3cW7Fa2/6beSns+fFR/cCgxZZn/SN1kKV246QI+GbQc/Y7o7go5rYUyWibL85dNkZjqQ4vBSHB8bwgWuqTNY3dF1xNxFyd7KUxzveoRojZhXJY/2vyJxM7zUud9aNhaye1dqd5+CTHwvo2NUCk6AopnEiVwKtvqJ3OWa1EbRJo4fyHTC+XkJB/VIbpb2PG36og05yxrRQLsUQuEsJTJqX0dHulrdy2gjKt3hnQfSDzIanZ9cQMe71ye0KqA2EsS6K7ljpWxGH8umAIyiSQP4L3YI/WmYSe0apBLgVidWXtzzR+zJHSt62AYIC4E7S5aw1ftfIlgBhUMUlA1X0kHzS2kX/pDlM+eUF15UzjeUW4R8sztoLVVlf/qirshUlteNa+xYPUnfmQULsRbhBJ+XNcvkoajOViIZ6BSYWRMJNES957ZFcYZ5VQjUPTztp+ZAVe6vyHKIsLfnqaCgugniEOHOa69yQPwN5/kFn0so80jmY2vnLP6nGCRU0mPEJpTh9c1PM+S6i732/YKFF0lPhTnVsCgaCnjl/9YNtHl2rYcORkFvPWcTbmWpwEsTwCtgbXM3d9Y3Q4mJA9jwNgPtUceZPRVZ7DUBNebe+vWaBiVhxw3UtQAkRh8LLNewS4sPNcRCHkOZLsxpa+ig3oYvluCZjwJ79LfQJdo5YX2V6cJILw8ZF5kYxMIh0WbQSo3ly8Y5BYySn5S0EIaB/8r7xHY3XWNt+Svuh0zpsQzi7BZYqbI9hGhpQ4=
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