Difference between revisions of "Aspect (publisher)"
From Sega Retro
m (Text replacement - "| tseries= |" to "|") |
|||
Line 5: | Line 5: | ||
| founded=1985-12 | | founded=1985-12 | ||
| defunct= | | defunct= | ||
− | |||
| mergedwith= | | mergedwith= | ||
| mergedinto= | | mergedinto= |
Revision as of 09:35, 24 September 2021
This teeny-tiny article needs some work. You can help us by expanding it.
Aspect (アスペクト) is a Japanese book publisher. Establishment, they were a subsidiary of ASCII. From 2002 to 2004, they become a Sega subsidiary and published official game guidebooks.
Books
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`="Aspect (publisher)") and (`cargo__companies`.`role` LIKE "Publisher%") and (`cargo__companies`.`format`="book") and (`cargo__codeformat`.`format`="book") 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-2c4b17-1f6.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`="Aspect (publisher)") and (`cargo__companies`.`role` LIKE "Publisher%") and (`cargo__companies`.`format`="book") 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-2c4b17-1f9.MAI); waiting for someone to free some space... (errno: 28 "No space left on device") (localhost)
External links
- Official website (Japanese)