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('1503') WHERE (e.status = 1) ORDER BY `cat_index_position` ASC, `cat_index`.`position` ASC LIMIT 48

26 Item(s)

per page
MiniSun B22 6W LED SMD GLS Bulb 3000K 500lm Thermal Plastic Compare Products
MiniSun B22 6W LED SMD GLS Bulb 6500K 500lm Thermal Plastic Compare Products
MiniSun E27 6W LED SMD GLS Bulb 3000K 500lm Thermal Plastic Compare Products
MiniSun E27 6W LED SMD GLS Bulb 6500K 500lm Thermal Plastic Compare Products
MiniSun B22 10W LED SMD GLS Bulb 3000K 800lm Thermal Plastic Compare Products
MiniSun E27 10W LED SMD GLS Bulb 3000K 800lm Thermal Plastic Compare Products
MiniSun E27 10W LED SMD GLS Bulb 6500K 800lm Thermal Plastic Compare Products
MiniSun E27 4W LED Filament Pear Shaped Bulb AMBER Compare Products
B22 LED Dusk Till Dawn Sensor 7W Bulb BC Neutral White 4800K Compare Products
E27 LED Dusk Till Dawn Sensor 7W Bulb ES Neutral White 4800K Compare Products
MiniSun B22 4W LED Filament Pear Shaped Bulb AMBER Compare Products
MiniSun B22 4W LED Filament GLS Bulb CLEAR 6500K 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 E27 4W LED Filament GLS Bulb AMBER 2700K Compare Products
MiniSun E27 6W LED Filament GLS Bulb CLEAR 2700K Compare Products
MiniSun B22 6W 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 E27 8W LED Filament GLS Bulb CLEAR 2700K Compare Products
MiniSun DIMMABLE 7W ES Thermo Plastic Frosted GLS Bulb 3000K Compare Products
MiniSun DIMMABLE 7W BC Thermo Plastic Frosted GLS Bulb 3000K Compare Products
MiniSun B22 4W LED Filament GLS Bulb AMBER 2700K Compare Products
MiniSun E27 10W LED RGB Bulb With Remote Control Compare Products
MiniSun B22 10W LED RGB Bulb With Remote Control Compare Products
B22 BC LED Dusk Till Dawn Sensor 10W Bulb 6500K 800lm Compare Products

26 Item(s)

per page
See our full range of lamps.