Oknpu6NsT/kh7zAC9WxIAQo7IJuXkPU9xec5Q+sBs3ivh2UYvFRIEWjZG4g/LCcABnpivUBBCVDBDclI43ZfIq4ZzaqOXDrEUZggkGGvMRXjGQJO7UlK1i7L4GZqFObhpnwJLHBhsYrLP8xolXnOoR6XMmIe3q96cEM9mDcCZmche5zUo44ChkUGwlCRHTGMOMcttsIzsEkliW6PQuXCETf/ePg+wh6QoWEwx7ou4AmmmOyktFb/oD9VwAhgGN9o6y5aB4EnQInt3GIHLqjK935FLYGnELCo7/Yth5UfF4yEPvAAjteVD+Ok9j4rt5316Xb8uitKKu0Z8V8UsQh2SmeCgNkfCAgx2mNZAWy83yo4BiWvPhfm53NDwdf+bBeeOFG4mDToZQ0tUD5fPyB5nWBoalhdB4/6qXY2QB1WNlAZR/hJwbtvdW1WcYMWu4AnXF75amOnkIZcZKLv5e/bh/87L/unPv7DEB1Ayc0JSPby7cXIbPMbWQUZ+LV7Vm/mnrlZO1aT14J5bezxUiIabVa8mdGAl/PW8VhuP8X45y3NRLc+Lt4z0n0HnC20oVSc/KnKbrueyPLjqJorjB0brQPrEu6JvxTYGCPq/TOhiKDhKIYFnQf17nymzJZKv/CznUdEixU+KMJyqXlRepD/pF3gqitw0KKcAx2lun+k99pxhuo1jH634JoA0uVAJmhsz+Km6sfOjuSOaWdnwtphd2Ti3qezGPKr1cBchV4+G3XqVNnL2G4Bc4sGvH46RLCZMv3JW/D+G12LLi/+KP/gwCdTszD/XdU9jZUkVvfdoQLc3mhqzOUcFbsy3+2NCReyABLDd7mK9hdsuCvkY6v3HLTCAZIg8ZonawXekAxx570nPsyKe2epqSl31wPtUMfENNU/0HPZcD3SJAQAtJbZG5ljLy7SSQ1cFejHd6IBua/GZJJhPOD6/kagiu78opNT5w9iY+252PsxJTMNAP3mT4BIOn4sqEPopbY7ySt6v9P5Xn9iDANPvPy2o529Ff4ZuqcxGIFW+gGnZN+ohOObwmfAl2qgWoSxXG2M40p4DF01qP7uqCNQPRU54t4bc/TwiNXy8SjTFzNNdGiAoU/7O9vVYf6SqixFevPeP3x8hMP8VOO4MtJXUnX9FiBjZsWnoe2qqi1ZeVM2Vq6Iysx1HirmkgymDxw2HRv4QcCPqWegT3JSPndzXSDudOgGYNNYY2sikX6p6SKT3hWBimedtrtsSacmOLO6YoEnENYxiRj/dylVdtR+BcwZ7k6DA7WGjnFM4DevLGoccEVjC6ahixpVSHLw+7zHwIxXNZoZTNHIEELgknPri1BdtEV8+EfJB+2ZN7AaUE25A6Mcw7pPPiDBykuk7LrF5kbpYes=
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