Difference between revisions of "CompanyHistory"
From Sega Retro
(Undo revision 805477 by Black Squirrel (talk) I'll let the table rebuild first) Tag: Undo |
|||
| Line 4: | Line 4: | ||
}}</span>{{#vardefine:results|{{#var:results}}{{#cargo_query: | }}</span>{{#vardefine:results|{{#var:results}}{{#cargo_query: | ||
table=companies,releases,codeformat | table=companies,releases,codeformat | ||
| − | |fields=companies.name=companiesname,releases.name=releasesname,releases.date,companies.company,companies.format,companies.role,companies.credited,codeformat.code=test,codeformat.format=test2 | + | |fields=companies.name=companiesname,releases.name=releasesname,releases.date,companies.company,companies.format,companies.role,companies.credited,codeformat.code=test,codeformat.format=test2 |
|join on=companies.name=releases.name,releases.console=codeformat.code | |join on=companies.name=releases.name,releases.console=codeformat.code | ||
|group by=releases.name | |group by=releases.name | ||
Revision as of 14:34, 9 August 2022
Template to list a company's softography. It's a bit crude.
e.g. Sega, 32X:
Publisher
{{CompanyHistory|Sega|format=32X|role=Publisher}}
Query: SELECT `cargo__companies`.`name` AS `companiesname`,`cargo__releases`.`name` AS `releasesname`,`cargo__releases`.`date` AS `date`,`cargo__companies`.`company` AS `company`,`cargo__companies`.`format` AS `format`,`cargo__companies`.`role` AS `role`,`cargo__companies`.`credited` AS `credited`,`cargo__codeformat`.`code` AS `test`,`cargo__codeformat`.`format` AS `test2` FROM `cargo__companies` LEFT OUTER JOIN `cargo__releases` ON ((`cargo__companies`.`name`=`cargo__releases`.`name`)) LEFT OUTER JOIN `cargo__codeformat` ON ((`cargo__releases`.`console`=`cargo__codeformat`.`code`)) WHERE (`cargo__companies`.`company`="Sega") and (`cargo__companies`.`role` LIKE "Publisher%") and (`cargo__companies`.`format`="32X") and (`cargo__codeformat`.`format`="32X") and not `cargo__releases`.`type`="1" and not `cargo__releases`.`type`="2" and not `cargo__releases`.`type`="-1" GROUP BY `cargo__releases`.`name` ORDER BY `cargo__releases`.`date`,`cargo__releases`.`name` LIMIT 1000 Function: CargoSQLQuery::run Error: 1021 Disk full (/tmp/#sql-temptable-15e6a-272082e-b7b.MAI); waiting for someone to free some space... (errno: 28 "No space left on device") (localhost)
Query: SELECT `cargo__companies`.`name` AS `companiesname`,`cargo__unreleased`.`name` AS `releasesname`,`cargo__unreleased`.`date` AS `date`,`cargo__companies`.`company` AS `company`,`cargo__companies`.`format` AS `format`,`cargo__companies`.`role` AS `role`,`cargo__companies`.`credited` AS `credited` FROM `cargo__unreleased` LEFT OUTER JOIN `cargo__companies` ON ((`cargo__unreleased`.`name`=`cargo__companies`.`name`)) WHERE (`cargo__companies`.`company`="Sega") and (`cargo__companies`.`role` LIKE "Publisher%") and (`cargo__companies`.`format`="32X") GROUP BY `cargo__unreleased`.`name` ORDER BY `cargo__unreleased`.`date`,`cargo__unreleased`.`name` LIMIT 1000 Function: CargoSQLQuery::run Error: 1021 Disk full (/tmp/#sql-temptable-15e6a-272082e-b7e.MAI); waiting for someone to free some space... (errno: 28 "No space left on device") (localhost)
Developer
{{CompanyHistory|Sega|Sega CS|format=32X|role=Developer}}
Query: SELECT `cargo__companies`.`name` AS `companiesname`,`cargo__releases`.`name` AS `releasesname`,`cargo__releases`.`date` AS `date`,`cargo__companies`.`company` AS `company`,`cargo__companies`.`format` AS `format`,`cargo__companies`.`role` AS `role`,`cargo__companies`.`credited` AS `credited`,`cargo__codeformat`.`code` AS `test`,`cargo__codeformat`.`format` AS `test2` FROM `cargo__companies` LEFT OUTER JOIN `cargo__releases` ON ((`cargo__companies`.`name`=`cargo__releases`.`name`)) LEFT OUTER JOIN `cargo__codeformat` ON ((`cargo__releases`.`console`=`cargo__codeformat`.`code`)) WHERE (`cargo__companies`.`company`="Sega" OR `cargo__companies`.`company`="Sega CS") and (`cargo__companies`.`role` LIKE "Developer%") and (`cargo__companies`.`format`="32X") and (`cargo__codeformat`.`format`="32X") and not `cargo__releases`.`type`="1" and not `cargo__releases`.`type`="2" and not `cargo__releases`.`type`="-1" GROUP BY `cargo__releases`.`name` ORDER BY `cargo__releases`.`date`,`cargo__releases`.`name` LIMIT 1000 Function: CargoSQLQuery::run Error: 1021 Disk full (/tmp/#sql-temptable-15e6a-272082e-b82.MAI); waiting for someone to free some space... (errno: 28 "No space left on device") (localhost)
Query: SELECT `cargo__companies`.`name` AS `companiesname`,`cargo__unreleased`.`name` AS `releasesname`,`cargo__unreleased`.`date` AS `date`,`cargo__companies`.`company` AS `company`,`cargo__companies`.`format` AS `format`,`cargo__companies`.`role` AS `role`,`cargo__companies`.`credited` AS `credited` FROM `cargo__unreleased` LEFT OUTER JOIN `cargo__companies` ON ((`cargo__unreleased`.`name`=`cargo__companies`.`name`)) WHERE (`cargo__companies`.`company`="Sega" OR `cargo__companies`.`company`="Sega CS") and (`cargo__companies`.`role` LIKE "Developer%") and (`cargo__companies`.`format`="32X") GROUP BY `cargo__unreleased`.`name` ORDER BY `cargo__unreleased`.`date`,`cargo__unreleased`.`name` LIMIT 1000 Function: CargoSQLQuery::run Error: 1021 Disk full (/tmp/#sql-temptable-15e6a-272082e-b85.MAI); waiting for someone to free some space... (errno: 28 "No space left on device") (localhost)
Licensor
{{CompanyHistory|Sega|format=32X|role=Licensor}}
Query: SELECT `cargo__companies`.`name` AS `companiesname`,`cargo__releases`.`name` AS `releasesname`,`cargo__releases`.`date` AS `date`,`cargo__companies`.`company` AS `company`,`cargo__companies`.`format` AS `format`,`cargo__companies`.`role` AS `role`,`cargo__companies`.`credited` AS `credited`,`cargo__codeformat`.`code` AS `test`,`cargo__codeformat`.`format` AS `test2` FROM `cargo__companies` LEFT OUTER JOIN `cargo__releases` ON ((`cargo__companies`.`name`=`cargo__releases`.`name`)) LEFT OUTER JOIN `cargo__codeformat` ON ((`cargo__releases`.`console`=`cargo__codeformat`.`code`)) WHERE (`cargo__companies`.`company`="Sega") and (`cargo__companies`.`role` LIKE "Licensor%") and (`cargo__companies`.`format`="32X") and (`cargo__codeformat`.`format`="32X") and not `cargo__releases`.`type`="1" and not `cargo__releases`.`type`="2" and not `cargo__releases`.`type`="-1" GROUP BY `cargo__releases`.`name` ORDER BY `cargo__releases`.`date`,`cargo__releases`.`name` LIMIT 1000 Function: CargoSQLQuery::run Error: 1021 Disk full (/tmp/#sql-temptable-15e6a-272082e-b89.MAI); waiting for someone to free some space... (errno: 28 "No space left on device") (localhost)
Query: SELECT `cargo__companies`.`name` AS `companiesname`,`cargo__unreleased`.`name` AS `releasesname`,`cargo__unreleased`.`date` AS `date`,`cargo__companies`.`company` AS `company`,`cargo__companies`.`format` AS `format`,`cargo__companies`.`role` AS `role`,`cargo__companies`.`credited` AS `credited` FROM `cargo__unreleased` LEFT OUTER JOIN `cargo__companies` ON ((`cargo__unreleased`.`name`=`cargo__companies`.`name`)) WHERE (`cargo__companies`.`company`="Sega") and (`cargo__companies`.`role` LIKE "Licensor%") and (`cargo__companies`.`format`="32X") GROUP BY `cargo__unreleased`.`name` ORDER BY `cargo__unreleased`.`date`,`cargo__unreleased`.`name` LIMIT 1000 Function: CargoSQLQuery::run Error: 1021 Disk full (/tmp/#sql-temptable-15e6a-272082e-b8c.MAI); waiting for someone to free some space... (errno: 28 "No space left on device") (localhost)