SELECT `e`.`entity_id`, `e`.`type_id`, `e`.`attribute_set_id`, `cat_index`.`position` AS `cat_index_position`, `e`.`name`, `e`.`short_description`, `e`.`sku`, `e`.`price`, `e`.`special_price`, `e`.`special_from_date`, `e`.`special_to_date`, `e`.`small_image`, `e`.`thumbnail`, `e`.`color`, `e`.`color_value`, `e`.`news_from_date`, `e`.`news_to_date`, `e`.`status`, `e`.`tax_class_id`, `e`.`url_key`, `e`.`required_options`, `e`.`image_label`, `e`.`small_image_label`, `e`.`thumbnail_label`, `e`.`price_type`, `e`.`weight_type`, `e`.`price_view`, `e`.`shipment_type`, `e`.`links_purchased_separately`, `e`.`was_price`, `e`.`actual_wattage`, `e`.`cap_type`, `e`.`cap_type_value`, `e`.`bulb_types`, `e`.`bulb_types_value`, `e`.`bulb_shape`, `e`.`bulb_shape_value`, `e`.`material`, `e`.`finish`, `e`.`colour`, `e`.`msrp_enabled`, `e`.`msrp_display_actual_price_type`, `e`.`msrp`, `e`.`links_exist`, `e`.`is_imported`, `e`.`collection_style`, `e`.`collection_style_value`, `e`.`lookbook`, `e`.`lookbook_value`, `e`.`lookbook_image`, `e`.`beam_angle`, `e`.`beam_angle_value`, `e`.`bulb_colour_temperature`, `e`.`bulb_colour_temperature_value`, `e`.`equivilent_wattage`, `e`.`equivilent_wattage_value`, `e`.`bulb_lumens`, `e`.`google_promotion_code`, `e`.`google_promotion_code_value`, `e`.`high_street_price`, `e`.`bulb_qty`, `e`.`productpage_image`, `e`.`is_new`, `e`.`discontinued`, `e`.`cut_out_hole_size`, `e`.`product_type`, `e`.`style`, `e`.`offers`, `e`.`filter_collection`, `e`.`touch_activated_lhn`, `e`.`touch_activated_lhn_value`, `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` FROM `catalog_product_flat_8` AS `e` INNER JOIN `catalog_category_product_index` AS `cat_index` ON cat_index.product_id=e.entity_id AND cat_index.store_id=8 AND cat_index.visibility IN(2, 4) AND cat_index.category_id = '669' INNER JOIN `catalog_product_index_price` AS `price_index` ON price_index.entity_id = e.entity_id AND price_index.website_id = '4' AND price_index.customer_group_id = 0 WHERE (e.status = 1) ORDER BY `cat_index_position` ASC, `cat_index`.`position` ASC LIMIT 48

15 Item(s)

per page
MiniSun 4W ES Frosted Candle LED Thermo Plastic Bulb 3000K Compare Products
MiniSun 4W BC Frosted Candle LED Thermo Plastic Bulb 3000K Compare Products
MiniSun 4W ES Frosted Candle LED Thermo Plastic Bulb 6500K Compare Products
MiniSun 4W BC Frosted Candle LED Thermo Plastic Bulb 6500K Compare Products
MiniSun 4W SES Frosted Candle LED Thermo Plastic Bulb 3000K Compare Products
MiniSun 4W SES Frosted Candle LED Thermo Plastic Bulb 6500K Compare Products
MiniSun DIMMABLE 4W ES Thermo Plastic Frosted Candle 3000K Compare Products
MiniSun DIMMABLE 4W ES Thermo Plastic Frosted Candle 6500K Compare Products
MiniSun DIMMABLE 4W BC Thermo Plastic Frosted Candle 3000K Compare Products
MiniSun DIMMABLE 4W BC Thermo Plastic Frosted Candle 6500K Compare Products
MiniSun SES 4w 36 SMD LED Candle Bulb 2700k 330 Lumens

Out of stock

Compare Products
MiniSun SBC 4w 36 SMD LED Candle Bulb 2700k 330 Lumens Compare Products
MiniSun ES 4w 36 SMD LED Candle Bulb 6000k 330 Lumens Compare Products
MiniSun BC 4w 36 SMD LED Candle Bulb 6000k 330 Lumens Compare Products
MiniSun DIMMABLE 5W SES Thermo Plastic Frosted Candle 3000K Compare Products

15 Item(s)

per page