Difference between revisions of "CompanyHistory"
From Sega Retro
(Undo revision 805477 by Black Squirrel (talk) I'll let the table rebuild first) Tag: Undo |
|||
(One intermediate revision by the same user not shown) | |||
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,MIN(releases.date),companies.company,companies.format,companies.role,companies.credited,codeformat.code=test,codeformat.format=test2,companies.specificrole |
|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 | ||
− | |order by=releases.date,releases.name | + | |order by=MIN(releases.date),releases.name |
|where=({{#var:command}}) {{#if:{{{role|}}}|and (companies.role LIKE "{{{role|}}}%")}} {{#ifeq:{{{type|}}}|hardware||{{#if:{{{format|}}}|and (companies.format="{{{format|}}}") and (codeformat.format="{{{format|}}}")}}}} {{#switch:{{{type|}}} | |where=({{#var:command}}) {{#if:{{{role|}}}|and (companies.role LIKE "{{{role|}}}%")}} {{#ifeq:{{{type|}}}|hardware||{{#if:{{{format|}}}|and (companies.format="{{{format|}}}") and (codeformat.format="{{{format|}}}")}}}} {{#switch:{{{type|}}} | ||
|accessories=and releases.type="1"{{#vardefine:italics|}} | |accessories=and releases.type="1"{{#vardefine:italics|}} | ||
Line 44: | Line 44: | ||
<pre>{{CompanyHistory|Sega|format=32X|role=Licensor}}</pre> | <pre>{{CompanyHistory|Sega|format=32X|role=Licensor}}</pre> | ||
{{CompanyHistory|Sega|format=32X|role=Licensor}} | {{CompanyHistory|Sega|format=32X|role=Licensor}} | ||
+ | |||
+ | ===Books=== | ||
+ | <pre>{{CompanyHistory|IDW Publishing|format=book|role=Publisher}}</pre> | ||
+ | {{CompanyHistory|IDW Publishing|format=book|role=Publisher}} | ||
[[Category:Templates]] | [[Category:Templates]] | ||
</noinclude> | </noinclude> |
Latest revision as of 12:37, 30 October 2022
Template to list a company's softography. It's a bit crude.
e.g. Sega, 32X:
Contents
Publisher
{{CompanyHistory|Sega|format=32X|role=Publisher}}
- Star Wars Arcade (1994)
- Virtua Racing Deluxe (1994)
- Doom (1994)
- Cosmic Carnage (1994)
- Space Harrier (1994)
- After Burner Complete (1995)
- Chaotix (1995)
- Golf Magazine: 36 Great Holes Starring Fred Couples (1995)
- Kolibri (1995)
- Metal Head (1995)
- Motocross Championship (1995)
- Star Trek: Starfleet Academy Starship Bridge Simulator (1995)
- Stellar Assault (1995)
- T-MEK (1995)
- Tempo (1995)
- Virtua Fighter (1995)
- Zaxxon's Motherbase 2000 (1995)
- Sangokushi IV (1995)
- Blackthorne (1995)
- Primal Rage (1995)
- Darxide (1996)
- World Series Baseball Starring Deion Sanders (1996)
- Spider-Man: Web of Fire (1996)
- 32 Xtreme (unreleased)
- College Basketball's National Championship Hosted by Billy Packer (unreleased)
- Ecco the Dolphin (unreleased)
- NBA Action (unreleased)
- Ratchet and Bolt (unreleased)
- Sonic Sports (unreleased)
- Virtua Hamster (unreleased)
- VR Troopers (unreleased)
- Wing War (unreleased)
- X-Men (unreleased)
Developer
{{CompanyHistory|Sega|Sega CS|format=32X|role=Developer}}
- Sangokushi IV (1995)
- 32 Xtreme (unreleased)
- College Basketball's National Championship Hosted by Billy Packer (unreleased)
- Ratchet and Bolt (unreleased)
Licensor
{{CompanyHistory|Sega|format=32X|role=Licensor}}
Books
{{CompanyHistory|IDW Publishing|format=book|role=Publisher}}
- Sonic the Hedgehog Volume 1: Fallout! (2018)
- Sonic the Hedgehog Volume 2: The Fate of Dr. Eggman (2019)
- Sonic the Hedgehog Volume 3: Battle For Angel Island (2019)
- Sonic the Hedgehog Volume 4: Infection (2019)
- Sonic the Hedgehog Volume 5: Crisis City (2020)
- Sonic the Hedgehog: Tangle & Whisper (2020)
- Sonic the Hedgehog Volume 6: The Last Minute (2020)
- Sonic the Hedgehog Volume 7: All or Nothing (2020)
- Sonic the Hedgehog Volume 8: Out of the Blue (2021)
- Sonic the Hedgehog: Bad Guys (2021)
- Sonic the Hedgehog: The IDW Collection 1 (2021)
- Sonic the Hedgehog 30th Anniversary Celebration: The Deluxe Edition (2021)
- Sonic the Hedgehog Volume 9: Chao Races & Badnik Bases (2022)
- Sonic the Hedgehog: Sonic & Tails: Best Buds Forever (2022)
- Sonic the Hedgehog Volume 10: Test Run! (2022)
- Sonic the Hedgehog: The IDW Collection 2 (2022)
- Sonic the Hedgehog 2: The Official Movie Pre-Quill (2022)
- Sonic the Hedgehog Volume 11: Zeti Hunt! (2022)
- Sonic the Hedgehog Volume 12: Trial by Fire (2022)
- Sonic the Hedgehog: Imposter Syndrome (2022)
- Sonic the Hedgehog Volume 13: Battle for the Empire (2023)
- Sonic the Hedgehog: The IDW Collection, Volume 3 (2023)
- Sonic the Hedgehog Volume 14: Overpowered (2023)
- Sonic the Hedgehog: Scrapnik Island (2023)
- Sonic the Hedgehog Volume 15: Urban Warfare (2023)
- Sonic the Hedgehog: The IDW Collection Volume 4 (2024)