RatingsTableAll
From Sega Retro
Template for generating a high score table. This is for Sega Retro averages, i.e. the calculated score based on all known reviews of a game.
e.g.
{{RatingsTableAll|GG}}
Query: SELECT `cargo__ratings`.`name` AS `name`,`cargo__ratings`.`format` AS `format` FROM `cargo__ratings` LEFT OUTER JOIN `cargo__releases` ON ((`cargo__ratings`.`name`=`cargo__releases`.`name`)) WHERE `cargo__ratings`.`format`="GG" and `cargo__releases`.`type`="0" GROUP BY `cargo__ratings`.`name` ORDER BY `cargo__ratings`.`name` LIMIT 1500 Function: CargoSQLQuery::run Error: 1021 Disk full (/tmp/#sql-temptable-15e6a-23af64-1f.MAI); waiting for someone to free some space... (errno: 28 "No space left on device") (localhost)
| Score | Game | Number of reviews |
|---|
{{RatingsTableAll|MD|accessories}}
Query: SELECT `cargo__ratings`.`name` AS `name`,`cargo__ratings`.`format` AS `format` FROM `cargo__ratings` LEFT OUTER JOIN `cargo__releases` ON ((`cargo__ratings`.`name`=`cargo__releases`.`name`)) WHERE `cargo__ratings`.`format`="MD" and `cargo__releases`.`type`="1" GROUP BY `cargo__ratings`.`name` ORDER BY `cargo__ratings`.`name` LIMIT 1500 Function: CargoSQLQuery::run Error: 1021 Disk full (/tmp/#sql-temptable-15e6a-23af64-22.MAI); waiting for someone to free some space... (errno: 28 "No space left on device") (localhost)
| Score | Game | Number of reviews |
|---|