kGBdJRSEZMZ923d86tajM1Sq4weoSDQWk8eJx/5L4wwtp2RU+FxJ2JkBdi4JCBdQrZnSye1LM6GwhXAzp8bwtfcwyyGplpGhiMjEWZ0gi4759roa1RtJWeZ7bu5ciGeG9eXNbyEy790XR7eqlMM/2iXNTlfJV+nY3JOkigkb2iqpufR4KLt9jxanT81eO5+EFkZurvwEloIeRkFsxIo7ilcA1wifgdG1p/L0/bJTqeJI5ny/AGv0D3A2ByhjDRzcioJRjq2jAfe3mDwzj3GjwvCfBrrE9RUQvV7IQIybAZu6Vr6+4fJ7+atF6mGa5Fs+vfT4ElZ9/VPKAcA5ezLLmU7+aSZhugZNE83cVdkO/p2bNWY0SrctalUBqqt6mFA9NC+YHYBagJQ0SLfS3tsI2jk2ZmucKeHZNL05wdYmiAwD1NxMGiPAYGhOZ1K7sABDjbgP0cPN3HBMeSISXOUtohzmZs5ohKjT8vep2ZC5CkMRkRauCnRu3LppaunQg/5QeH8mbab5f0iOgFqlT0jopFlFf1CYmgm/6dxWLI4ohKIAQKEf146Z3DApTOpMFOsUNcE3eB1ZWoQ0tO8OftkqGrwGy4A/oAUKypWm9QyqHQ7Iavd7+3VhnmdxEwknxe9TPt5QGOXiJHojp4gUiLzaBvxyNr73dVODadsI0T4/VnAO0zpctNeQjdKdTc7YrWN+VRTrfTBRAIH2GQCPEI7gRFVRonMg9bP5zS6WNiyWzlCH1IijS0MXLAX4ukBEMdDJSNjp6BdQFy6MPuzmgHjxN/kIVh809WbulPcGfb0gybgC/UhYuKuemfnB2YSk9OWUYmu+6vTZ8iq5+pr+Fw8xhx5VgrymMN5SNBbKpyv+dpbxotozU5GjBvMq4I2mDeQfO4hO5gITDeBCO6A7gk3d9zZyoyXYBSutF0k2tYChrSPgAfuEaG/NCJqfmpNHc4/CMj2wd9cGEsU7v7B0lZ+Pfx4iJjwljZ4o1m6xXn60H3+06YJBAXhKy4+WncXMlHjIQxfPQwdqyVNwaMwqs37kLfF2fVRlO7q0FdeW0lqV4SG71D8Ri80gxFu2O+E9RuMPypEwXKPO3OBO8buZiFuffEgIU129O1BaoO5AWBkPCuVouOdBeJGaSaw/8F23g7MhLIxFIvV4RHF7UiL0GPEmXRSAtI/4Tn2HrvFybJGVcvnblCt6jFwnD/j+BJr8EYnn2aeqdSm8uBRaHl/43Zfxu3iqdhgDDr9sef10JMSBtYEOFE0kVAP9xfq//K+mou1bsHxnfbo7WniLJOzxo2ZU2/+f8jrVmgUA70nEF5xAdMwEQXmoe0ry3zZbh9ch/QIGdjKZj2dZqCGVy/FXRLlPV+uDZgI2XQaohrqFn5I=
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