Difference between revisions of "OmniMedia"
From Sega Retro
| Line 2: | Line 2: | ||
tables=relationships,releases | tables=relationships,releases | ||
|fields=relationships.name,releases.date | |fields=relationships.name,releases.date | ||
| − | |where=relationships.relatedto="{{ | + | |where=relationships.relatedto="{{FormatSQL|{{{1|}}}}}" and relationships.relationshiptype="book" |
|join on=relationships.name=releases.name | |join on=relationships.name=releases.name | ||
|group by=releases.name | |group by=releases.name | ||
| Line 12: | Line 12: | ||
tables=relationships,releases | tables=relationships,releases | ||
|fields=relationships.name,releases.date | |fields=relationships.name,releases.date | ||
| − | |where=relationships.relatedto="{{ | + | |where=relationships.relatedto="{{FormatSQL|{{{1|}}}}}" and relationships.relationshiptype="music" |
|join on=relationships.name=releases.name | |join on=relationships.name=releases.name | ||
|group by=releases.name | |group by=releases.name | ||
| Line 22: | Line 22: | ||
tables=relationships,releases | tables=relationships,releases | ||
|fields=relationships.name,releases.date | |fields=relationships.name,releases.date | ||
| − | |where=relationships.relatedto="{{ | + | |where=relationships.relatedto="{{FormatSQL|{{{1|}}}}}" and relationships.relationshiptype="audiobook" |
|join on=relationships.name=releases.name | |join on=relationships.name=releases.name | ||
|group by=releases.name | |group by=releases.name | ||
| Line 32: | Line 32: | ||
tables=relationships,releases | tables=relationships,releases | ||
|fields=relationships.name,releases.date | |fields=relationships.name,releases.date | ||
| − | |where=relationships.relatedto="{{ | + | |where=relationships.relatedto="{{FormatSQL|{{{1|}}}}}" and relationships.relationshiptype="video" |
|join on=relationships.name=releases.name | |join on=relationships.name=releases.name | ||
|group by=releases.name | |group by=releases.name | ||
| Line 40: | Line 40: | ||
|default= | |default= | ||
}}}} | }}}} | ||
| − | {{#if:{{#var:bookresult}}|'''Books:''' {{#sub:{{#var:bookresult}}|0|-2}}<br/>|}}{{ | + | {{#if:{{#var:bookresult}}|'''Books:''' {{#sub:{{UnformatSQL|{{#var:bookresult}}}}|0|-2}}<br/>|}}{{ |
| − | #if:{{#var:musicresult}}|'''Music:''' {{#sub:{{#var:musicresult}}|0|-2}}<br/>|}}{{ | + | #if:{{#var:musicresult}}|'''Music:''' {{#sub:{{UnformatSQL|{{#var:musicresult}}}}|0|-2}}<br/>|}}{{ |
| − | #if:{{#var:audiobookresult}}|'''Audiobooks:''' {{#sub:{{#var:audiobookresult}}|0|-2}}<br/>|}}{{ | + | #if:{{#var:audiobookresult}}|'''Audiobooks:''' {{#sub:{{UnformatSQL|{{#var:audiobookresult}}}}|0|-2}}<br/>|}}{{ |
| − | #if:{{#var:videoresult}}|'''Videos:''' {{#sub:{{#var:videoresult}}|0|-2}}<br/>|}}{{clearvar|bookresult|musicresult|audiobookresult|videoresult|prereleaseresult}}</includeonly><noinclude>[[Category:Sega Retro templates]] | + | #if:{{#var:videoresult}}|'''Videos:''' {{#sub:{{UnformatSQL|{{#var:videoresult}}}}|0|-2}}<br/>|}}{{clearvar|bookresult|musicresult|audiobookresult|videoresult|prereleaseresult}}</includeonly><noinclude>[[Category:Sega Retro templates]] |
Template that generates relevant media for Omni tables, so you don't have to. | Template that generates relevant media for Omni tables, so you don't have to. | ||
Revision as of 17:27, 14 June 2021
Template that generates relevant media for Omni tables, so you don't have to.
Examples
{{OmniMedia|Space Channel 5: Part 2}}
Books: Space Channel 5 Part 2 Sugoku Sugoi Guide Book (2002)
Music: Space Channel 5 Part 2 Soundtrack Volume "Chu!!" (2002) | Space Channel 5 Part 2 Soundtrack Volume "Hey!!" (2002) | Space Channel 5 Part 2 Uki Uki ★ Non Stop Mega Mix (2002) | Space Channel 5 Part 2 Moji Moji ★ Can't Stop Remix (2002) | Space Channel 5 Part 2 Uha Uha ★ Readymade Remixes (2002)