a3mgrlTDSCO5FNxc7Do5LG+fhD6mWnm58/hiYPSWxHW1+md94JxMMD1P71MN6rp5DHuO4D1/BSvy17F3ZJIpUdUZ9bVAlhHzfDZP1aiD77S+P3G/hsz6JphkP/WEsUykGzMXW3Tg4nSC2QdCiR5QAn1OxsxCxny0GvEBI3QZDhDydN08fYuSm705LdzAtr15FqPgPh6MtVEND2q0g/ZV63kukiTr7eCAguVBWm+P+7oo0XeCwCAtdV3KPX+YVU7pf8ghcYzYun9LWbEhTAsTLzFYvm6vA04yWDw/9qtDnGLpah5NcWeEZ8TPhTd50zvT2V8qQWiMGq9LEd25vNzyDDynDX0BD66fSVdAfZyeO0n4LSf8AlsiUlmBybt6PXw3mOYUa+BeuzXGwq4InPAjxHc4C6iMt/ewfrUJJqS7fMBDV24+BBXuN9rMXQ7n0xp73OlhlHKTBcvl2QcpxgIS6LQfH5BaT4DjgHjckSVBWg/vn9LitrQTO+a/1gKksOUAEgbjUEijO3JF+Pqpvx8VUaunuJqFxDXAn4DXfLkNHeYrK+OUYnsdu9tLb98szjg2kViNPUPVmqLs3ogpDl4TQwrsGWXTeoi+m6YCvg2pV4aGlUCIJCtzc+CgP8wxmJ4PdBua+Ekvh5DwxNK/Gz/0uu666oacXCdcqGwRo3LhXDZRtyRcBh8rZVNAxscwdOkMeO4do0baISJq87cG9UgmGGO1bvg5Q5xNBuoqganEbrM/EzW5J+4S46m7I97h3/Bu4qGLl2HlEtY8zN0gOEww+9Rwpa4KkjTLTgjvtHJb7wA5JxzPSgS4BxZ9tnjfyatqZtIEcXyCGY4EHvhDkq5McSzpPyWnpUtkUx0wmAz/J7oeCKAYecrxuQUB8EmgpKtfQfxp1/UFDbZTmSCKcc7qMKBLZxQF+2tAZbcALbtluUFFCzNroe0uRLwrQAuAT5RPJDb1NeBgabsUZePCmzRXEcULp+JMZCP2SmJy+d5X7482jcgaPD9vutMLLkbwqKmnVMXyBg+BzAJUhvZxVLBh9Ev+zU7C0bKtQQtrAR1RMmKHs/Hw9S47NajaMSviGqvjLehClNsh5jD4ALXg2Sy/phQyfdyr1wammY1z4OlhLdC1xzOBrf7aZ8SRbFyQngA3n6dprUE9KjVRRGBOx2UrC/8PlqP6MmOv8+U6hKsa6l5nsXaKtuQ0jJsdOEdE4spkWj6lvLO//CRGGgxqvtvS3/4P
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