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="{{{1|}}}" and relationships.relationshiptype="book" | + | |where=relationships.relatedto="{{#replace:{{{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="{{{1|}}}" and relationships.relationshiptype="music" | + | |where=relationships.relatedto="{{#replace:{{{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="{{{1|}}}" and relationships.relationshiptype="audiobook" | + | |where=relationships.relatedto="{{#replace:{{{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="{{{1|}}}" and relationships.relationshiptype="video" | + | |where=relationships.relatedto="{{#replace:{{{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 | ||
Revision as of 17:02, 2 March 2021
Template that generates relevant media for Omni tables, so you don't have to.
Examples
{{OmniMedia|Space Channel 5: Part 2}}
Books:
Query: SELECT `cargo__relationships`.`name` AS `name`,`cargo__releases`.`date` AS `date` FROM `cargo__relationships` LEFT OUTER JOIN `cargo__releases` ON ((`cargo__relationships`.`name`=`cargo__releases`.`name`)) WHERE `cargo__relationships`.`relatedto`="Space Channel 5: Part 2" and `cargo__relationships`.`relationshiptype`="book" GROUP BY `cargo__releases`.`name` ORDER BY `cargo__releases`.`date` LIMIT 100 Function: CargoSQLQuery::run Error: 1021 Disk full (/tmp/#sql-temptable-15e6a-25abfe4-f74.MAI); waiting for someone to free some space... (errno: 28 "No space left on device") (localhost)
</diMusic:
Query: SELECT `cargo__relationships`.`name` AS `name`,`cargo__releases`.`date` AS `date` FROM `cargo__relationships` LEFT OUTER JOIN `cargo__releases` ON ((`cargo__relationships`.`name`=`cargo__releases`.`name`)) WHERE `cargo__relationships`.`relatedto`="Space Channel 5: Part 2" and `cargo__relationships`.`relationshiptype`="music" GROUP BY `cargo__releases`.`name` ORDER BY `cargo__releases`.`date` LIMIT 100 Function: CargoSQLQuery::run Error: 1021 Disk full (/tmp/#sql-temptable-15e6a-25abfe4-f77.MAI); waiting for someone to free some space... (errno: 28 "No space left on device") (localhost)
</diAudiobooks:
Query: SELECT `cargo__relationships`.`name` AS `name`,`cargo__releases`.`date` AS `date` FROM `cargo__relationships` LEFT OUTER JOIN `cargo__releases` ON ((`cargo__relationships`.`name`=`cargo__releases`.`name`)) WHERE `cargo__relationships`.`relatedto`="Space Channel 5: Part 2" and `cargo__relationships`.`relationshiptype`="audiobook" GROUP BY `cargo__releases`.`name` ORDER BY `cargo__releases`.`date` LIMIT 100 Function: CargoSQLQuery::run Error: 1021 Disk full (/tmp/#sql-temptable-15e6a-25abfe4-f7a.MAI); waiting for someone to free some space... (errno: 28 "No space left on device") (localhost)
</diVideos:
Query: SELECT `cargo__relationships`.`name` AS `name`,`cargo__releases`.`date` AS `date` FROM `cargo__relationships` LEFT OUTER JOIN `cargo__releases` ON ((`cargo__relationships`.`name`=`cargo__releases`.`name`)) WHERE `cargo__relationships`.`relatedto`="Space Channel 5: Part 2" and `cargo__relationships`.`relationshiptype`="video" GROUP BY `cargo__releases`.`name` ORDER BY `cargo__releases`.`date` LIMIT 100
Function: CargoSQLQuery::run
Error: 1021 Disk full (/tmp/#sql-temptable-15e6a-25abfe4-f7d.MAI); waiting for someone to free some space... (errno: 28 "No space left on device") (localhost)
</di