Difference between revisions of "CriticalReception/Breakdown/Query"

From Sega Retro

 
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:
 
<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
 
|fields=ratings.score
 
|where={{{1|}}}
 
|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
 
|group by=ratings.code,ratings.version,ratings.issue
 
|limit=1000
 
|limit=1000
Line 14: Line 14:
 
</div>
 
</div>
 
</includeonly><noinclude>
 
</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}}
 
{{#var:count}} {{#var:sum}} {{#var:score}} {{#var:highest}} {{#var:lowest}} {{#var:range}}
  
 
[[Category:Cargo templates]]</noinclude>
 
[[Category:Cargo templates]]</noinclude>

Latest revision as of 13:41, 7 October 2020


Tests



0



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

11 953 86.636363636364 91 83 8