How is this expressed with 4.0 join syntax

    SELECT *
      FROM a
 LEFT JOIN ( b 
        JOIN c
          ON b.c_id = c.id
         AND c.code = 'THIS_ONE')
        ON  a.id = c.a_id