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

97 - 138 of 138

Page:
  1. 1
  2. 2
  3. 3
per page
MiniSun 5W LED COB GU10 Dimmable Bulb in Cool White Compare Products
MiniSun 5W LED COB GU10 Dimmable Bulb in Warm White Compare Products
MiniSun Dimmable A70 B22 15W LED GLS Bulb 6500K 1520lm Compare Products
MiniSun E27 10W LED RGB Bulb With Remote Control Compare Products
MiniSun B22 10W LED RGB Bulb With Remote Control Compare Products
E27 ES LED Dusk Till Dawn Sensor 5W Bulb 6500K 470lm Compare Products
B22 BC LED Dusk Till Dawn Sensor 10W Bulb 6500K 800lm Compare Products
Large 6W E27 Dimmable Opal Decor Bulb (G125) 4500K Compare Products
Large 6W B22 Dimmable Opal Decor Bulb (G125) 4500K Compare Products
E27 4W Amber Glass Diamond Globe Dimmable LED Filament Bulb Compare Products
E27/ES 4W LED Helix Filament Pear Shaped Bulb AMBER 2200K 160lm 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 30w BC Energy Saving Daylight Spiral Bulb 6500k Compare Products
MiniSun 30w ES Energy Saving Daylight Spiral Bulb 6500k Compare Products
MiniSun 13w BC Energy Saving Daylight Spiral Bulb 6500k Compare Products
MiniSun 13w ES Energy Saving Daylight Spiral Bulb 6500k Compare Products
MiniSun SES 20w Energy Saving Daylight Spiral Bulb Compare Products

MiniSun 11w ES CFL Bulb 2700K

Product Code: 18420
MiniSun 11w ES  CFL Bulb 2700K Compare Products

MiniSun 11w BC CFL Bulb 2700K

Product Code: 18421
MiniSun 11w BC  CFL Bulb 2700K Compare Products

MiniSun 20w BC CFL Bulb 2700K

Product Code: 18423
MiniSun 20w BC  CFL Bulb 2700K Compare Products

MiniSun Pack of 10 25w G9 Halogen Bulbs

Product Code: 16467
Discontinued
MiniSun Pack of 10 25w G9 Halogen Bulbs Compare Products

MiniSun Pack of 10 40w G9 Halogen Bulb

Product Code: 16468
Discontinued
MiniSun Pack of 10 40w G9 Halogen Bulb Compare Products

MiniSun Pack of 10 10w 12v G4 Halogen Capsule Bulb

Product Code: 16469
Discontinued
MiniSun Pack of 10 10w 12v G4 Halogen Capsule Bulb Compare Products
MiniSun Pack of 10 20w 12v G4 Halogen Capsule Bulb Compare Products

MiniSun 28w SES R50 Halogen Energy Reducing Bulb

Product Code: 16150
Discontinued
MiniSun 28w with SES Cap R50 Halogen Energy Reducing Bulb Compare Products
MiniSun 42w SES Golfball Halogen Energy Reducing Bulb Compare Products
MiniSun 6W LED 12V MR16 Bulb 2700K Thermo Plastic Body 120° Compare Products
MiniSun 6W LED 12V MR16 Bulb 6000K Thermo Plastic Body 120° Compare Products
MiniSun 6w GX53 LED Bulb 6500K Daylight 300lm Compare Products
MiniSun 4W SES R39 Reflector LED Bulb 4500K 400lm Compare Products
MiniSun 5W SES LED R50 Reflector Spot Light Bulb 3000K 450lm Compare Products
MiniSun 5W SES LED R50 Reflector Spot Light Bulb 6500K 450lm Compare Products
MiniSun 6W ES R63 Frosted Glass Reflector LED Bulb 6500K Compare Products
MiniSun 6W ES R63 Frosted Glass Reflector LED Bulb 3000K

Out of stock

Compare Products
Chrome Single LED Dimmer Switch 4VA - 200VA Compare Products
Chrome Double LED Dimmer Switch 4VA - 200VA Compare Products
Satin Nickel Single LED Dimmer Switch 4VA - 200VA Compare Products
Satin Nickel Double LED Dimmer Switch 4VA - 200VA Compare Products
Black Chrome Single LED Dimmer Switch 4VA - 200VA Compare Products
Black Chrome Double LED Dimmer Switch 4VA - 200VA Compare Products

97 - 138 of 138

Page:
  1. 1
  2. 2
  3. 3
per page
See our full range of lamps.