Difference between revisions of "RatingsTable"
From Sega Retro
(I hadn't anticipated more than 1000 reviews for a publication) |
|||
| (10 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 | + | 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|}}}" | + | |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,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 | ||
| Line 23: | Line 27: | ||
{{RatingsTable|megazin|GG}} | {{RatingsTable|megazin|GG}} | ||
| − | [[Category: | + | <pre>{{RatingsTable|mega|MD|accessories}}</pre> |
| + | {{RatingsTable|mega|MD|accessories}} | ||
| + | |||
| + | [[Category:Templates]] | ||
</noinclude> | </noinclude> | ||
Latest revision as of 18: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