Difference between revisions of "RatingsTable"
From Sega Retro
Line 8: | Line 8: | ||
|-{{#vardefine:totalScore|0}}{{#vardefine:numberOfRatings|0}} | |-{{#vardefine:totalScore|0}}{{#vardefine:numberOfRatings|0}} | ||
{{#cargo_query: | {{#cargo_query: | ||
− | tables=ratings | + | 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 | ||
− | |where=ratings.code="{{{1|}}}" and ratings.format="{{{2|}}}" | + | |where=ratings.code="{{{1|}}}" and ratings.format="{{{2|}}}" and releases.type="{{#ifeq:{{{3|}}}|accessories|1|0}}" |
+ | |join on=ratings.name=releases.name | ||
+ | |group by=ratings.name | ||
|order by=ratings.score desc,ratings.name | |order by=ratings.score desc,ratings.name | ||
|limit=1000 | |limit=1000 | ||
Line 22: | Line 24: | ||
<pre>{{RatingsTable|megazin|GG}}</pre> | <pre>{{RatingsTable|megazin|GG}}</pre> | ||
{{RatingsTable|megazin|GG}} | {{RatingsTable|megazin|GG}} | ||
+ | |||
+ | <pre>{{RatingsTable|mega|MD|accessories}}</pre> | ||
+ | {{RatingsTable|mega|MD|accessories}} | ||
[[Category:Sega Retro templates]] | [[Category:Sega Retro templates]] | ||
</noinclude> | </noinclude> |
Revision as of 13:39, 14 May 2020
Template for generating a high score table for magazine reviews.
e.g.
{{RatingsTable|megazin|GG}}
Score | Game | Version | Issue | Date | |||
---|---|---|---|---|---|---|---|
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 | |||
---|---|---|---|---|---|---|---|
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] |