AخA
1
SELECT scenario.touchstone,
2
scenario.scenario_description,
3
scenario_description.disease,
4
coverage_set.vaccine,
5
coverage_set.gavi_support_level,
6
coverage_set.activity_type,
7
coverage_set.id AS coverage_set_id
8
FROM ((((coverage_set
9
JOIN touchstone ON ((coverage_set.touchstone = touchstone.id)))
10
JOIN scenario_coverage_set ON ((scenario_coverage_set.coverage_set = coverage_set.id)))
11
JOIN scenario ON ((scenario_coverage_set.scenario = scenario.id)))
12
JOIN scenario_description ON ((scenario.scenario_description = scenario_description.id)));