LED Filament

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 = '525' 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

28 Item(s)

per page
E27/ES 4W LED Helix Filament Pear Shaped Bulb AMBER 2200K 160lm Compare Products
E27 4W Amber Glass Diamond Globe Dimmable LED Filament Bulb Compare Products
B22/BC 4W LED Spiral Filament Tubular Bulb AMBER 2200K 160lm Compare Products
B22/BC 4W LED Helix Filament Pear Shaped Bulb AMBER 2200K 160lm Compare Products
Dimmable E27 XXL Jules 8W LED Filament Bulb AMBER 1800K Compare Products
MiniSun E27 4W LED Filament Pear Shaped Bulb AMBER Compare Products
MiniSun B22 4W LED Filament Pear Shaped Bulb AMBER Compare Products
Dimmable E27 4W LED Filament Pear Shaped Bulb AMBER 2700K Compare Products
MiniSun E27 4W LED Filament Radio Valve Bulb AMBER 2700K Compare Products
MiniSun B22 4W LED Filament Radio Valve Bulb AMBER 2700K Compare Products
MiniSun B22 4W LED Filament GLS Bulb AMBER 2700K Compare Products
MiniSun B22 6W LED Filament GLS Bulb CLEAR 2700K Compare Products
MiniSun E27 8W LED Filament GLS Bulb CLEAR 2700K Compare Products
MiniSun B22 8W LED Filament GLS Bulb CLEAR 2700K Compare Products
MiniSun E27 4W LED Filament GLS Bulb CLEAR 6500K Compare Products
MiniSun B22 4W LED Filament GLS Bulb CLEAR 6500K Compare Products
MiniSun E27 6W LED Filament Giant Globe Bulb AMBER 2700K Compare Products
MiniSun B22 6W LED Filament Giant Globe Bulb AMBER 2700K Compare Products
MiniSun E14 2W LED Filament Candle Bulb AMBER 2700K Compare Products
MiniSun E14 2W LED Filament Candle Bulb CLEAR 2700K Compare Products
MiniSun E14 4W LED Filament Candle Bulb CLEAR 2700K Compare Products
Dimmable E14 4W LED Filament Candle Bulb CLEAR 2700K Compare Products
MiniSun E27 3W LED Filament Tubular Bulb AMBER 2700K Compare Products
MiniSun SES 4W LED Filament Golfball Bulb Amber 2700K Compare Products
MiniSun SES 4W LED Filament Golfball Bulb Clear 2700K Compare Products
MiniSun SES 4W LED Filament Golfball Bulb Clear 6500K Compare Products
MiniSun E27 4W LED Filament GLS Bulb AMBER 2700K Compare Products
MiniSun E27 6W LED Filament GLS Bulb CLEAR 2700K Compare Products

28 Item(s)

per page