7/D/Fl4rGB6QZFTqYGKkCJbPolugGiDCx9zkfNeWvntp+Ylv/UvWL/XG2Io1AMo8izFAMgDZWSDIQVwRGA7XitYOJf3fqxhQ/os98iimfJweOFtegrTvbgcSuXEVGa5fpMyn8flm+A2vJAmjxRxlYqsQ6InzMScUSqZo3bn9GtoQKJMGQTpQkpiyiNHDiF2PHhheVGGIEwvjAC+3/vuflaaR+i9ETP7cjctv45PbBH9bjIxCed0KZdMN2rEGDF52y82nM1PyOAK3Hp8pN+H1nIAjjfm76nK29Qw/DdLzqCCycIR+vMCsMnaXWkqtpFFUqpBQeuFSVucKGgssa3oYVtos4mb5UiEBNIxpU3/kRH3BLthVCn6mQXENkkSlC0te76C3sWHG3SNV2k5eVrj0ytx28hUrLXQrNF9PGQP+2zCYQmn003E4gBg5qaDNlqhIXRgPMk7vB7KYPtA7GqXAOS8Vlv1w4Dp7ao6t/FM6oR1a8a820ro2EyKXFT/dGVGHignAuhJsyuGjSBLTycYd5f/CY45DQvJZ1dBMYvgUHvqzg1s8K3PCzZ/KBbwnyTtj1QLycylfMaz7O/3cuUwfmO0WNEp4XWF9UKrjeUoMzZyZtD8U89o3JeIz6wGT6r95luCwkiiPFUR75GACF9J2VKAgaP5PFaU8F/YBbcTNGol+yVbqKHg+ACquXQXz7ArbmukRjh04RbbG7+gWGFyC4DcWL5cX1QCrDTPE6s5H6pSogP4yDTBbmr68L9DDlDDvlXQpVkuCRZ0wDYaMjoZTqWMNe0O+Vboa3Y5K1cBQ8A8zb2mxgjh9gLR4hQzuX4lFmZ0rkD0Wo1HbZ8y5IrKVzWFLJGkYUcNV2vg8wNhi7ta9TiC8y9H1ih+LRiPIy6g1ME7RTzXgiLl4g242WaZpRFyUH727RyxstQwu0eclhMxcMVgJuRdi4C4Lk7PEejmkPNDan6M49jK5XZ7aZyrzb/C00Gma/hYQybWfF9qgguk26Mrp7iPEMF7DW5+KgA+Q+UfKSBUO17Z9bA2V/4Vvg2fNFxkBlxGWbWmZiX7nPuzpkgPKvQ2mPvdYgOWMmXor+Sdr2G+QrPjARmulAC59+XxoJbvFt4K8YuQh0+rKckWr2HgdIwRiGLvFDL5rpMTAZxkDg6Byd3GJkL77awKfs/lJh81hpewaKZC7Ka5NGtaVvlhzGH4LOfaSd1QNHybW04/huM/mN2wGpx2FXXunIe6a
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