Difference between revisions of "CompanyHistory"

From Sega Retro

Line 7: Line 7:
 
|join on=companies.name=releases.name
 
|join on=companies.name=releases.name
 
|group by=releases.name
 
|group by=releases.name
|where=({{#var:command}}) {{#if:{{{role|}}}|and (companies.role LIKE "{{{role|}}}%")}} {{#if:{{{format|}}}|and (companies.format LIKE "%{{{format|}}}")}}
+
|where=({{#var:command}}) {{#if:{{{role|}}}|and (companies.role LIKE "{{{role|}}}%")}} {{#if:{{{format|}}}|and (companies.format="%{{{format|}}}")}}
 
|order by=releases.date
 
|order by=releases.date
 
|format=template
 
|format=template

Revision as of 13:47, 3 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}}

No results

Developer

{{CompanyHistory|Sega|Sega CS|format=32X|role=Developer}}

No results

Licensor

{{CompanyHistory|Sega|format=32X|role=Licensor}}

No results