Difference between revisions of "RatingsTable"

From Sega Retro

(I hadn't anticipated more than 1000 reviews for a publication)
 
(6 intermediate revisions by the same user not shown)
Line 5: Line 5:
 
!Issue
 
!Issue
 
!Date
 
!Date
 +
!class="unsortable|Awards
 +
!class="unsortable|
 
!class="unsortable|
 
!class="unsortable|
 
|-{{#vardefine:totalScore|0}}{{#vardefine:numberOfRatings|0}}
 
|-{{#vardefine:totalScore|0}}{{#vardefine:numberOfRatings|0}}
 
{{#cargo_query:
 
{{#cargo_query:
 
tables=ratings,releases
 
tables=ratings,releases
|fields=ratings.score,ratings.name,ratings.version,ratings.code,ratings.issue
+
|fields=ratings.score,ratings.name,ratings.version,ratings.code,ratings.issue,ratings.format,ratings.pdfpage
 
|where=ratings.code="{{{1|}}}" and ratings.format="{{{2|}}}" and releases.type="{{#ifeq:{{{3|}}}|accessories|1|0}}"
 
|where=ratings.code="{{{1|}}}" and ratings.format="{{{2|}}}" and releases.type="{{#ifeq:{{{3|}}}|accessories|1|0}}"
 
|join on=ratings.name=releases.name
 
|join on=ratings.name=releases.name
 
|group by=ratings.name,ratings.issue
 
|group by=ratings.name,ratings.issue
 
|order by=ratings.score desc,ratings.name
 
|order by=ratings.score desc,ratings.name
|limit=1000
+
|limit=2000
 
|format=template
 
|format=template
 
|template=RatingsTable/Cargo
 
|template=RatingsTable/Cargo

Latest revision as of 17:06, 23 November 2022

Template for generating a high score table for magazine reviews.

e.g.

{{RatingsTable|megazin|GG}}
Score Game Version Issue Date Awards
91 Mortal Kombat II #0214: "Letnik 2, Številka 14, Oktober 1994" 1994-xx-xx [1] [details]
89 Ecco the Dolphin #0205: "Letnik 2, Številka 5, Januar 1994" 1994-xx-xx [2] [details]
88 Defenders of Oasis #0206: "Letnik 2, Številka 6, Februar 1994" 1994-xx-xx [3] [details]
88 Micro Machines 2: Turbo Tournament #0304: "Letnik 3, Številka 4, April 1995" 1995-xx-xx [4] [details]
80 Sonic the Hedgehog 2 #0102: "Letnik 1, Številka 2, Oktober 1993" 1993-xx-xx [5] [details]
78 Jurassic Park #0103: "Letnik 1, Številka 3, November 1993" 1993-xx-xx [6] [details]
72 Taz-Mania #0103: "Letnik 1, Številka 3, November 1993" 1993-xx-xx [7] [details]
57 Mick & Mack as the Global Gladiators #0102: "Letnik 1, Številka 2, Oktober 1993" 1993-xx-xx [8] [details]
{{RatingsTable|mega|MD|accessories}}
Score Game Version Issue Date Awards
90 Six Button Control Pad #17: "February 1994" 1994-01-20 [9] [details]
80 Conqueror 3 #17: "February 1994" 1994-01-20 [9] [details]
80 Dual Turbo #17: "February 1994" 1994-01-20 [9] [details]
80 SG ProgramPad #17: "February 1994" 1994-01-20 [9] [details]
80 Tac50 #17: "February 1994" 1994-01-20 [9] [details]
70 Invader 3 #17: "February 1994" 1994-01-20 [9] [details]
70 SG ProPad 6 #17: "February 1994" 1994-01-20 [9] [details]
60 Fighter Stick SG-6 #17: "February 1994" 1994-01-20 [9] [details]
60 MegaGrip IV #17: "February 1994" 1994-01-20 [9] [details]
50 MegaMaster II #17: "February 1994" 1994-01-20 [9] [details]
50 Starfighter 3+3 #17: "February 1994" 1994-01-20 [9] [details]
40 MegaPad IV #17: "February 1994" 1994-01-20 [9] [details]
20 CyberPad #17: "February 1994" 1994-01-20 [9] [details]