Difference between revisions of "BulletPointBootlegList"

From Sega Retro

 
(3 intermediate revisions by the same user not shown)
Line 2: Line 2:
 
table={{#if:{{#var:multicarts}}|multicarts|bootlegs}}
 
table={{#if:{{#var:multicarts}}|multicarts|bootlegs}}
 
|fields=pagename,name,name2,code
 
|fields=pagename,name,name2,code
|where=distributor="{{FormatSQL|{{{1|{{PAGENAME}}}}}}}"
+
|where=distributor="{{FormatSQL|{{{1|{{PAGENAME}}}}}}}" and name != ""
 
|limit=10000
 
|limit=10000
 
|order by=name
 
|order by=name
|group by={{#if:{{#var:multicarts}}|code|pagename}}
+
|group by={{#if:{{#var:multicarts}}|name,code|pagename}}
 
|format=template
 
|format=template
 
|template=BulletPointBootlegList/Cargo
 
|template=BulletPointBootlegList/Cargo
Line 12: Line 12:
 
|cols={{MulticolColumnCalc|{{#var:i}}}}
 
|cols={{MulticolColumnCalc|{{#var:i}}}}
 
}}{{clearvar|multicarts}}</includeonly><noinclude>
 
}}{{clearvar|multicarts}}</includeonly><noinclude>
 +
 +
==Examples==
 
<pre>{{BulletPointBootlegList|New Game}}</pre>
 
<pre>{{BulletPointBootlegList|New Game}}</pre>
 
{{BulletPointBootlegList|New Game}}
 
{{BulletPointBootlegList|New Game}}
 +
 +
<pre>{{BulletPointBootlegList|RGR Studio|multicarts=yes}}</pre>
 +
{{BulletPointBootlegList|RGR Studio|multicarts=yes}}
  
 
[[Category:Cargo templates]]</noinclude>
 
[[Category:Cargo templates]]</noinclude>

Latest revision as of 06:26, 8 June 2023


Examples

{{BulletPointBootlegList|New Game}}
{{BulletPointBootlegList|RGR Studio|multicarts=yes}}