After Dark™

Array ( [store_id] => 26 [option_id] => 654 [entity_id] => 6 [attribute_id] => 263 [is_active] => 1 [brand_label] => After Dark™ [brand_url_key] => after-dark [brand_description] =>

We're stocked up on After Dark™ fireworks!

[brand_meta_description] => Shop online for After Dark™ fireworks at Red Apple. We offer a 100% no duds guarantee and we ship right to your home! [brand_thumbnail] => [brand_cover] => wysiwyg/brands/after-dark-brand-header.jpg [brand_meta_title] => Buy After Dark™ Fireworks Online at Red Apple! [brand_meta_keyword] => After Dark fireworks [brand_is_featured] => 1 [url] => https://www.redapplefireworks.com/brand/after-dark [thumbnail] => https://www.redapplefireworks.com/media/codazon_cache/brand/250x/codazon/brand/placeholder_thumbnail.jpg [attribute_code] => mgs_brand )

We're stocked up on After Dark™ fireworks!

Default Category
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='2' 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_5b53d64aa73496_64708876` AS `search_result` ON e.entity_id = search_result.entity_id ORDER BY IF(stock_status_index.qty > 0, 0, 1), `qty` desc LIMIT 15
Qty 317.0000Corpse Cannon & Brain Blaster 146 Shot Barrage Candle (case) | 2/4

Qty 235.0000Outbreak 51 Shot XL Aerial Finale Set (case) | 2/2

Qty 235.0000Y-Bombs Crackling Artillery Shells (case) | 12/6

Qty 229.0000Z-Bombs Whistling Artillery Shells (case) | 12/6

Qty 185.0000X-Bombs Assorted Effect Artillery Shells (case) | 12/6

Qty 87.0000Zom-Box / Zed-Box (case) | 2/1

Qty 124.0000After Dark 50 Shot XL Aerial Finale Set (case) | 2/2

Qty 0.0000Zom-Box / Zed-Box (unit)

Qty 1.0000Head Shots 5 Shots XL Roman Candles (case) | 18/2/2

Qty 0.0000Corpse Cannon 146 Shot Barrage Candle (unit)

Qty 0.0000Z-Bombs Whistling Artillery Shells (unit)

Qty 0.0000X-Bombs Assorted Effect Artillery Shells (unit)

Qty 0.0000Outbreak Epidemic 26 Shot XL Aerial (unit)

Qty 0.0000Patient Zero 24 Shot Standard Aerial (unit)

Qty 0.0000Brain Blaster 146 Shot Barrage Candle (unit)

20 items

Page
Set Ascending Direction
per page

20 items

Page
Set Ascending Direction
per page