DgrRH8RkxW7xJvTGSB2hFtIw4w3tjm/gNhWOHN7cLHYvqqocASqTTTjko5b/Qxe/QKHUpmjFchCuFFOOOhp12u0JHNgjMz8qn1M85k2+lpsT365Nl3k+u6CaK3jXoOOD0xfDhwvutr2yJhD2AwhOi6rFPnbQ9AksPIUlHalip2mkYkMgwSwettMXq4ev5/ReUnXKyZtqfdcQIa/LUVJ4qltz2cLVPDeWFgqa+kN0ygO/XyVD4aIbyB5rZ72VpBq/7RiA4sASNcZKG5VWRntgiDvGZ4eZlcvKP6+R3Ivlbviw41/Z9VFLkuAuyBLG0GXdy4z8S1D+3pZVleD8LAkXAclFqgnkcoYi3Kvk7iFO1eVar7pPA95dY1eu2twHDr+JeTSqTa9bQA5vW511tNXpKULdyY/TxzS7Q4yv59jydD7uqxcUOSrlvfY1jF8qRuHh8EKdrAhAI0Vte732u1L+E2JSmfGrt3H0MIIMi5lgqXTm/vrDmQw2EnIyte9YjbLngmUGMeAMLrJYb/t5LnL1ezzTc4zvkqTXaYMPOzpsdRIRzwJeHnbIioq3fOcsFRt5aTLGIEV/gw8I0EkYAxMRKbBrYQGk/TLbahdoGpJcxJ1BqT2cQys6AFiMwXKevCfxJ3IYp928vSSBGvJ3i4TvKOKTZL1E1u4AFUA5S7aiQyqJeMZhTw1mtn57l/XfdL3Kwc/ByPgUyAOL7Q0g7Tu7Cs6yzDlKHu2xS8xL7sC0Bg5qo1INSEQdpzXKSCTS/CnxtG3E9tKPlZLX2XIlTDs4qu+QcRBhEtG4QlV5zQVqqGeJm5h6pnA4uH9+oL16sIVQMB46LqXkJgEeTcD9euv2eOf/SkNcqecP7km9mVli1MR7VufK5Zxq4wz89Qsd2+Zj0wgo
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'
GROUP BY et.id
LIMIT 100