Difference between revisions of "SongCredits"

From Sega Retro

(Created page with "<includeonly>{{#cargo_query: table=trackcredits |fields=game,track,role |where=name="{{{1|}}}" |limit=10000 |format=template |template=TrackTest/Cargo }}</includeonly><noinclu...")
 
Line 1: Line 1:
 
<includeonly>{{#cargo_query:
 
<includeonly>{{#cargo_query:
table=trackcredits
+
table=trackcredits,releases
|fields=game,track,role
+
|fields=trackcredits.game,trackcredits.track,trackcredits.role,releases.date
|where=name="{{{1|}}}"
+
|join on=releases.console=trackcredits.console,releases.name=trackcredits.game
 +
|where=trackcredits.name="{{{1|}}}"
 +
|order by=releases.date
 
|limit=10000
 
|limit=10000
 
|format=template
 
|format=template

Revision as of 13:41, 29 November 2022