cg5zW4pUD/CgRZzgS66AirAWJE2u+ch4/F8aakB5RjaLvV5N4WFXpTAhfYD8z6b/29RGMkrpOy1POtiltiafTt9s7NzuHL2Shvm/tlz6n337IqDnuAxSBmrI9LUURxluqmyNmBd2aoaJFGO2axdyAlOTP6rPH16QZtCPhMjsJ5UWaDvmQ5bPGHw5SwQnaux43YU9eoStfvcuAmMrV1eUwZJaKeVfk1E4XPQ6CedJ9TM/UOGwO7vVcXO+DleSjID5hFPBnWyUSw8kk/Yh9uEot58j5aGc0K3lAZp9PlVwGvC8nxh1Ib+G0H5bONUl+9EMJ67rftC5yEVgZpdPCbbj5FMVb7xc2aw3mDHg5Q2sPeJKXutTeXnk/tJ/G90poRHljWSqy2xjagDASc5ls9EKoTdezwIQkxkpY+ZZRUU7lpBBZnXHNjxxQETkUYr9q0zrO8EWYeVbgHmuupgIXDRjQ0bt+p5YNcIJaqXsWIbdYUPNB4JjbdhTzriFDLxo3cgnOv5TrV+g+RpVyLZVbT2f8KabQHVtPHNSjWtwoI2tiJ2LNyfocMZj2VzaAx6ZDZMEmJaCTWYfM0uQowuByFwMgKu5aqX5sAjWS3SF4TWSJLXEvHI7qyri9l1ADEDPd7zBttM/c6D4RcgPTw53XSUzsrT9Pna9fMdPwwCotT7Jj2cgVFZw23+3FIXpyRHvJpiX4lQYhCfeLl/7EU9FLNAGJJM6VL70VN+qoiQ1TDVI7TyZ2KjGD/swcDF14FDS/KMT/KDiwsDZcbl7gb+5kGarucfrWZR6R19gfF9uHbCRfqeBt9noVr7sQOw7bqI4bCgoAVfPrzcA3IwP1dri28PkJtOjMGlTAw+VWus0KXi4psQ/44e3IojrLE3bGW4wh56eruPi3QiBKZePV6/lCY2+vWQiKgQ4064Izs1Ygw5DixcfJFpe+9tAJW63fjyczxWhubC5rGNee2gV5NUCLeouo7j2SbLvqFofRYhK0lyCTehm3n7N3/qvaoLadZazSz3lMK1ZniO3X1HwTyZei9vU7hWYlGTcWMF4PbvKZ8GNXxtGO7wbfbRxda7vPmsS1SZa6GRHgOnG8iYkeSGaPyMBc0JFyFHZDltnHIf3SDQHa57DRD16pK9NqADTVv180z+j4wOpaL8kg88qPZ4UwIUHprLzkHS6kz0hdxVpg+S4Fs9KMXuJzZtcr8g6sAxHTmBOesEQP5U1zrvPjvvoIq5nVdHIw1bgcP7bmuJvJK6b5KyiHd3OhonG+4ldCXPD0vZl01XZvCGl0JzAsrhk2K9catQQc8Y3Yo90n+87S3aXuCho2C1LECWfkVhYxEohf5n5cXakrimR4yvNvbCLaZjJD1pp78vc0aYeHKdAArg=
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