BunsOzb2ZbCdavx4x0TjCpQSk/EFrD+UAAUa7d6bQp4j3iippeYYxN+Vv5JYNyzOAZcCxnz9mjKi37GEulzZbKIoN4P+sWDNpmAJIeDtvkCXcuXdGxaU/T9w0aYSXnfbSkHGINUxgBkQqdOm84YLgnf6Qf/L/VMH+fLut2u76hWEv9EAyu/bcphyynFawKjUWbVnqZemO9ETZEnDDXsXVyL+mEG6+BBHnc7Vv64OSVCJHjxuI/yaPBzVpEbPt1AEKSFP24hCSvJ18QoJkE7hhkGQDf/hTGJpFfW6pJvGhPg9IhBz9Aq2jxTGod7C9g+MTfEHwTl2EHzASLUcwM5ac8YbnNbsIEs8orv9sEtFGH5Zjy4mnqIrnDg7FtfeD2ppcyDHhCF/FiNzL6cBi8kVT794RHo4lc28jLL4HMstwPAXewLYf0T3ieyoaSXYCWZlV2/kuEY5Y6Y2giUFYAvgWakbmka2eY+yZxrFKiNLcAxg1FOgtAPayZTUeUMwrmXSY89dRj0BNHk+tNOHtyD/XXMPQ5d/2HeRFvW6kB25WgQo/AucPzCjSrcKuy5u0iydNVCFzfHO23jeZmp6szr3cqN8jBtAk+uNUgUxpCmoMT3dU2mR0B8iTSHs1iahMVSb2/FhwAwLn/5nndJWY+h8lEfWq5nyF0zZzGWHdiedvmy/S2f3Nx1d3BhJeFDlFRn96uaLrcwdWmMj/DEOb8MXqVGm2OFdszXuGpY4RV2aD24F1UpipwAhzgouR6SZPcZuYcTMTzFeree2pZJzg9LP3/GUFgzBWGXhtyNbwrvTRLH+o0FV7wtdUutvFpS67tcDW9dWzF8iln3TRHjog1v3gQ//WeZdAFAHmLEoatJHoeIXnPLuALmFqX6lLUe+hwqmGPZAYh5dU6OmBw9WvYax6SPZ5dk8duh6PduTa+TAzaZft6nsdRl7ntSx4Epzs5jw5F6lazrrNvaCEIe5gZfKZDvvyTtBXA0uKOtkdL0yoiuEP+4H6K48Bp2oQtdbY0vXzCw6Ao0NvQIiNu6yr7rZdFcY44Dzu0gNgdANFU2MEQ5PXvVoxyTuDWDybqHosQ8XaAQ8XLXhvyROwoLNzIWYSbUYFJB3vhEC2soM4pTXzCmRzIdZl/oe6OgqHK4uHw9qq/NaLGhAE54ETepiriCkOL93GGWD2J6vJA/fH2ecVkFlkZKZVXeCp9AbRggCatMth9gePEUh+KfOXNLe7KeeyVeJJKTMyXBnCrZqSvcwDM/os5rGluVUcbXrykM+5UorZC4wYeNrTVr9YDaLn//ciF1B4QrE2gED80yafmpz/dgPxaFTzEu+galqUygm4JMFINvG9oTZG48bNw7oONa+c/2ek2QglY0As3a9R6Y=
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