Difference between revisions of "RatingsTable"

From Sega Retro
(I hadn't anticipated more than 1000 reviews for a publication)
 
(4 intermediate revisions by the same user not shown)
Line 5: Line 5:
 
!Issue
 
!Issue
 
!Date
 
!Date
−
!Awards
+
!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,ratings.format
+
|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]
  1. ↑ Megazin, "Letnik 2, Številka 14, Oktober 1994" (SI; 1994-xx-xx), page 27
  2. ↑ Megazin, "Letnik 2, Številka 5, Januar 1994" (SI; 1994-xx-xx), page 36
  3. ↑ Megazin, "Letnik 2, Številka 6, Februar 1994" (SI; 1994-xx-xx), page 35
  4. ↑ Megazin, "Letnik 3, Številka 4, April 1995" (SI; 1995-xx-xx), page 37
  5. ↑ Megazin, "Letnik 1, Številka 2, Oktober 1993" (SI; 1993-xx-xx), page 29
  6. ↑ Megazin, "Letnik 1, Številka 3, November 1993" (SI; 1993-xx-xx), page 29
  7. ↑ Megazin, "Letnik 1, Številka 3, November 1993" (SI; 1993-xx-xx), page 28
  8. ↑ Megazin, "Letnik 1, Številka 2, Oktober 1993" (SI; 1993-xx-xx), page 28
  9. ↑ 9.00 9.01 9.02 9.03 9.04 9.05 9.06 9.07 9.08 9.09 9.10 9.11 9.12 Mega, "February 1994" (UK; 1994-01-20), page 48
Retrieved from "https://segaretro.org/index.php?title=Template:RatingsTable&oldid=828739"