Difference between revisions of "CriticalReception/Breakdown/Query"

Latest revision as of 12:41, 7 October 2020

Region	Version	№ reviews	Average	Lowest	Highest	Range	Views
UK	All	14	85	72	92	20	Very positive
UK	NTSC-J	1	92	92	92	0	Very positive
UK	PAL	11	87	83	91	8	Very positive

11 953 86.636363636364 91 83 8

@@ Line 1: / Line 1: @@
 <includeonly><div style="display:none;">{{#vardefine:count|0}}{{#vardefine:sum|0}}{{#vardefine:highest|0}}{{#vardefine:lowest|999}}{{#vardefine:range|}}{{#cargo_query:
-tables=ratings,releases,magnames
+tables=ratings,releases,magnames,videonames
 |fields=ratings.score
 |where={{{1|}}}
-|join on=ratings.name=releases.name,magnames.code=ratings.code
+|join on=ratings.name=releases.name,ratings.code=magnames.code,ratings.code=videonames.code
 |group by=ratings.code,ratings.version,ratings.issue
 |limit=1000
@@ Line 14: / Line 14: @@
 </div>
 </includeonly><noinclude>
-{{CriticalReception/Breakdown/Query|ratings.name="Disney's Aladdin" and ratings.format="MD" and magnames.country="UK"}}
+==Tests==
+{|class="prettytable sortable"
+!Region
+!Version
+!№ reviews
+!Average
+!Lowest
+!Highest
+!Range
+!Views
+|-
+{{CriticalReception/Breakdown|Sonic the Hedgehog CD|MCD|UK}}
+|}
 {{#var:count}} {{#var:sum}} {{#var:score}} {{#var:highest}} {{#var:lowest}} {{#var:range}}
 [[Category:Cargo templates]]</noinclude>