export_study_version.htsql

/do(
  $id := top(study_version?id()=$study_version).id(),
  $mtr := /study_version[$id].requirement_list.requirement
           .measure_type_revision_x_requirement.measure_type_revision.id(),
  $mt := /measure_type
           .filter(exists(measure_type_revision=$mtr)).id(),
  /measure_type{*, 
    /measure_type_revision{*, 
      /measure_type_revision_channel{*}
    }?id()=$mtr
  }?id()=$mt
)