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="{{{role|}}}"}} {{#if:{{{format|}}}|and companies.format="{{{format|}}}"}}
+
|where=({{#var:command}}) {{#if:{{{role|}}}|and (companies.role LIKE "{{{role|}}}%")}} {{#if:{{{format|}}}|and (companies.format LIKE "%{{{format|}}}")}}
 
|order by=releases.date
 
|order by=releases.date
 
|format=template
 
|format=template
Line 17: Line 17:
  
 
===Publisher===
 
===Publisher===
<pre>{{CompanyHistory|Sega|format=Sega 32X|role=Publisher}}</pre>
+
<pre>{{CompanyHistory|Sega|format=32X|role=Publisher}}</pre>
{{CompanyHistory|Sega|format=Sega 32X|role=Publisher}}
+
{{CompanyHistory|Sega|format=32X|role=Publisher}}
  
 
===Developer===
 
===Developer===
<pre>{{CompanyHistory|Sega|Sega CS|format=Sega 32X|role=Developer}}</pre>
+
<pre>{{CompanyHistory|Sega|Sega CS|format=32X|role=Developer}}</pre>
{{CompanyHistory|Sega|Sega CS|format=Sega 32X|role=Developer}}
+
{{CompanyHistory|Sega|Sega CS|format=32X|role=Developer}}
  
 
===Licensor===
 
===Licensor===
<pre>{{CompanyHistory|Sega|format=Sega 32X|role=Licensor}}</pre>
+
<pre>{{CompanyHistory|Sega|format=32X|role=Licensor}}</pre>
{{CompanyHistory|Sega|format=Sega 32X|role=Licensor}}
+
{{CompanyHistory|Sega|format=32X|role=Licensor}}
  
  
 
[[Category:Sega Retro templates]]
 
[[Category:Sega Retro templates]]
 
</noinclude>
 
</noinclude>

Revision as of 17:08, 28 November 2018

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