RatingsTable
From Sega Retro
Template for generating a high score table for magazine reviews.
e.g.
{{RatingsTable|megazin|GG}}
Query: SELECT `cargo__ratings`.`score` AS `score`,`cargo__ratings`.`name` AS `name`,`cargo__ratings`.`version` AS `version`,`cargo__ratings`.`code` AS `code`,`cargo__ratings`.`issue` AS `issue`,`cargo__ratings`.`format` AS `format`,`cargo__ratings`.`pdfpage` AS `pdfpage` FROM `cargo__ratings` LEFT OUTER JOIN `cargo__releases` ON ((`cargo__ratings`.`name`=`cargo__releases`.`name`)) WHERE `cargo__ratings`.`code`="megazin" and `cargo__ratings`.`format`="GG" and `cargo__releases`.`type`="0" GROUP BY `cargo__ratings`.`name`,`cargo__ratings`.`issue` ORDER BY `cargo__ratings`.`score` desc,`cargo__ratings`.`name` LIMIT 2000 Function: CargoSQLQuery::run Error: 1021 Disk full (/tmp/#sql-temptable-15e6a-540ae5-b1d.MAI); waiting for someone to free some space... (errno: 28 "No space left on device") (localhost)
| Score | Game | Version | Issue | Date | Awards |
|---|
{{RatingsTable|mega|MD|accessories}}
Query: SELECT `cargo__ratings`.`score` AS `score`,`cargo__ratings`.`name` AS `name`,`cargo__ratings`.`version` AS `version`,`cargo__ratings`.`code` AS `code`,`cargo__ratings`.`issue` AS `issue`,`cargo__ratings`.`format` AS `format`,`cargo__ratings`.`pdfpage` AS `pdfpage` FROM `cargo__ratings` LEFT OUTER JOIN `cargo__releases` ON ((`cargo__ratings`.`name`=`cargo__releases`.`name`)) WHERE `cargo__ratings`.`code`="mega" and `cargo__ratings`.`format`="MD" and `cargo__releases`.`type`="1" GROUP BY `cargo__ratings`.`name`,`cargo__ratings`.`issue` ORDER BY `cargo__ratings`.`score` desc,`cargo__ratings`.`name` LIMIT 2000 Function: CargoSQLQuery::run Error: 1021 Disk full (/tmp/#sql-temptable-15e6a-540ae5-b20.MAI); waiting for someone to free some space... (errno: 28 "No space left on device") (localhost)
| Score | Game | Version | Issue | Date | Awards |
|---|