LxEvFVuc+XXXDxSVlZnFJnXWuAG2TzoEOMHHzsFcUkigf13BqI8/QozoZisEfm07mNcbOz57Vdipzcmq8cdN+KFy4zpB2HGR/Kb3/NXxtKzkLL5PJumpGqVsQAvfkgKiKVdk4dXoxI6PW8q3qCNEjvwXnCOMVKXQAqq332Z/svEUWP5l9Tgh/G4UHLcETSrpqVkuUFxgvGIdpZ86wrgDhxmxwl3+TskmsW1m9/kzzX3CBcxd51sgKp2Shdfa+i5zhQpAk1f2SeArQ5oZElzwVtfvxu7YUkVFyEBsUZKzhhV5BhRiFrk1kcheCNKAiGtrwqsnpU0VUcejVoXxeiBYYpWX0rROYmvS9Ul+Dqy61xEtv/HZ6A3wPHKMDEnBf4F63EO1qQGL3QfNb0q23nVzC0rAq2JuhFxWKYH/iWAJ+pcZeQQl8hzLKAqkCyuo0U8QR2JB859u9z78faJS+8dqpAqQhC0w0CBEXG0EagmkkBWLrw9+dshTIbI/iYdq5rlVLNci8aNS69/RpLwastIZry2YgrJha+EEH7ab53rabO+WLqPlY+jtpAbnkSsUgRlAWDM/C4uXxJ9/LGUiOGuRHMGyhfe0LMZv6w+UXm7/Alm96DXtnR6cqke0xtp+YYbj2sJ6jgXx/KTAFB1v0UrIP71tmtHh/PBS+s3q5PZh1OddlMaujMWpTSs7fdDYYkzlUQaJty1LuLA9PYwcOl6taTVisPzdvHXOhujqOik525Ezia+E0Xsur3jGKDcXS2zGiCHCNBtjC9A+EFnsTNXdtqBywjcq+tOXdTPuKUNgCCoeFiBGjPFYMZ7jn83TWcubLwrok0Tv/K6yKFGYn9RNWpr0rMLFYxO+5eeSBbUF7/GHyhs5m1jqcJ/W9VWgfnzy9uX2bTONUjXJPM0hauHYwH+4UDR0NHAuUzU/tRGtcvwy2pfLYYGLgtzWP9u/oX7wonovTRHoryi0qYachRrjuMKcOpFPJsWv+0J34ZaRC1clYwjN9DQI2sExP/0ZFJLvQCQiQn5qJ24+Z/WDNE/y4ccpqnLEiRTOZJOCDvnQdM4W+O2Xm7TMOz/Q7srLh6x9dN+G+j0qNKisNmwN8/9DZ0XoyQ9azV1vELp7uuluqp02gss5IIu44T9PeDIlsqIHBFWATM0bprS2VT715v+pflI+kde/4CK8J55NjII/GCL6Q8uTeST+nfFeZRrDkAaApAjVcP34mTyKm7vQjuXTHfVcYemV/2oK4voRzu2Yj2UUIQDJmlOzlFR6H3lYDf+CslM43+/yzDjJw1ybY/smXgjyaU6/BD2nHxy4L17cA7xwwa5Phxa/qm3PMgm3lIaH2Mzqa+6TnadLStHqGJ89mVTlhFeOWEO+7Z9RfSw=
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