uxfp2Zvn0Ta4Iduo+4GgZnjli5UHvaf9tm0AIRwjRdkQB0aOn1GRpnjxv3Yp/ukXZJGrvvChutTQrl/BYetFb2qx299EtC+kGUx6baQDOeYgGU6AdlSdnyBQP2ejig0yzEPvGKVHZCgxLMaa2XXtK+PrPrvQ3AxipeOvnXd//y9vA71/FVN0Kao7eUncEId/60wzo68+THdJmhq/ztsol9GiIe8ooMEt2dvh869+3taPKUkMFaop+bkf8zTHP3pc6/Eg20/Vw/xY4ON8jOfSUA114ZXHc/80lBS10lita+nuqlMGYJ0amoDaVf/eODJzTRwGXDqaTmALz1OJsTx6vpjWpoCLG/aeTDPz5nUiy3m0t2IETAoMc4mZ8HmZLnEMUPX+aaRWnfp9zMUzXyssjjcDtqQY88z7CT7R/yNV+1ts9e7wDWujAahXE1LjHf9iUpgDvhO9RUse1KT1MFcZ6jKD398RFWSN5oigHv3mjPk+H+PINstVDgFylA4co1XTA1vZjsfpE1ioUVrn2+YC37mFhV4YVPfC2uR0AnpZIIH2C8RtQTAFlp9iENk+U12RGrumlgnKyjxaKJ95HUvxvrwLQ2qXjfAW48x3CkPcrQ+fU237Xv/W/fsN95SpqYM+0P281beh7d0tJRKUlroLa2sqQIPSH6beZNgFUy4kLQu2dvyqDJHrc0Kejf6S9jsnjjchWpOQyCbAFQmmI5bS/3+a725pZSw36IrJocrHEneGsJKsslOsXtW3WrLBhBas/hyVcOqhxbmTcnTNgOft/kX+qmeRUTuQgxLmyTqLS+qiVNVUerSHcTJgUL4SVlVkejY9rb9pVnDDoa1/fWUXXCfCG8x2tw4oOK/NY4QfO5oSVjXg3GhI9YHC1TqzXQWGdyEv4wBM8VSC1YnLjA2bMx7ENmOlvH3i843hlpFLJI2Poik1uofadY/FBsmVGvzim3GQHSVQnLES+lPdSjRu6Ym+OiNiJ+k1zOnNXo9st49bs9JMVnaV7UsQZNXvodGwR0aKL5/9AdBlYJEexhLNO+xjzILcSLFt0L7gVeb3KJTEjAvY0b/1HiPqRpQufxpt/JTrm9pU3UPGFWpvPoE4PCUAeYJnodkmRuYzv3bshj8AyGCygcqLhbEXhNE/h4Jz23Trcu0OH+RwScxVJzwNOWZgc9WO14dCNxEGVW0JXiJ18GySwnNkajEMvDczwynMhFDb+74/ff4P30AbUNP0j/HkJDAoWzmtKQQ42sXSzTcRGiIv+4ylWMrcOyg4NChoA+q9M6KBOZZpUjUpjcv07FbooZ7T9WoknwWgykqxz2KX8iL/LFPvn9a1yY8lbkoRDQ+R/oG14LlZrw7zdiaWplQ5SSuSPMEyHw9vjsI=
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