Chogokin - The Falcon's Hangar

Opening Hours: 12 pm to 8 pm (Mondays - Fridays), 12 pm to 6 pm (Saturdays, Sundays & Public Holidays), for exceptions, see below:

For US Customers, due to the removal of the De Minimis exemption for goods less than $800, your packages will be subjected to tariff bills moving forward. For more information on how this would affect your purchases, please visit our FAQ for details.

Products by category Chogokin

Showing All product(s) in “Chogokin” and sorted by Latest Addition. Total 429 product(s) found.

Page 0 of 15

Database Error
Message:	MySQL Query fail: SELECT *, (SELECT `name` FROM `manufacturers` WHERE `manufacturers`.`id`=`product`.`manufacturer_id`) AS man_name, (SELECT `name` FROM `category` WHERE `category`.`id`=`product`.`category_id`) AS cat1_name, (SELECT `name` FROM `category` WHERE `category`.`id`=`product`.`category_id2`) AS cat2_name FROM `product` WHERE `active`=1 AND `for_wholesale`='0' AND `id` IN (SELECT `prod_id` FROM `category_product` WHERE `cat_id` IN(37,38,39,113,166,280,286,382,468,495,582,612,725,759,793,813,920,943,1077,1122,1198,1260,2077,2148,2383,3012,3182,3370)) ORDER BY `do` ASC, `created_date` DESC, `id` DESC limit -30, 30
MySQL Error:	You have an error in your SQL syntax; check the manual that corresponds to your MariaDB server version for the right syntax to use near '-30, 30' at line 9
Date:	Thursday, October 15, 2026 at 6:55:42 PM
Script:	/products-category.php?cat_id=37&pn=0

Database Error

Message:

MySQL Query fail: SELECT *, (SELECT `name` FROM `manufacturers` WHERE `manufacturers`.`id`=`product`.`manufacturer_id`) AS man_name, (SELECT `name` FROM `category` WHERE `category`.`id`=`product`.`category_id`) AS cat1_name, (SELECT `name` FROM `category` WHERE `category`.`id`=`product`.`category_id2`) AS cat2_name FROM `product` WHERE `active`=1 AND `for_wholesale`='0' AND `id` IN (SELECT `prod_id` FROM `category_product` WHERE `cat_id` IN(37,38,39,113,166,280,286,382,468,495,582,612,725,759,793,813,920,943,1077,1122,1198,1260,2077,2148,2383,3012,3182,3370)) ORDER BY `do` ASC, `created_date` DESC, `id` DESC limit -30, 30

MySQL Error:

You have an error in your SQL syntax; check the manual that corresponds to your MariaDB server version for the right syntax to use near '-30, 30' at line 9

Date:

Thursday, October 15, 2026 at 6:55:42 PM

Script:

/products-category.php?cat_id=37&pn=0

Database Error
Message:	Invalid query_id: 0. Records could not be fetched.
MySQL Error:	You have an error in your SQL syntax; check the manual that corresponds to your MariaDB server version for the right syntax to use near '-30, 30' at line 9
Date:	Thursday, October 15, 2026 at 6:55:42 PM
Script:	/products-category.php?cat_id=37&pn=0