n8LMZY+LKTwws+RV7R99PVfqLx/wyoF5LFcJDzPEEA8weLX1qD7pQ2VfhhwK9UpWEegqUN+YIMUtkFkzlysJ0oy/e2UfnFrQOTj0+3Zu7woz6fSrERGNFtYzVLXD3pKWxMQno4xkEQOG5+MjH4XD7Izc12lU9W6j5OsLCTd/2P/ql+m1Ic5hO1I+VibOSq7xiSrBhpNR+qorCFegSZHl5ePYHaThALG9GRy0K9lXulc2GH366l7Qf5BVTOl/ik3f+pnSNLLb9dsKxNwjmaeGFmqm5INFIM93jPvdGK13O0KJE/CdepXSHmASS3370LVkOQAYQpQRz7HFqB+NEI63lYpYvPoiL/wwduAVi7TVU7lCPopKLBKFY+fQwHoY6wQ6z5kdq6UAyB7bKEu20P9FJtNBhaFXkNQ15ZEaWP4Y8rCNvSiuIPSF/hk7bNGF5UvdEwoxBrnD4qeGUDsfbP3A5OfGAJTlIlr73o7qOfv6195lnPy39Sl8trSH8Z4MVea7HyMgWFKuJhXMaum0iaBcuUhZccwjU3eNpCQuNa5vTnIhEf+v/+NZqSG1aedl/wZ+tVqeqltMXAOc+1RrZwG80/CBH6a5N0nl0aS+6Q7wgu6FHu+vH3U8kfXHZdXNps08qdix80QOvCoXGZ99QMm5ONbEL5ZQ5EBe6ZCG+Puy6hf3D+f/ESqTcVLIdGMQ/bkA1kkDUOHGmBbKMM1aQpbX2qnOcloQAmmPSLCbRnb+jP4Z1eaxxxu864g4EEkP45KS79ww2K0DN01ZiRBZ4URr0mckExi1E7D2v0dCKRH6Q6sLE5A/dJw4faZ7tB96Oyz/QeW85UvrzoWEKYTc4I6vKcqq85DG1SwoesIOqXiHswfSv7BA5ilw2TNRX3cX9IBCw5WwsSGBu2kfS/jVhniPZRs462g9LH277QI0XTETjkwAVBO61ndkjNftWp8+vJtqe/Her2z5KoMHnT8EDtu1N0TsOnR1R2o+WYI9oPBQgFqQzEqH+8n4KhIk+NhH4POHdc+TcScf7ItNRGThbBVhIO5Q7l4NbZ4ccQArNDR1xy4UiKWllKmM3Pi9DL1Vag3YhehV8u4l1zZfO29CBW3tQjRnyXsEx3BUc9YgqHTa3F0eJJehe5sYSV//hJL65AXljObiHIJhi0a8ySHg0CSSrXh9h9BpU/9zr/vKekRjLZzXvTZ2Rm0firiCTJ3IOZs6VxaCRLHoF+uR6ztpdSLDUzuXQ0m1Q/TY6yJm26WKLIYwYmBnTwU4jURJFwdMc1R74ZPiHlk2g/1l2Os4H+aP/+O7pcdF+iYdkVQNrIEc4djCSlHvKbWAblZv63xAqjIqyEbTFwinDoFmPeDCNRyIiT6Cr3PFbTJ8/CSvJ9I=
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