e1u4c1huOUgAIV5CNBO9VsA1oA5avU6AoDDS7QXU9fDmC6cuLZs504CfZOAId7sUWXx/hzpoB+JYwXVXh5IWcDciE+pJ+QBmeG7YhNTZ0MPy0hI0vnw7SxSVkw01mqB5fmciLeXlj/ZmwSqr11RDz8d9Cbwz9VDOcGb3VxJ6byBMnYuZ2BuXQroUNtBSE+v4wURMtgqVRMt2RhKiaJHQ9urDNzxT5Fwx47xOD1DVaPTC0is+tlvs3nm8Pwz4pAyPiw8Ww36I8w7TA+Not0KyM9ni8Dx23COnKPbFTK8PP7HuivpvFgvGS/BKVkBMPGxlhsVjl84CgXDUf4x/3oudzJ9y2Bz7t6KR9ZDq6oYk1Al3poiE66oRY1qS/5VlWVt023GjsDM2TpGSqM6qqqznGs9xNblOkKKRLbzyzhFg0NUnZ7oxZUkrmOoI1iYC5vb7ZCpPvI41vePiBOFUzQWs8lJ3/ypw+WhtccAWmii3jOv5R66o/hcuw7fgcOAWpDap+N7XEpgQEMWJauzXMwIdIxzvYGSFYLCITiFT37UvYDwj1/Mj7fPNzMmd3JGom8C7FtlApb0vIo16L/w9Zsf0W6RyfJX5WA56FZdamaMwW1YmkG9nnm1X5Pm6bVTW9bBMnBQlSHVqs0ReZ/3fUC6iy4ecCx+vBSngEMvpLb/cxUMYnbgyGt0EIAT51ET1YzLqP2FIGfUDhlHbd4gHnlZmcT7j3hzx+kUdsmt/VMArUzMSYOCJa/rDkIAKQqZl87h0lP79Q3hISa8yoW65dUOpZZAhhcmOfOKET2/WeTOMvfXpZPxUa6BLn3ticOZtJk7+0BgMQVRC+Bi3i7mlCLwv4crP0VqQeTXiDQ8L2E5wNu1VFjI9eZne+NbwNj+jRzdB6aDAuaENJq0AYGbSpsd8778ZeFk5b2YzC61ohdW8NqweldV0M8P+juiNr0wdYeAHMdowQGRN6UvWK7NjTEQyEoWJ78ajPLnrARhci3mrHa+GDCplWVLLUW3WItaK1gbySNsB9yGhBCb9tLZvEY1saTZe4XWP9heO6KauOLH8qIoEcDAXdd2QjDaX4niTFJDvHu81s1Mc5n3tF/7c6Rmy1Ek/tCvtg5nrZRlZKjqD/pBZ+UqLgYuLO5+MkuSvwGqvjSGZ/eM1U7XlolB47DCzhZcaL0YOm75sIY0Xeb5fYEiNKOsuxZkhLiQXt6ol8/Fs0FTUDGp+HpPdTA0M5WtBpls+
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