Difference between revisions of "SongCredits"

From Sega Retro
Line 6: Line 6:
 
|fields=trackcredits.game,trackcredits.track,trackcredits.role,releases.console,releases.date,trackcredits.pdf,trackcredits.pdfpage,trackcredits.name
 
|fields=trackcredits.game,trackcredits.track,trackcredits.role,releases.console,releases.date,trackcredits.pdf,trackcredits.pdfpage,trackcredits.name
 
|join on=releases.console=trackcredits.console,releases.name=trackcredits.game
 
|join on=releases.console=trackcredits.console,releases.name=trackcredits.game
−
|where=({{#var:command}}) {{#if:{{{type|}}}|AND releases.type="{{{type}}}"|}}
+
|where=({{#var:command}}) {{#if:{{{type|}}}|AND releases.type="{{{type}}}"|}} AND trackcredits.console = releases.console
 
|group by=releases.console,trackcredits.game,trackcredits.track,trackcredits.role
 
|group by=releases.console,trackcredits.game,trackcredits.track,trackcredits.role
 
|order by=releases.date
 
|order by=releases.date

Revision as of 05:17, 7 December 2022

Template for showing song credits. Use Template:SongCreditsAll for better formatting.

Sonic the Hedgehog 3 (Mega Drive; 1994)

  1. ↑ 1.00 1.01 1.02 1.03 1.04 1.05 1.06 1.07 1.08 1.09 1.10 1.11 1.12 1.13 1.14 1.15 1.16 1.17 1.18 1.19 1.20 1.21 1.22 1.23 1.24 1.25 1.26 1.27 1.28 1.29 1.30 1.31 1.32 1.33 1.34 1.35 1.36 1.37 1.38 1.39 1.40 1.41 File:SADLCOST CD JP booklet1.pdf, page 2
  2. ↑ 2.0 2.1 2.2 2.3 2.4 File:CutsUnleashed CD JP front.pdf, page 4
  3. ↑ 3.0 3.1 3.2 3.3 File:CutsUnleashed CD JP front.pdf, page 5
  4. ↑ 4.0 4.1 4.2 4.3 4.4 File:CutsUnleashed CD JP front.pdf, page 6
  5. ↑ 5.0 5.1 5.2 5.3 File:CutsUnleashed CD JP front.pdf, page 10
  6. ↑ 6.0 6.1 6.2 6.3 File:CutsUnleashed CD JP front.pdf, page 11
  7. ↑ 7.00 7.01 7.02 7.03 7.04 7.05 7.06 7.07 7.08 7.09 7.10 7.11 7.12 7.13 7.14 7.15 7.16 7.17 7.18 7.19 7.20 7.21 7.22 7.23 7.24 7.25 7.26 7.27 7.28 7.29 7.30 7.31 7.32 7.33 7.34 7.35 7.36 File:MDSA2OST poster1.pdf, page 2
  8. ↑ 8.00 8.01 8.02 8.03 8.04 8.05 8.06 8.07 8.08 8.09 8.10 8.11 8.12 8.13 8.14 8.15 8.16 8.17 8.18 8.19 8.20 8.21 8.22 8.23 8.24 8.25 8.26 8.27 8.28 8.29 8.30 8.31 8.32 8.33 8.34 8.35 8.36 8.37 8.38 8.39 8.40 8.41 8.42 8.43 8.44 File:CompleteTrinity CD JP booklet.pdf, page 3
  9. ↑ File:LostandFound CD JP booklet.pdf, page 4
  10. ↑ File:LostandFound CD JP booklet.pdf, page 6
  11. ↑ 11.00 11.01 11.02 11.03 11.04 11.05 11.06 11.07 11.08 11.09 11.10 11.11 11.12 11.13 11.14 11.15 11.16 11.17 11.18 11.19 11.20 11.21 11.22 11.23 11.24 11.25 11.26 11.27 11.28 11.29 11.30 11.31 11.32 11.33 11.34 11.35 11.36 11.37 11.38 11.39 11.40 11.41 11.42 11.43 11.44 11.45 11.46 11.47 11.48 11.49 11.50 11.51 11.52 11.53 11.54 11.55 11.56 11.57 11.58 11.59 11.60 11.61 11.62 11.63 11.64 11.65 11.66 11.67 11.68 11.69 File:StHOriginalSoundtrax CD JP booklet.pdf, page 2
  12. ↑ 12.0 12.1 12.2 12.3 12.4 12.5 12.6 File:OutRun20 CD JP Box Disc10.jpg
  13. ↑ File:PlanetaryPieces CD JP booklet.pdf, page 12
  14. ↑ 14.0 14.1 14.2 File:FacetoFaith CD JP booklet.pdf, page 4
  15. ↑ 15.0 15.1 15.2 File:FacetoFaith CD JP booklet.pdf, page 5
  16. ↑ 16.0 16.1 16.2 File:FacetoFaith CD JP booklet.pdf, page 6
  17. ↑ 17.0 17.1 File:FacetoFaith CD JP booklet.pdf, page 7
  18. ↑ 18.0 18.1 18.2 File:FacetoFaith CD JP booklet.pdf, page 8
  19. ↑ 19.0 19.1 19.2 File:FacetoFaith CD JP booklet.pdf, page 9
  20. ↑ 20.0 20.1 File:BestofCrush40 CD JP booklet.pdf, page 2
  21. ↑ 21.00 21.01 21.02 21.03 21.04 21.05 21.06 21.07 21.08 21.09 21.10 File:Super32X15thAA Booklet.pdf
  22. ↑ 22.00 22.01 22.02 22.03 22.04 22.05 22.06 22.07 22.08 22.09 22.10 22.11 22.12 22.13 22.14 22.15 22.16 22.17 22.18 22.19 22.20 22.21 File:HistoryofSonicMusic20th CD JP booklet.pdf, page 2
  23. ↑ File:Live! CD JP booklet.pdf, page 2
  24. ↑ 24.0 24.1 24.2 24.3 File:Live! CD JP booklet.pdf, page 5
  25. ↑ 25.0 25.1 25.2 25.3 File:Live! CD JP booklet.pdf, page 6
  26. ↑ 26.0 26.1 26.2 File:Live! CD JP booklet.pdf, page 9
  27. ↑ 27.0 27.1 27.2 27.3 27.4 File:Live! CD JP booklet.pdf, page 10
  28. ↑ File:Live! CD JP booklet.pdf, page 13
Retrieved from "https://segaretro.org/index.php?title=Template:SongCredits&oldid=831750"