Opening Hours: 12 pm to 8 pm (Mondays - Fridays), 12 pm to 6 pm (Saturdays, Sundays & Public Holidays), for exceptions, see below:
26 May (Tues): 12 pm to 6 pm
27 May (Wed) onwards: Normal Business Hours
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.
26 May (Tues): 12 pm to 6 pm
27 May (Wed) onwards: Normal Business Hours
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 Flame Toys
Showing All product(s) by “Flame Toys” and sorted by Latest Addition. Total 90 product(s) found.
Page 0 of 3
| 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(1145) 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: | Sunday, August 16, 2026 at 6:11:09 AM |
| Script: | /products-manufacturer.php?man_id=1145&pn=0 |