CompanyHistory
From Sega Retro
Template to list a company's softography. It's a bit crude.
e.g. Sega, 32X:
Publisher
{{CompanyHistory|Sega|format=32X|role=Publisher}}
- Doom (1994)
- Space Harrier (1994)
- Star Wars Arcade (1994)
- Virtua Racing Deluxe (1994)
- Star Trek: Starfleet Academy Starship Bridge Simulator (1995)
- T-MEK (1995)
- Motocross Championship (1995)
- After Burner Complete (1995)
- Cosmic Carnage (1995)
- Golf Magazine: 36 Great Holes Starring Fred Couples (1995)
- Metal Head (1995)
- Tempo (1995)
- Chaotix (1995)
- Stellar Assault (1995)
- Sangokushi IV (1995)
- Zaxxon's Motherbase 2000 (1995)
- Blackthorne (1995)
- Kolibri (1995)
- Virtua Fighter (1995)
- Primal Rage (1995)
- Darxide (1996)
- World Series Baseball Starring Deion Sanders (1996)
- Spider-Man: Web of Fire (1996)A database query error has occurred. Did you forget to run your application's database schema updater after upgrading?
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") and not releases.type="1" GROUP BY `cargo__unreleased`.`name` ORDER BY `cargo__unreleased`.`date`,`cargo__unreleased`.`name` LIMIT 1000 Function: CargoSQLQuery::run Error: 1054 Unknown column 'releases.type' in 'where clause' (localhost)
Developer
{{CompanyHistory|Sega|Sega CS|format=32X|role=Developer}}
- Sangokushi IV (1995)A database query error has occurred. Did you forget to run your application's database schema updater after upgrading?
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") and not releases.type="1" GROUP BY `cargo__unreleased`.`name` ORDER BY `cargo__unreleased`.`date`,`cargo__unreleased`.`name` LIMIT 1000 Function: CargoSQLQuery::run Error: 1054 Unknown column 'releases.type' in 'where clause' (localhost)
Licensor
{{CompanyHistory|Sega|format=32X|role=Licensor}}
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") and not releases.type="1" GROUP BY `cargo__unreleased`.`name` ORDER BY `cargo__unreleased`.`date`,`cargo__unreleased`.`name` LIMIT 1000 Function: CargoSQLQuery::run Error: 1054 Unknown column 'releases.type' in 'where clause' (localhost)