1WbqBsW9KHp0qcMMAEVZgEEJnnARk+RpwozXJx0jPmfKqnTKj1zDp5+6nziLVIO6WnRky22UCEAChPE0Hm3zrR5JIzQToNRek88qbcVV037ZJ13oYZxAZrcdXJ36wC/4Zf+eJ/no4Me++iJX1Cv/S9rhPHqR2pvRSaWqCF3SkczGePIdJvA1ErgndOBrDvVx/0y0N+7DrNe0soH+Eq4ikmztDFcHBH0G+VTSckpIDONnz6hCh3mmUFTcUhLHYywMO73A9GLNw/U3MrPW7lih/cXA6lvryMjfy/d9l7WbdINNUPSKM1ME8qfFvQoY2U096IXi3ri7beMgEWhnxwroxW2m+IBFecRTuX9Cca9ppQpRA1RoVLAGoxn3pMxlAdzSe1zvlGW+b7eyU7fg1tQ29gWMajIJlhsgBAfTGEgNTMRoHajA2meS4lgR2SFELgUTqfcuOJbti7oOSZ8aH3kLMBeVmAnd4TwSGQ3ZyhnpmNUby9AVQErxOxprdVeiG5SkC0dqO1+8WPrRPvVA6ITSFaCHhauht8yt9HfI+xuIYwVtifydke0ZOScWplxCx9Gdt4rliDgjEuCONXQWE4Fgt+EuWy8bnmn8h8JJEf8XipALenCFN/zXdcXIoqgSrpluVPiGbfD/DDZuMHHS8/QFcQG3Dl8PLs/TS5Y26dPwF8PLkpOP96kVocE6nK7SXq3lkKvOZhWr983vxCMGBwRvsiwAQUFFChfEyiGoqL0K2PxTqhbNEXP/lVs0WxO17cXEQ+s9+e3/ta1i3jBXpEsAHk679brUcLfHCAyjB8vJ6zltdRnbVf+2DsY56cf4PcP+yAGGZ6QeXAYrUjBG6LnwEjv2YXlVdIYEyIVPysI5A7DiO1ynNfQlexgLLamLwnrTNv8Yxg+OcHZk/T1kc4CXlGUys1g4EMnE3quubeVKTOe73J3ZA48U49WRr/hr6CUA8SLKWA4dm/qG+FWliGQWm9W++2iL1ZAmNs5wRqFv/L22OoyoFGCiL2utG4jiMJVG2KNbQWx0NKNTpxIP6TZAL8Nl0emY/Y12eRG0mwHG8MpMCU9xpmvIp1d5VyGgVRyLq/CTFpqroQoSV2yJAItH/QE97Qf8twM/GnWyCX1MothwsQqA8mfHIBE98Ljrv0LIZ4Dp4jtrz0sApjv7Y6Wyj2FA3N9iMPa8E+BYILY+kAwqy9fBcbpoNlCUQgRiUP0y0WJFH+ltVYy6J//8V5XedpmXjV4MjdVCB2s/VSMmNL9NqGU0fF461JRF31Xgpp40/A5oC1WNVKoQNWkuUxMgoLXM7eXWJ3Kq2YhqzaPaaM9zzoqk76qQlSX68qL5FuJCJWIIrLvYeTrwY7J8H2eoxdVKmzmAMi1qe6diu4g=
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