GuAIaUc+U0+yKkcdvV+2F/PsnyGXEh1Et+wM7BSaet+a9Uw5U7cs7U99WTVRn0HlnKqzJ6YT16k/uODzUhFSXeQ51oyvnFKjcWewrjVwstCOq3DdbXl9gZ+j/diril8jjiEXVhp8VNnJrngprrtkZppaQOYVy0HUq0lap3wsdubS3VSeCBdXbLPD9iM7pHYw9cusXzB5IVGkkGsYTmbZQNO7agVSfkSR6lzNm4ZAnrCkuGoTOebZvyCCB2ST86MYgHpsbQ//4k54wrBrxi308Tyb8YDmJesJCvH2K4cXaLem8JWEy7+xaPji2ElXWvLRVQxV02QqEBceRqkSDqfrFZfBQcf+ZiDbqB00klkMrjx+AyeLvq58PsjJyI3GwyD7lSojK0vIxpkFmO497GI61STumIvhfUT+XSpXKj1GvuvFXw0oLVoKFX8U8/7msVs5au39AZJw7Xz0D79vGK96Io486D2SKpzYWqx103JXJDJvXW64Azlo2BkamuAaK14KMcjdFaRDAosetKEgtxDl4S3+R/4tDDkaxfhV7haDWXiIkpbwQweY5Qt7SBt5OG6wZWT6BRef2zGD7Quist66YitnxAmmpY8VDyntNzuivMsCEROrSBpeqBed9NHOSandWXCz33906RO9awYxcLFtH/VGVk6Rg8G0GnV+fM9a1ZbeJKQHd4dDOOWnefhqx9sxJTzr7Kuu7eDXtLR8MWds6BtZ29AcPdapB+ifYhlxPcUTexwd7fD5h18pqIbkVmRuMKLz+ghThTde8yGK0FYvlHsAQ2kD7IRN8bGjrNxvXaTmZC3zE89kFWzmR/dXrjYaYnBAcVUxiW6l8MhuXfMScLSXDTozJmNk0IGO/JcsoOg+8EpDPQKM05q+LhJXEWLgjYlaTx3AzhpJe8qFRLPs2mugo9n/p2vDJschZASCVsEdvpiYR9/GAGtciXYm9xLClulR22q1jxKmS97dIvfg7NWlwzmvd1sqJA1djpCGO+5qmwB5LvddlevpnDtnFmUOCGnvaqbnCb8W0r/QGdiWsbUJdlT8/euZ7VY27/tNMo02t7dg/NXvG/2+pE0dabFBgI7G89aMY25xfa5ZWWceuHdAp7A67fYnBqPjapvIsTlT63KuSlR4/sgyq9MvYhAR1HCtpWDM114dmzF+qIoudwDkn8fDVDHzQiaNfZW0v7xOrkf7y7gz8XvGEEAidv83866M6nrVIQxmPVukysTrxvgZIlIEIOqvL+NnK8nB8URy3H2mkNPiSEADgiRCRdkrecTJjJCSQf5dwem4Z3tL0mqaqYWMrz7euIEa9yHHe8e+JvztUAo976nXReorT42T3cU1YObl/KmnJbPD/ZLSvIoWwNyiochQ13tCYtg=
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'
AND (
et.residence in (select res_id from utilisateurs where res_id > 0)
OR
et.bottin in (select serv_id from utilisateurs where serv_id > 0)
OR
et.msss in (select msss_id from utilisateurs where msss_id > 0)
OR
r2.groupe in (select res_groupe_id from utilisateurs where res_groupe_id > 0)
)
GROUP BY et.id
LIMIT 100