hc1vf3fkWyVaMu63FmyN5aIrnqqW/IOdHOyFBwu5Qz0aHkBm+zuh7p+FfJ4F9n+kHuD5gsZUsvYgPDc2Y0TaMwn/MP8r7RSraJTTuNMJ6K37Em3x3DhQlVujZOpAuzO/wZxKZ3b8EmxHOk3m5z5cNrlqrhXPCCFpdGEQgcPlY0TOMhboDBr7jgcJzruitVwgWmxs58nbeiAj20kn+igacqcxiNCHuQpaRg4bD3HAAAsYvPzryioFgS81WkSs+iuo0Am0rZ8bGGpU+62KkdZFlv/amIxMhA27fYylvvkscM2sVA6/sWvZk/jHP2DVePPPfP39uI+87J1Bp/NvgWCI0GJcrNG/WEDrp2YMq0MpxDMJzPFfT5XEQsqvfiU72cBLb6wxA7dNDiyuGiTT72mWDh09xqEzr8XJ780D2dU7MLzu35LblK7fcXN4ZKgZBShOZSZcBhHAVMcNa6V6C3S2oTa1WOU2D02mxpbGMyWkT9XWNVn80+GKA+DYm1pz/P/wB7EO1g6uGDBXebIM/05cJgQsuVNXTrYwGISmyozYo3VeiM32+K+MmPqlVKrXPr5x6Izow6EK9yyw7lYG5coNxXSRIRSrMebd1u5rqDCTcRXa3vAB2DphFrkmP/9FBClIsBcXL+0UGa2f+hzaVRvDQN+o/tJ8MnzWMNpJHlpOkBBM4WZF8zlKDEAz/UUsNpAt3hFNN++dQx78ByujpHeIh/c1oqdnxuz+ZxsMN14lfal9mPrWiVzKyLWkufNgFk51vgHQPZtm9BVMuX9ngyQ1YswgxkS5bf3UvmN8PYWO8pflj0+Lbc4Tsi4ySGowV0NGFL9iBhNYMmJv8VmSzF4/C/Mu+9ze9S+fvand+fxFIcyRni5ncIKTc6e24OPAeRx+4vq9iobf8rjG5Am+UCC0Q1Q/Zo6mYwG8HCwhhC6Gi6haZ6oi1Jcf49YanbhYLSvCKKBUPRNyeNhpbkicAc71RiCXbDQyeZAPmPyoCZMTdhut0RSrxSrlSynPO7YCD6K4uNc6LaNcrhaT5QpUqY3pdKpVVh+W6p9QdYO8YAytTzDeOL1rj/2I2LT6/wD3ZLE0Tq+1SUEU4eJI/M47xQto0g8FJ6WvB8STgQg8saXSOBK8bmqgtlbKf3zDzheYX/gV0WMGDjZeYFQ1nUfXh4ax2Uqu13q31aynsu9DZTBHqX0jnkwJkIKoBDAKh9feYJwTiSV3lZLCN6VpuMwH2/rIxo+L
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