Ganja™

Array ( [store_id] => 26 [option_id] => 657 [entity_id] => 28 [attribute_id] => 263 [is_active] => 1 [brand_label] => Ganja™ [brand_url_key] => ganja [brand_description] =>

We're stocked up on Ganja™ fireworks!

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

We're stocked up on Ganja™ 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_5b53d69d13e513_59244419` 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 394.0000Killa 5 Inch XL Canister Shells | 24 Pack (case) | 3/24

Qty 125.0000Joints & Blunts (case) | 24/4

Qty 89.0000Jamrock 30 Shot XL Aerials (case) | 3/1

Qty 116.0000Galactic Jack 17 Shot Large Aerial (case) | 12/1

Qty 0.0000Killa 5 Inch XL Canister Shells (case) | 2/4/6

Qty 6.0000Cali Kush 24 Shot XL Aerials (case) | 2/1

Qty 22.0000Tropix 76 Shot Hexagon Large Aerial Finale Set (case) | 4/2

Qty 0.0000Kush 12 Shot Shell Cake (unit)

Qty 0.0000OG Kush 25 Shot Standard Aerial (each)

Qty 0.0000Hybrid 18 Shot Large Shell Cake Finale Set (case) | 2/1

Qty 0.0000Tropix Tangerine Haze 19 Shot Large Aerial (unit)

Qty 0.0000OG Kush 25 Shot Standard Aerial (each)

Qty 0.0000Killa 5 Inch XL Canister Shells | 6 Pack (unit)

Qty 0.0000Tropix Tropicali 19 Shot Large Aerial (unit)

Qty 0.0000OG Kush 25 Shot Standard Aerial (each)

34 items

Page
Set Ascending Direction
per page

34 items

Page
Set Ascending Direction
per page