Difference between revisions of "RatingsTable"
From Sega Retro
(I hadn't anticipated more than 1000 reviews for a publication) |
|||
(3 intermediate revisions by the same user not shown) | |||
Line 5: | Line 5: | ||
!Issue | !Issue | ||
!Date | !Date | ||
− | !class=" | + | !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= | + | |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] |
- ↑ Megazin, "Letnik 2, Številka 14, Oktober 1994" (SI; 1994-xx-xx), page 27
- ↑ Megazin, "Letnik 2, Številka 5, Januar 1994" (SI; 1994-xx-xx), page 36
- ↑ Megazin, "Letnik 2, Številka 6, Februar 1994" (SI; 1994-xx-xx), page 35
- ↑ Megazin, "Letnik 3, Številka 4, April 1995" (SI; 1995-xx-xx), page 37
- ↑ Megazin, "Letnik 1, Številka 2, Oktober 1993" (SI; 1993-xx-xx), page 29
- ↑ Megazin, "Letnik 1, Številka 3, November 1993" (SI; 1993-xx-xx), page 29
- ↑ Megazin, "Letnik 1, Številka 3, November 1993" (SI; 1993-xx-xx), page 28
- ↑ Megazin, "Letnik 1, Številka 2, Oktober 1993" (SI; 1993-xx-xx), page 28
- ↑ 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