Barrage Candles

Barrage Candles
SELECT `e`.*, `cat_index`.`position` AS `cat_index_position`, `price_index`.`price`, `price_index`.`tax_class_id`, `price_index`.`final_price`, IF(price_index.tier_price IS NOT NULL, LEAST(price_index.min_price, price_index.tier_price), price_index.min_price) AS `minimal_price`, `price_index`.`min_price`, `price_index`.`max_price`, `price_index`.`tier_price`, `stock_status_index`.`stock_status` AS `is_salable` FROM `catalog_product_entity` AS `e` INNER JOIN `catalog_category_product_index` AS `cat_index` ON cat_index.product_id=e.entity_id AND cat_index.store_id=26 AND cat_index.visibility IN(2, 4) AND cat_index.category_id='213' INNER JOIN `catalog_product_index_price` AS `price_index` ON price_index.entity_id = e.entity_id AND price_index.website_id = '1' AND price_index.customer_group_id = 0 LEFT JOIN `cataloginventory_stock_status` AS `stock_status_index` ON e.entity_id = stock_status_index.product_id AND stock_status_index.website_id = 0 AND stock_status_index.stock_id = 1 INNER JOIN `search_tmp_5b5228bc8fc5d5_12425652` AS `search_result` ON e.entity_id = search_result.entity_id ORDER BY IF(stock_status_index.qty > 0, 0, 1), IF(stock_status_index.qty > 0, 0, 1), `qty` desc, `qty` desc LIMIT 15
Qty 317.0000Corpse Cannon & Brain Blaster 146 Shot Barrage Candle (case) | 2/4

Qty 216.0000UV 182 Shot Neon Barrage Candle (case) | 4/2

Qty 49.0000Neon Fusion Barrage Candles (case) | 1/8

Qty 25.0000Neon Pink Barrage Candles (case) | 1/8

Qty 17.0000Neon Blue Barrage Candles (case) | 1/8

Qty 6.0000American Glory 220 Shot Barrage Candle (case) | 2/4

Qty 0.0000UV 182 Shot Neon Barrage Candle (case) | 6/2

Qty 0.0000Giant Panda Bamboo Shoots 192 Shot Roman Candle Barrage (case) | 12/1

Qty 0.0000UV 182 Shot Neon Barrage Candle (unit)

Qty 0.0000Corpse Cannon 146 Shot Barrage Candle (unit)

Qty 0.0000UV 182 Shot Neon Barrage Candle (unit)

Qty 0.0000Brain Blaster 146 Shot Barrage Candle (unit)

12 Items

Set Ascending Direction
per page

SHIP THESE FIREWORKS to your door, or PICK THEM UP in our stores.

12 Items

Set Ascending Direction
per page