SBw+RkQZRR630d+Ui7lX2dyOMoKSuA/3IrtqJsBoBSUaZpneyK7/psju2NyGLGAZOxZrUZ+fNeQlbM2fddDvyD9GTIyVXxUn6AyFkXDfMDa/2S5dF2vf4f9Y/0KUXe62JYHEhGNDzP0P12gI1a2O2G1q9V68GbujF+q+mL5dr9Jnxl8TF3//YgSTFvgT5eRCKCurzSc/rY4p624saBkFWe/Fc8OWqaIBrzJJ70QD2OpSbUaCvAVymDnVtyanAYhRvtpk4RNYlCFyCYdZyYH2XJbgYi97dH4KJt+SCHkJ+T8wuTYf4zbxN5qJpNGZYNHZlklJtcrFf1oCoAaIUuvWxpgERdDE9PovOL2l0LJo1u95at5kmA8F3erqO4SJPYe5xWZY4cJ433RM31NtIylcdOWe0wXBRPvS5GUbWmTvsEiusCV8VfQeUT8emD1YSlnFvDA+B0dcn5h6chPiFc4cjMawnE/qQffhuJF/q5KvPEWwOaOHu5+Uvag2npAA47zF8RjLwse1EG/7gfprZfVzpAq1eVpc+8q3ZBUWSiFCHAaE5B97lEKci4rvM3X28bL+xOgmTzBME/IzM1W+bduYy9YyBFZ3JNfEfEixK+WRN+hFQIDYcdKvRpaUSq8EYuuRV54TCP/p5s3GbHun6BqaTsaMKemCwBCIsg/V0GiYzk4SI6VFIzqY4NFEoj2K4260/D2IT4hqRruH34YfOMytSg5/zpMY2SGabdtbm1coil8skow7G1iACqo4VHlw5KEke1PSgF5Q0fZMN4aAw4lLykawXUzGajOL1GuImgEglfV/3Ddu8H8x0eaOG65wkITFQhlEc1wSxHvxW7Ft5NIAFiWO1HTVJeaz4rJfxEX7T9WTBc8BecMGq5XdWHuL36xAdaZZQ59CVS375sc7KCd/2iVIpeNGnPzWw86KW2ohTR7/o/5Tmqb8JkYFgkebUXVbjkqo2DeiuxmnkQvFs8rCReCtjmkm6Sc+QRRBrgjk8duzQ7NWvxby4Qxc0YppQi/o67lFvMbCtE+yGZqq6BaAx17n/gJM4KgZ1dD/ZXimJqgZh1NqIbPPiT0Oz+4VeoOHeqUJL6oJGaIRiOHxLT8cwF/15EcUSqyeRUQZmPWZHGLBRug3PFMVqEdVOFxVEEF4ODimkxgcBNUDsb3YW42/h0SZ14TzGGJiizpOpXjoXIIA4b92mtmS8r6J+nDU4BNF7pomh1oAnGySuzruS2lvWUuIY2hRCUxI5089lQmurvF0iEi9JXmJHEf6ZtoGbRI+iXsYSj7mEHhCREaEyCm6XpeGNOGLLPGXvZ6gip/O/s36s8b7sjjhIl+9h/GOIqKbAf4Wr/mI2akPsjhU4uSOMyqpvzOffCKSSaeen+Y=
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