See our full range of lamps.
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 = '524' 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 INNER JOIN `catalog_product_index_eav` AS `bulb_shape_idx` ON bulb_shape_idx.entity_id = e.entity_id AND bulb_shape_idx.attribute_id = '513' AND bulb_shape_idx.store_id = 8 AND bulb_shape_idx.value IN('1254') WHERE (e.status = 1) ORDER BY `cat_index_position` ASC, `cat_index`.`position` ASC LIMIT 48

22 Item(s)

per page
MiniSun SES 4w 36 SMD LED Candle Bulb 2700k 330 Lumens Compare Products
MiniSun SBC 4w 36 SMD LED Candle Bulb 2700k 330 Lumens

Out of stock

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 4W ES Frosted Candle LED Thermo Plastic Bulb 3000K Compare Products
MiniSun 4W ES 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 4W BC Frosted Candle LED Thermo Plastic Bulb 6500K Compare Products
MiniSun 4W BC Frosted Candle LED Thermo Plastic Bulb 3000K 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
MiniSun DIMMABLE 4W BC Thermo Plastic Frosted Candle 3000K Compare Products
MiniSun DIMMABLE 4W BC Thermo Plastic Frosted Candle 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 5W SES Thermo Plastic Frosted Candle 3000K Compare Products
Dimmable E14 4W LED Filament Candle Bulb CLEAR 2700K Compare Products
Dimmable E27 4W LED Filament Pear Shaped Bulb AMBER 2700K Compare Products

MiniSun 42w SES Candle Halogen Energy Reducing Bulb

Product Code: 16145
Discontinued
MiniSun 42w SES Candle Halogen Energy Reducing Bulb

Out of stock

Compare Products

MiniSun 28w SES Candle Halogen Energy Reducing Bulb

Product Code: 16146
Discontinued
MiniSun 28w SES Candle Halogen Energy Reducing Bulb

Out of stock

Compare Products

22 Item(s)

per page
See our full range of lamps.