Difference between revisions of "Discography"
From Sega Retro
(Created page with "<includeonly><div style="display:none;">{{#vardefine:historyCount|0}}{{#vardefine:contents|{{ CompanyHistoryBlock|{{{1|}}}|{{{2|}}}|{{{3|}}}|{{{4|}}}|{{{5|}}}|type={{{type|}}}...") |
m (Text replacement - "Category:Sega Retro templates" to "Category:Templates") |
||
(2 intermediate revisions by the same user not shown) | |||
Line 1: | Line 1: | ||
<includeonly><div style="display:none;">{{#vardefine:historyCount|0}}{{#vardefine:contents|{{ | <includeonly><div style="display:none;">{{#vardefine:historyCount|0}}{{#vardefine:contents|{{ | ||
CompanyHistoryBlock|{{{1|}}}|{{{2|}}}|{{{3|}}}|{{{4|}}}|{{{5|}}}|type={{{type|}}}|format=Vinyl}}{{ | CompanyHistoryBlock|{{{1|}}}|{{{2|}}}|{{{3|}}}|{{{4|}}}|{{{5|}}}|type={{{type|}}}|format=Vinyl}}{{ | ||
− | CompanyHistoryBlock|{{{1|}}}|{{{2|}}}|{{{3|}}}|{{{4|}}}|{{{5|}}}|type={{{type|}}}|format=Compact | + | CompanyHistoryBlock|{{{1|}}}|{{{2|}}}|{{{3|}}}|{{{4|}}}|{{{5|}}}|type={{{type|}}}|format=Compact Cassette}}{{ |
− | CompanyHistoryBlock|{{{1|}}}|{{{2|}}}|{{{3|}}}|{{{4|}}}|{{{5|}}}|type={{{type|}}}|format=CD}} | + | CompanyHistoryBlock|{{{1|}}}|{{{2|}}}|{{{3|}}}|{{{4|}}}|{{{5|}}}|type={{{type|}}}|format=CD}}{{ |
+ | CompanyHistoryBlock|{{{1|}}}|{{{2|}}}|{{{3|}}}|{{{4|}}}|{{{5|}}}|type={{{type|}}}|format=Digital}} | ||
}}</div>{{multicol|{{#var:contents}} | }}</div>{{multicol|{{#var:contents}} | ||
|cols={{MulticolColumnCalc|{{#var:historyCount}}}} | |cols={{MulticolColumnCalc|{{#var:historyCount}}}} | ||
Line 15: | Line 16: | ||
{{Discography|Scitron}} | {{Discography|Scitron}} | ||
− | [[Category: | + | [[Category:Templates]] |
</noinclude> | </noinclude> |
Latest revision as of 13:56, 1 January 2022
Template:CompanyHistoryAll but for music.
{{Discography|Scitron}}
becomes:
Vinyl
Query: SELECT `cargo__companies`.`name` AS `companiesname`,`cargo__releases`.`name` AS `releasesname`,MIN(`cargo__releases`.`date`) AS `date)`,`cargo__companies`.`company` AS `company`,`cargo__companies`.`format` AS `format`,`cargo__companies`.`role` AS `role`,`cargo__companies`.`credited` AS `credited`,`cargo__codeformat`.`code` AS `test`,`cargo__codeformat`.`format` AS `test2`,`cargo__companies`.`specificrole` AS `specificrole` FROM `cargo__companies` LEFT OUTER JOIN `cargo__releases` ON ((`cargo__companies`.`name`=`cargo__releases`.`name`)) LEFT OUTER JOIN `cargo__codeformat` ON ((`cargo__releases`.`console`=`cargo__codeformat`.`code`)) WHERE (`cargo__companies`.`company`="Scitron" OR `cargo__companies`.`company`="" OR `cargo__companies`.`company`="" OR `cargo__companies`.`company`="" OR `cargo__companies`.`company`="" OR `cargo__companies`.`company`="") and (`cargo__companies`.`format`="Vinyl") and (`cargo__codeformat`.`format`="Vinyl") and not `cargo__releases`.`type`="1" and not `cargo__releases`.`type`="2" and not `cargo__releases`.`type`="-1" GROUP BY `cargo__releases`.`name` ORDER BY MIN(`cargo__releases`.`date`),`cargo__releases`.`name` LIMIT 1000 Function: CargoSQLQuery::run Error: 1021 Disk full (/tmp/#sql-temptable-15e6a-2a650a-c3.MAI); waiting for someone to free some space... (errno: 28 "No space left on device") (localhost)
Query: SELECT `cargo__companies`.`name` AS `companiesname`,`cargo__unreleased`.`name` AS `releasesname`,`cargo__unreleased`.`date` AS `date`,`cargo__companies`.`company` AS `company`,`cargo__companies`.`format` AS `format`,`cargo__companies`.`role` AS `role`,`cargo__companies`.`credited` AS `credited` FROM `cargo__unreleased` LEFT OUTER JOIN `cargo__companies` ON ((`cargo__unreleased`.`name`=`cargo__companies`.`name`)) WHERE (`cargo__companies`.`company`="Scitron" OR `cargo__companies`.`company`="" OR `cargo__companies`.`company`="" OR `cargo__companies`.`company`="" OR `cargo__companies`.`company`="" OR `cargo__companies`.`company`="") and (`cargo__companies`.`format`="Vinyl") GROUP BY `cargo__unreleased`.`name` ORDER BY `cargo__unreleased`.`date`,`cargo__unreleased`.`name` LIMIT 1000 Function: CargoSQLQuery::run Error: 1021 Disk full (/tmp/#sql-temptable-15e6a-2a650a-c6.MAI); waiting for someone to free some space... (errno: 28 "No space left on device") (localhost)
Compact Cassette
Query: SELECT `cargo__companies`.`name` AS `companiesname`,`cargo__releases`.`name` AS `releasesname`,MIN(`cargo__releases`.`date`) AS `date)`,`cargo__companies`.`company` AS `company`,`cargo__companies`.`format` AS `format`,`cargo__companies`.`role` AS `role`,`cargo__companies`.`credited` AS `credited`,`cargo__codeformat`.`code` AS `test`,`cargo__codeformat`.`format` AS `test2`,`cargo__companies`.`specificrole` AS `specificrole` FROM `cargo__companies` LEFT OUTER JOIN `cargo__releases` ON ((`cargo__companies`.`name`=`cargo__releases`.`name`)) LEFT OUTER JOIN `cargo__codeformat` ON ((`cargo__releases`.`console`=`cargo__codeformat`.`code`)) WHERE (`cargo__companies`.`company`="Scitron" OR `cargo__companies`.`company`="" OR `cargo__companies`.`company`="" OR `cargo__companies`.`company`="" OR `cargo__companies`.`company`="" OR `cargo__companies`.`company`="") and (`cargo__companies`.`format`="Compact Cassette") and (`cargo__codeformat`.`format`="Compact Cassette") and not `cargo__releases`.`type`="1" and not `cargo__releases`.`type`="2" and not `cargo__releases`.`type`="-1" GROUP BY `cargo__releases`.`name` ORDER BY MIN(`cargo__releases`.`date`),`cargo__releases`.`name` LIMIT 1000 Function: CargoSQLQuery::run Error: 1021 Disk full (/tmp/#sql-temptable-15e6a-2a650a-ca.MAI); waiting for someone to free some space... (errno: 28 "No space left on device") (localhost)
Query: SELECT `cargo__companies`.`name` AS `companiesname`,`cargo__unreleased`.`name` AS `releasesname`,`cargo__unreleased`.`date` AS `date`,`cargo__companies`.`company` AS `company`,`cargo__companies`.`format` AS `format`,`cargo__companies`.`role` AS `role`,`cargo__companies`.`credited` AS `credited` FROM `cargo__unreleased` LEFT OUTER JOIN `cargo__companies` ON ((`cargo__unreleased`.`name`=`cargo__companies`.`name`)) WHERE (`cargo__companies`.`company`="Scitron" OR `cargo__companies`.`company`="" OR `cargo__companies`.`company`="" OR `cargo__companies`.`company`="" OR `cargo__companies`.`company`="" OR `cargo__companies`.`company`="") and (`cargo__companies`.`format`="Compact Cassette") GROUP BY `cargo__unreleased`.`name` ORDER BY `cargo__unreleased`.`date`,`cargo__unreleased`.`name` LIMIT 1000 Function: CargoSQLQuery::run Error: 1021 Disk full (/tmp/#sql-temptable-15e6a-2a650a-cd.MAI); waiting for someone to free some space... (errno: 28 "No space left on device") (localhost)
CD
Query: SELECT `cargo__companies`.`name` AS `companiesname`,`cargo__releases`.`name` AS `releasesname`,MIN(`cargo__releases`.`date`) AS `date)`,`cargo__companies`.`company` AS `company`,`cargo__companies`.`format` AS `format`,`cargo__companies`.`role` AS `role`,`cargo__companies`.`credited` AS `credited`,`cargo__codeformat`.`code` AS `test`,`cargo__codeformat`.`format` AS `test2`,`cargo__companies`.`specificrole` AS `specificrole` FROM `cargo__companies` LEFT OUTER JOIN `cargo__releases` ON ((`cargo__companies`.`name`=`cargo__releases`.`name`)) LEFT OUTER JOIN `cargo__codeformat` ON ((`cargo__releases`.`console`=`cargo__codeformat`.`code`)) WHERE (`cargo__companies`.`company`="Scitron" OR `cargo__companies`.`company`="" OR `cargo__companies`.`company`="" OR `cargo__companies`.`company`="" OR `cargo__companies`.`company`="" OR `cargo__companies`.`company`="") and (`cargo__companies`.`format`="CD") and (`cargo__codeformat`.`format`="CD") and not `cargo__releases`.`type`="1" and not `cargo__releases`.`type`="2" and not `cargo__releases`.`type`="-1" GROUP BY `cargo__releases`.`name` ORDER BY MIN(`cargo__releases`.`date`),`cargo__releases`.`name` LIMIT 1000 Function: CargoSQLQuery::run Error: 1021 Disk full (/tmp/#sql-temptable-15e6a-2a650a-d1.MAI); waiting for someone to free some space... (errno: 28 "No space left on device") (localhost)
Query: SELECT `cargo__companies`.`name` AS `companiesname`,`cargo__unreleased`.`name` AS `releasesname`,`cargo__unreleased`.`date` AS `date`,`cargo__companies`.`company` AS `company`,`cargo__companies`.`format` AS `format`,`cargo__companies`.`role` AS `role`,`cargo__companies`.`credited` AS `credited` FROM `cargo__unreleased` LEFT OUTER JOIN `cargo__companies` ON ((`cargo__unreleased`.`name`=`cargo__companies`.`name`)) WHERE (`cargo__companies`.`company`="Scitron" OR `cargo__companies`.`company`="" OR `cargo__companies`.`company`="" OR `cargo__companies`.`company`="" OR `cargo__companies`.`company`="" OR `cargo__companies`.`company`="") and (`cargo__companies`.`format`="CD") GROUP BY `cargo__unreleased`.`name` ORDER BY `cargo__unreleased`.`date`,`cargo__unreleased`.`name` LIMIT 1000 Function: CargoSQLQuery::run Error: 1021 Disk full (/tmp/#sql-temptable-15e6a-2a650a-d4.MAI); waiting for someone to free some space... (errno: 28 "No space left on device") (localhost)
Digital
Query: SELECT `cargo__companies`.`name` AS `companiesname`,`cargo__releases`.`name` AS `releasesname`,MIN(`cargo__releases`.`date`) AS `date)`,`cargo__companies`.`company` AS `company`,`cargo__companies`.`format` AS `format`,`cargo__companies`.`role` AS `role`,`cargo__companies`.`credited` AS `credited`,`cargo__codeformat`.`code` AS `test`,`cargo__codeformat`.`format` AS `test2`,`cargo__companies`.`specificrole` AS `specificrole` FROM `cargo__companies` LEFT OUTER JOIN `cargo__releases` ON ((`cargo__companies`.`name`=`cargo__releases`.`name`)) LEFT OUTER JOIN `cargo__codeformat` ON ((`cargo__releases`.`console`=`cargo__codeformat`.`code`)) WHERE (`cargo__companies`.`company`="Scitron" OR `cargo__companies`.`company`="" OR `cargo__companies`.`company`="" OR `cargo__companies`.`company`="" OR `cargo__companies`.`company`="" OR `cargo__companies`.`company`="") and (`cargo__companies`.`format`="Digital") and (`cargo__codeformat`.`format`="Digital") and not `cargo__releases`.`type`="1" and not `cargo__releases`.`type`="2" and not `cargo__releases`.`type`="-1" GROUP BY `cargo__releases`.`name` ORDER BY MIN(`cargo__releases`.`date`),`cargo__releases`.`name` LIMIT 1000 Function: CargoSQLQuery::run Error: 1021 Disk full (/tmp/#sql-temptable-15e6a-2a650a-d8.MAI); waiting for someone to free some space... (errno: 28 "No space left on device") (localhost)
Query: SELECT `cargo__companies`.`name` AS `companiesname`,`cargo__unreleased`.`name` AS `releasesname`,`cargo__unreleased`.`date` AS `date`,`cargo__companies`.`company` AS `company`,`cargo__companies`.`format` AS `format`,`cargo__companies`.`role` AS `role`,`cargo__companies`.`credited` AS `credited` FROM `cargo__unreleased` LEFT OUTER JOIN `cargo__companies` ON ((`cargo__unreleased`.`name`=`cargo__companies`.`name`)) WHERE (`cargo__companies`.`company`="Scitron" OR `cargo__companies`.`company`="" OR `cargo__companies`.`company`="" OR `cargo__companies`.`company`="" OR `cargo__companies`.`company`="" OR `cargo__companies`.`company`="") and (`cargo__companies`.`format`="Digital") GROUP BY `cargo__unreleased`.`name` ORDER BY `cargo__unreleased`.`date`,`cargo__unreleased`.`name` LIMIT 1000 Function: CargoSQLQuery::run Error: 1021 Disk full (/tmp/#sql-temptable-15e6a-2a650a-db.MAI); waiting for someone to free some space... (errno: 28 "No space left on device") (localhost)