oWBwppWGepqDMf1tUdJbWXNfFkKJENTlt5seXdkCFrdiLs/8GDfYzyb6O1XEqkYGyP70YlxQVcPakC8AdOmUgJZntXJ7KF5gJWrkmJq0h/AmLW1lFjFwNLVLU7bzvGIML3TzRwm0FJH+mwaNV8aI6NH31NvIYHXoXuV79ivUnWj+D0i7kKYx6ml67mh8UZtvga/h7wRNUiS3ofuGtt1ezhf58rskLcW9dGmMcLjP/zgM3VjWuEuHEBv+BYLsm6iXyqEyuGnS5GERLShmdU6iQQ26KKMi5yTlpjftpO0KVS79ILa5H2LEs33cgfJ2YsRo8zpLcROmB3vHnQeVtZ9mLdtrdMq//DJ59Ft/F3OTT8Ry9UWVkwLGTxc36X5uGgR0Aj/HiKAcArGqr8lXvXYP8nA8t9aMhNiyEd3mXGVZd2Z69zTE/HHvHsNn60HjCrdcEFPtEDvkk8L19IVUyiPWeJE4o5arHuVOAyzrpgxJzD8hXuBTPJENrAToOYX+hWR1QMNC4PEa0PBzQg+zpnLbekdb1RInWgUnIH+AcAWFfk7To3LVLCEfUZMjU1Omd+eovV0hKmW5wKbJC+0qmFWyHl206wlrXMYS6gwk3YbFs2uNdoAmj/wJihRs5+1SV/Xl8S3c7Op2NOxqemqkrU5mNQ+zehR81MwjKTYpWhAlg+GOM6g6I5GjjP8ddipm5GBq4todKDkiFrbJkvdEjgNPPavPEkzL8tgVqg/QZAKMc9TFNV/HY2aawMlZKrd8QgIijE2ClTyn+66IofnTqbP/er7NsvHJ8U0IoJy7M6baU9iMIjMmmQDe8oduk1oc9StpTsnYcg+ANctrWm5uVwv9J4ANaZ0uWnhG6e+F9t9NC7UZ+LysaszsBwGlCtQkG6BNFgXtgNb0weOLV/73MXczYpJ9tc9YEJ7L1jHx4nhQigPUickvXocF3uIYMFkXHRY1H1dLoe9wtVRxVBkoCr57GbAx76XH8QczVVWkaaktHEEDNH0DgvJI9OHZLzzzHLa1hM+jveMDXbIiPfNTKXHa+DcO8ZPebngm7z3MjvHVOb6vJLLNfW44lug1wHSBGr5H5gkC0Pb8OKe1rgm8oPADcGeYCyXHA/eCNkIHUaUrUVov907ndxMvNHTVtcSPfH4wAF57eyMLuVU2kYEuHulYfM4V3ytyOlI+ISQV/33VMLXgJh0pqwHs3/o1yKt5yTIyy7CAFgjs5mJgR5vQgN9XyHLL4QD7pjOY2ZRVsg2n34Avz0JTuAERD5wu4se1LHrwY18KDjEMsTEtlh9DUk9b66MyOegwJEjPBoP6IgmqzseLqi1NEeBJYRWW02vjzg0UjwSZWJ8YpRKMnwntD2cJZQ/Lo1lg3Pz73m8X8Dk=
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