PeFESN6gd21iixx6jRtbwXT5V8U4kSu59C5IfW4zzwpPiUuryVtc8zbAm0TXn8SF7cvMQGHNe98lvPMDODlflSwXg9JU+DjL3GE0N3f0JwSYAabSwcRT/rDBvGYm7lGEhSCsr2VPAlJHJt+jE2SjA+NO6A5vr6JlgLfWe6RegCYg/4sUYvYhS895aM2lonI8T/S4/BjBUBnq/gZSin3WQoHYIrYRrnMKx0gnxOJ0+rHNsNslHc0IKMNFcqBFQFAnQhW/ubkR4UvlBokEnchEYwRTnKAC5JIxPE//MwkO80FYiMx9w5yrr95F/x2yjVrlHFEamLBP2b+tn7TJVz6t9YzHgauI8evO0s5SxFbvxoiSFT1RRhk7odc2urSyCIVrT3JlOCF8B09xev2Ds8Apiv6323iyr8gT17bTD4hz60IQWh2JcouT1vHywH8qALQuRk8lnd/j7jbo/Mn3OV+ud1QQJiK+ehRor5br9y8tbgB4PH/GZBSZM78Ul0Kmf9qaWJXeiF5kpmZLlQ2QHWb2deTkl0eq56t9UAixDQcv4vdBarqVag1DwsTej15gqMRtUgxPatqSimm5vpCaF3x5Pg6hhaaotNbei6E2FSFhg9+9A9jZm1lZ/G8lDza+MgRYL4gmFoJMtMysXBXdHmS4jyZr/B3i96XRImY9Pg7vKH3aMcbqD0e50g3XWY9+8mEdvuz6Rya2ahEmyL3T75U61twqCnuRIXuMmNUpp81ABK36EvMjr28UCXJylrMhAearHBhZmJ89iiUhb570X2LWoAYHsJzrX/VNWqs1y1gzHWnMUklTRcraD03rIed2fznPVsEd6mo6P0108Mrbv9nL7brLdtx/FTOl4deTscBTASMTgBs2Xi9LvZFOz/SZeMSh+Vj5
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