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.
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 manufacturer Bandai
Showing All product(s) by “Bandai > Arsenal Toys” and sorted by Latest Addition. Total 468 product(s) found.
Page 0 of 16
| 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 `manufacturer_id` IN(971) 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: | Tuesday, October 6, 2026 at 11:05:44 AM |
| Script: | /products-manufacturer.php?man_id=971&pn=0 |