NhApAs9W+qRV9NOVIveZrITDAMoPr7XijZqbInUsrE6T9ZsRvzmEbXZD2nQftWM0emBFpv5Sc3DPB9jWQlBh+H1iEHPOXRiawou5jyAeQZ3mJ/hmBe3Li0ky/J39yNfxRAYtcEQjgJKOy1SA7DPlEms7rY79f7WkGUw0OMvu30DD0nXkbKy6t1eUeFH911Ln8dDQ+QCz29I44C54DZ3sF138b6WDCpr5RyaAQYDbRql+OFR0akuvRg/B/7T+0WdEEH/ODarYwSm5MsRqWUvE4G5T6YfhT54Mq4fjdn3NullySw7OwvPCridUFz/7vmhZDosAJFIytMeWljkPoQmNkLx0RYbrOFRbneloY2y8OUcw4ge+MncP4Src3Av3ZJtPOCmWFBB0RDaF5b4ovBdp7BveoLDTHtLjqbQafGFb/u6OiG2pisQfI+ii111mSXmF5Hw/JJ8pIam4b+ljVK51Py22Nz+cjVuMGdEbZh0MOowUZGlHs9ryMEtw82/tgBYbsHzr9kJSZRKUPBmzH1i2PDKE2Uu1lrTvnH1AcBgmS6zzc/FNjzwVjGT9VziMPNcazGchLHL/KoGjbX3mhHDvYyQM7MMuEeI1VcQp+PPDudfULHt1qCfOBJqCf7N40HLo4Mv8e0rvpgEwZcTKR62EQ/QOhcDWF4OIR3qLjWvjP9Kw/zHfFpv6Fmz8GZXwCyQxSV6MqVWLqeaUgAnrf0+uLx8IbN2kmpMU8qKq0YFsOy783aekBa0SGe060uAXaCx8M/1Be5UgkTU5SnXKj6q3Ixy/2Q0rbFjjcs3mpR5QbvUgF5rRkU5xFweFpQFTXBANT3h4FQ8fO7fSOirjMYWpOsYlc4rGk3fVKjjHU4BwS03/a772nxwzho+FdPGVYYHn2oHt41hy5XdwMeqqaFI2arY7pBRc2w0JqwfnTf3aHHh90eM8ViERXl75a1D65wU1YS99XiHuBpieaCJD1TYZOSYHfAHWGjUGA1Ju2KXGL9U7ubGFFHOJ8uBEsTz0uOiJDE62mfepX/tKuQU/MQ4CV7RNnTS072niH7X7qFGgF7KzBt74EuTG3eMwIlrlTWJYJk1Bh7YeXVNd5pCPQp9PuSAm2qvMonM4DeHbYmGuhQ0EJb5V2zclebRjbCVQv5T1H9m4+RuxVSuCRq6tvFNigH+E/tn6xGHJuN7c/yiiYfnjTFiDgAQsBT6MD5NqIdRhqz1CwRAieZTlAbBXVlEVFsVpAEy4wLQpMv0prrq2UimYXQKbqYUxyO1OJmwTuY6eKQJvVTUowWNUrDq+YV037FFPMQ7hpR7pfTkQA4DrXGL/ky/cbzPPW1dhMi7RPFrkvbVsTeVO95BK/7gSp1wZyLynPMUw35ilyzLxa1w=
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