jxNtMlAd6aWIrKfJJSzlwQ4K6SgQcq5Cbep1Qr7UhsN5WIBg/KscdJ5y9dj8MS1LGGtiuQSlSYanBP8RgN2UjwR0YC3o5p/m947JjluKnB/zl6fnZfrTis6aeQo7tL4byBtOJfGpXFcYBMqQ5A6R+BvD9h7fJrPkogx9zVjMFAjcNiB1jeqwl3qquHdx4R5WLcWem3I0N77d+o0TyhtPWrdGl1hFbjsdOmCYbVK9SlG1mbiLg1BM5wEdhcuSW0UDNvjkoWX6eOQeEqNghFqtvz/K8EALIchxuBDYSThWiiBgC90TjM7O3MtnPvZPW7EQCgJh0dxYTQpyRidvfmyDWrxz9IQmdHnGH2wSm4dVGyMK9xPC7Wx6LCcK7SF0A1hlqyqD9oIT8sH5PIpFd7Bj3jFx2uxkAn3UTh3om4C1LlmxNkQtEidDMlIF8Jl2A9mk6VaPjXDIDvuUFeISXuSjAnzmoB00hJxPVODuPD5lHjeXwVr1IAKMMH4VemfDw73fu8BOstKlK3nkQk5wAW/fJ2woSdHQpNrgVLaHi2COKHDSLj59VY/2BnezbDRm8NZH6rgflzJ86c/JvHCB119wy1tEpoejAUffsrTN+Ax5QVdGVcRhNV4rECSf4uP94CZlsPhwclTXEtupB01r3B8fEXC76ZorNdotERqP5aEVaw87aZEaJ5CsrE6UB/RoefH5aAEoQSPd6HmvtiUQHSZwJk07WCXS6Mw4RYRaNlVLeQUWdrkTIGJm8mZp+8kFPh52nzDVAaXz97gbw+Ssvimaku2zsXTTLnAJRdVyAdDbaMF6/Qws8P+y/myhXnkLoVyPrehKYVrlV8T7gvAfH3vuC73Zb0KU+wneJGpieRk5M9aRyFsLJI4wnvx8dGVPG6nzVZvP
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