Difference between revisions of "CompanyHistory"

From Sega Retro

(Undo revision 805491 by Black Squirrel (talk))
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,companies.specificrole
+
|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 11:37, 30 October 2022

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}}

Books

{{CompanyHistory|IDW Publishing|format=book|role=Publisher}}