Difference between revisions of "CompanyHistory"
From Sega Retro
Line 3: | Line 3: | ||
| {{#vardefine:nameList|{{#var:nameList}},{{#var:value}}}}{{#ifexpr:{{#var:n}} > 1|{{#vardefine:command|{{#var:command}} OR companies.company="{{#var:value}}"}}|}} | | {{#vardefine:nameList|{{#var:nameList}},{{#var:value}}}}{{#ifexpr:{{#var:n}} > 1|{{#vardefine:command|{{#var:command}} OR companies.company="{{#var:value}}"}}|}} | ||
}}</span>{{#vardefine:results|{{#var:results}}{{#cargo_query: | }}</span>{{#vardefine:results|{{#var:results}}{{#cargo_query: | ||
− | table=companies,releases | + | table=companies,releases,codeformat |
− | |fields=companies.name=companiesname,releases.name=releasesname,releases.date,companies.company,companies.format,companies.role,companies.credited | + | |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 | + | |join on=companies.name=releases.name,releases.console=codeformat.code |
|group by=releases.name | |group by=releases.name | ||
+ | |order by=releases.date,releases.name | ||
|where=({{#var:command}}) {{#if:{{{role|}}}|and (companies.role LIKE "{{{role|}}}%")}} {{#if:{{{format|}}}|and (companies.format="{{{format|}}}")}} | |where=({{#var:command}}) {{#if:{{{role|}}}|and (companies.role LIKE "{{{role|}}}%")}} {{#if:{{{format|}}}|and (companies.format="{{{format|}}}")}} | ||
− | |||
|format=template | |format=template | ||
|limit=1000 | |limit=1000 |
Revision as of 16:53, 5 January 2020
Template to list a company's softography. It's a bit crude.
e.g. Sega, 32X:
Publisher
{{CompanyHistory|Sega|format=32X|role=Publisher}}
- Virtua Fighter (1993)
- Star Wars Arcade (1994)
- Doom (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)
- Primal Rage (1995)
- Fahrenheit (1995)
- Blackthorne (1995)
- Kolibri (1995)
- Darxide (1996)
- World Series Baseball Starring Deion Sanders (1996)
- Space Harrier (2022)
Developer
{{CompanyHistory|Sega|Sega CS|format=32X|role=Developer}}
- Sangokushi IV (1995)
- Fahrenheit (1995)
Licensor
{{CompanyHistory|Sega|format=32X|role=Licensor}}