Difference between revisions of "Kin Wai (Hong Kong) Investment Limited"
From Sega Retro
Line 1: | Line 1: | ||
{{CompanyBob | {{CompanyBob | ||
| logo= | | logo= | ||
− | | founded= | + | | founded=1999 |
| defunct= | | defunct= | ||
| mergedwith= | | mergedwith= |
Revision as of 19:00, 23 May 2023
This teeny-tiny article needs some work. You can help us by expanding it.
Kin Wai (Hong Kong) Investment Limited was a Asian company specifying in production of Mega Drive bootlegs of consoles and games for Ukrainian market. Video consoles and manuals were localized into Ukrainian, Russian and English but video games only to Russian and English. Products were distributed domestically by TOV Kombat.
Hardware
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`="Kin Wai (Hong Kong) Investment Limited" OR `cargo__companies`.`company`="" OR `cargo__companies`.`company`="" OR `cargo__companies`.`company`="" OR `cargo__companies`.`company`="" OR `cargo__companies`.`company`="") and (`cargo__releases`.`type`="2" or `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-53c773-20cf.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`="Kin Wai (Hong Kong) Investment Limited" OR `cargo__companies`.`company`="" OR `cargo__companies`.`company`="" OR `cargo__companies`.`company`="" OR `cargo__companies`.`company`="" OR `cargo__companies`.`company`="") and (`cargo__companies`.`format`="hardware") 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-53c773-20d2.MAI); waiting for someone to free some space... (errno: 28 "No space left on device") (localhost)
- Mega Drive 2 (ZW-162) (200x)
- Sega-Boy (200x)
- Sega-Boy 2 (200x)
List of bootleg releases
Query: SELECT `pagename` AS `pagename`,`name` AS `name`,`name2` AS `name2`,`code` AS `code` FROM `cargo__bootlegs` WHERE distributor="Kin Wai (Hong Kong) Investment Limited" and name != "" GROUP BY `pagename` ORDER BY `name` LIMIT 5000 Function: CargoSQLQuery::run Error: 1021 Disk full (/tmp/#sql-temptable-15e6a-53c773-20d4.MAI); waiting for someone to free some space... (errno: 28 "No space left on device") (localhost)
List of multi-cart releases
Query: SELECT `pagename` AS `pagename`,`name` AS `name`,`name2` AS `name2`,`code` AS `code` FROM `cargo__multicarts` WHERE distributor="Kin Wai (Hong Kong) Investment Limited" and name != "" GROUP BY name,code ORDER BY `name` LIMIT 5000 Function: CargoSQLQuery::run Error: 1021 Disk full (/tmp/#sql-temptable-15e6a-53c773-20d6.MAI); waiting for someone to free some space... (errno: 28 "No space left on device") (localhost)