export_study_version.htsql

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