Difference between revisions of "RatingsTable"

From Sega Retro

Line 10: Line 10:
 
{{#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
 
|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

Revision as of 09:31, 10 June 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 [6] [details]
57 Mick & Mack as the Global Gladiators #0102: "Letnik 1, Številka 2, Oktober 1993" 1993-xx-xx [5] [details]
{{RatingsTable|mega|MD|accessories}}
Score Game Version Issue Date Awards
90 Six Button Control Pad #17: "February 1994" 1994-01-20 [7] [details]
80 Conqueror 3 #17: "February 1994" 1994-01-20 [7] [details]
80 Dual Turbo #17: "February 1994" 1994-01-20 [7] [details]
80 SG ProgramPad #17: "February 1994" 1994-01-20 [7] [details]
80 Tac50 #17: "February 1994" 1994-01-20 [7] [details]
70 Invader 3 #17: "February 1994" 1994-01-20 [7] [details]
70 SG ProPad 6 #17: "February 1994" 1994-01-20 [7] [details]
60 Fighter Stick SG-6 #17: "February 1994" 1994-01-20 [7] [details]
60 MegaGrip IV #17: "February 1994" 1994-01-20 [7] [details]
50 MegaMaster II #17: "February 1994" 1994-01-20 [7] [details]
50 Starfighter 3+3 #17: "February 1994" 1994-01-20 [7] [details]
40 MegaPad IV #17: "February 1994" 1994-01-20 [7] [details]
20 CyberPad #17: "February 1994" 1994-01-20 [7] [details]