+U76f06CRfnT8n4FOg898r+y57tXSP2BWapDR+4NtkW4J1idjkwHaffThREoYNLt3pg6OTD1k4reCkw6MBEIRkB293gGDYzSLJW6P8Vh1cT9UzwFIZt0P89l1dtEvhNHQZzSO6wenJ/5Tw4pTdKZUNhw3cGJRFdSCxwVE5M4Sq7gMFg/m1lDYAtpMzbh/D7Sdxx8YJJdlRtttesMrN1wffRGO6WZ8CArrkoEgSsdDE8V1tCGRN0BEfNEIyGR9T2IBaY3VmUNRXmsNRdLOy3ByxWcJQavqK2TIYB2NG25oHepk+Ve2Nc7tuqIw8fM/NFzg4RBMejzadj9dy4Jsnw4o2p1BZyS+fybIySyzq9CmqYiAJ+/HolumXMOybZjWCxtXSbo0VcexgI9Y9EfTc/vBgpiD5ifcK83L2eatnXreXh5MNpHrLiv2lxmxzbsMPajSCcPoG7J6Qv7MHmF7Zwq09haV4ospoxszzuPQbmHFt7A6P8qrvXm8O8LSYEJ7xEjm3baYd2Gf5m9wiEOL1c5ENk28v7ho8X/9fpSNgX83RKVcODI+zBX2GGmFOEqVFwvFiZhtkTRLNQfhLX0gtNXQ14tf+ygG9KdN2HuUpukI9clpMdlhfvQZDUBlSqexFHFNUAnC4lh5562MEhN2bfCKntrGJv08y/b9zyMIL5m3wZJvRhVRTOMkPhtbbWrC7BMxcRIB/NYFvh7KR//31ptt6tVF/ySVgt+j7IcM3+9HewCm6y/hDw2z9P5F2/xT2/JMCbk7eS4b42SUpMjn+k7I0Rmkh+P/iaY5opCEgVsnHIFzPpqGZ3ExyaWes8R9ct3mCluDzzEIjT3fga8rWD4SMIexgLUSCoexFfNsbR0fOtAE2lqjKK75xQDpaO+rFgNN3UuKsEgqr1y5Bnkm19mpdq6PG8hS7lWg0K78jti30QaMlFssfDwmxzhx4hdZgAy2nf7HeCoufX3LdT1KB9yw3qIz3/g91utKp+ieV3txlOVOZYBiVKcIkQOT7ofOV0CRoGn/UhOKtR9b7/TdEoAffiPFiDN6wNry4pN3lsvnGYdtHiJHYdd3JHbn6ckc4/85ZW6EirQq3+ICO10kOkdqdDpoXabJM+43P9x8vemL4ZZ4AnCFLwrsLSD3KiBRknujiM3JhCo7j7HQ2xLeYUIkoBvXxXtu2VnRCVqlFOVzIPx1XBLSHtppTeRiJaw2Qdhlz6Px3u9PHdVyUo5JJOPVcee
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 (SELECT groupe FROM residences r WHERE r.id = et.residence AND r.emplois_masques = '0') = AND (SELECT confidentiel FROM emplois e WHERE e.id = et.emploi AND e.datePublication <= NOW()) = '0' 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
ORDER BY (SELECT datePublication FROM emplois e WHERE e.id = et.emploi) DESC LIMIT 100