EbmhUATOjxzjeReYsk9qAG8BtkT39xjqZwJXpx7cb0ddTm/aLfGQPFi+jYm/Wr1Ajlt0wdzh0Sd4aMBKo8nUYT1SNqxxQ32L7risgB0Z6N3QfsUQLMtgqWhUB1szczOzMnQLdbhQJP3oMy9au4YB6j6O1tDHEhIS6biEqgKgDrFzs/lx67mkaAGLX9M/02wUOj/cZfNdsYNOvjEOwgYQtLrPYOdqKRmqD3csn+qo4M61ThNcXGZCRV6yPD+TyJ2avPRoI6AjfuX/369gJCxWryNLmC5xR5PPtyLWpQp/hQb6+Dwf9VedOsBnfUGAp9GP3SI74YneJsKryIDve0TKn8j684QjEzY9FR9bDFfTXYE2Y7zKjcROBddYfXdIMCkOEPCyyeYqhBr6Xv8KAwY8HPzT5DVx69KfXm402BpuoxBTnDjE/7mOD8yxQzM/N89iFzjRHi7CUkcoLpcrXT7XgWJ2/LhpxJXWPHYEdLUTnatv52xLcElqDOLC99ioDOBT90XqnzmCeHpSAY73LjE0DHFHV4X5/cjgUCqjs3my1nB9eklLqEik5KYD+2tfgGYcRPdlBQJMEdq8epWIQiXGNnYi6C+dimOlIaDiDc8Qxo1fvkoLGIZttOcVQM9CZM/1VwY4LMNaTvnndC8a7DdPU67nYTPc83e2zKEdSPGRpLrsKIDfFWWT2ZwArR85Z5xeDBE9dRM4SIvzW21aWMast+B1ZSLqHZzcA+G4pyESfPHpuotEUjFHqrp6SQlaUAlMG5AfemVKuQBjbi7+qs4kBq6IbO3ip48zI8E5mOW+FvQHK7aaeOzIrxc4s6larWckEWgMGBcmE7RLJFIx7SwyN1HWHhfnhcZUE3Ks/kBtWpu4o4DC7jmR1UM2o5HPbJ37Im71TrN9BO519ycbAA+dqATf9Y4j+JEG/JlMxq5Blg4ZRXBHIpB4pJIWYDScIWwQlXdZb/VHJPJIy9Dr+bgbK8TqDwXliKML5WLKMh09Q3puQ3wWdRpc1LM1z3CZ58kQ7nqPZJFad7xYDXcsQ9qYd+jk9mGLtghMouWyl2/2kYpLOL4bYp7zdkxaQu2EN6zmKWEXIdPhgh0y+TuQTK+cN4wy/GSCgNJslhTwhnU5ZyzWcnzodIpOOdEe50ulY4wTbPWTZJBEM22qaSTpJrkbjRM+tZmRaOG7g9pKOdTinQgKoLZ3rZr5DYU5eehIXLhpt9oqmCaQ3zyQwVkiiDdZZHNwlUrQ5PPJ6VFuehsJuzeiUM4+XNzxija2AMuP5Tv9aiSAGhDEnh4tEScEBOth18qylMh5Opd16hhvVQhb7kGkqDYnfGQnJP4SK/3isQ3CmJoFf3dUYr8LuKGKx0nMRGsm4C04FQEmjzCwOAU=
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