Y+eCiA5LjFN3L8zIYkwCZ+RMF/GZ4HdJ42ntTwp4YGGvJ3fopvwGIYCsNXuQi1DFbNQUmGOk2zdDQ8F4s56OY5XtDqeS146KKrS8miZnVDhwSCtYjdw9NrUn9dieCaLHdezQvzG9ZVx+JzlN5/qWOSNIZg10hpb6HMq8joQFKVqaTEegVYez5HmS0o5ZUIgHt/Wli4jOJXXQ+kTytvgV9ISKFHuH4NmJ7KZu9+1lqJaY5ukby+D/hhcvzblpUou8we2HXzx9bw8S/hk2cdBYiu7feJrQO6POtJFB+9uJce69nYuxTeMI5m7Esl/r6T8GFtwa8D48aiOVtjJzXGTRtjh7RCpOEny6ux0nK3XUGETDDIuqaYoXWAlN6mS3Ge1Wc0Cwn6O0vAG6ua9chduin+s3qoQZu2DN3lCnbx26w/kUlfHLw7uO5G8Xr+4NFB+Potb3EyolCP5GiqNf40b3K8AsPmZw1r/8F8TC5z39rpumt1yl7l+Ni7n5ZP7s+PQYY6AeaqKjpW+vQcAq3WQ7pl+9Zyey4jCBAmwigV87nEULIHAmBGTN76WqCd64P9DgdMRbCydhuvNXN7FVvlbD8Evyi1Uc1QXch7sG3AHc5aYwV4GraHnLKIhdD9kjA79NOvy4YET/Fkh3+aZu3oKGhSavrWS0cuTEsAwwDYehBkWTxkhpQAGDnA935GvO5xPuuaDzlOk8upb4WBaGiV2Uv6Dp3voANf+z94ehXj6ggvAANx2m80n50eWIWNQvi06B8Ojke0cSREbOb+jvpdldqDiwBQJf2vfFa6elswzcup1pvxEeAMABbDlKKjfgxC6f9znYXqM5//CDD8y/ZJH6ycU3kraYvSSrFHH9tB7O7PaHjvCi+7LTaCwWTIBtpOBjHVKbSwpOQAmkgtO0jlQZ3oIBgh0KQDqxQeOJ66YcJKhAXV5zp1d69OCi2+gT6xZ0LopVAfbGL6qujY6hFji3p2Oj64wu1qgYUjQHhyu0yraz6N6UEZFcjjYYkTrKm47YF7LfQv7iUNT2wFOovtUsMco+Keyp5NdrqQNgUfVSm2+HTxR9wLXm9KQaCua2LWhUGTLkG+wEW10ZJOP3XA2p7f0mrAlO5p95wvuQyJsNiggqBsoDHDttaKhyocrCurDgcK1urN9JvD0uDGfgjmaQyJDmafPT/TvToCHt9c9N3zMh8mRXjaJFaCgHy8myFlDr1Tjd0PJVzUgW5sHGXOHee/t1D2ukYpifv9uQVsyMhAqBJ23CN76T4RGndSe+lHhnTwxdxXHXg7qfihGAQs/pbwSZnCPpLNE4wIoee45Aje+bZAiiescRljHinaoAbWvfCiTjRqOz9zDdIdI8EMZ4xgh9FvwAIWfIo5v3Q+8=
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