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 15: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}}
Developer
{{CompanyHistory|Sega|Sega CS|format=32X|role=Developer}}
Licensor
{{CompanyHistory|Sega|format=32X|role=Licensor}}