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

1 - 48 of 340

Page:
  1. 1
  2. 2
  3. 3
  4. 4
  5. 5
per page
Hannah Wood And Light Pink LED Task Lamp Compare Products
Monda Cool Grey Adjustable Desk Lamp Compare Products
Edvard 6W LED Grey Flexible Desk Lamp Compare Products
Edvard 6W LED Grey Flexible Clamp Lamp Compare Products
Edvard 6W LED Chrome Flexible Clamp Lamp Compare Products
Marley Matt Black Curved Desk Lamp Red Flex Compare Products
Arkwright Matt Black Curved Desk Lamp Compare Products
Excee Matt Black Modern Desk Lamp Compare Products
Polaris Black 5w 6500K 350lm Dimmable Task Lamp

Out of stock

Compare Products

Portishead Cream Clip Spotlight

Product Code: 21619
Portishead Cream Clip Spotlight Compare Products
Portishead Satin Nickel Clip Spotlight

Out of stock

Compare Products
Portishead Satin Copper Clip Spotlight Compare Products

Tasca Red Clip On Spot Lamp

Product Code: 19653
Tasca Red Clip On Spot Lamp Compare Products

Portishead White Clip Spotlight

Product Code: 21617
Portishead White Clip Spotlight Compare Products
Portishead Duck Egg Blue Clip Spotlight Compare Products
Linea Silver 6W LED Adjustable Clamp Desk / Task Lamp Compare Products

Tasca White Clip On Spot Lamp

Product Code: 19651
Tasca White Clip On Spot Lamp Compare Products
KLO White Flexi Neck Clip-on Desk / Task Lamp Compare Products
Huey Single White Clip On Lamp 3W LED Lamp 6000K Compare Products
Hannah Wood and White LED Task Lamp Compare Products

Cylinder Table Lamp Satin Nickel

Product Code: 15937
Cylinder Table Lamp Satin Nickel Compare Products
ICONIC Forton Adjustable Desk Lamp Copper Compare Products
ICONIC Eleanor XL Ribbed Silver Table Lamp with Shade Compare Products
ICONIC Dorian Matt Black Retro Dome Shade Table Lamp Compare Products
ICONIC Dorian Copper Retro Dome Shade Table Lamp Compare Products
Unicorn Ceramic Table Lamp with Dusky Pink Tapered Shade Compare Products
ICONIC Hensley Black / Brass Table Lamp Compare Products
Casco Curved Table Lamp Chrome (NO SHADE) Compare Products
Casco Curved Table Lamp Antique Brass (NO SHADE) Compare Products
Sorrell 2 Tone Grey Ceramic Table Lamp Compare Products
Tokay 2 Tone Aged Copper/Copper Glass Table Lamp with Shade Compare Products
Tokay 2 Tone Aged Nickel Smoked Glass Table Lamp with Shade Compare Products
Vallda Grey Copper Banded Table Lamp with White Drum Shade Compare Products
Vallda Grey Silver Banded Table Lamp with White Drum Shade Compare Products
Alysha Satin Nickel Modern Skandi Desk Lamp Compare Products
Rocha 3 Way Chrome Table Lamp with Linen Grey Drum Shade Compare Products
Mella Mushroom Table Lamp Copper / Grey Compare Products
Maine Chrome Marble Base Table Lamp Opal Glass Shade Compare Products

Castoro 3 Way Pendant Drop Chrome

Product Code: 22961
Castoro 3 Way Pendant Drop Chrome Compare Products
Monkey Holding a Light Bulb Table Lamp Black

Out of stock

Compare Products
Monkey Holding a Light Bulb Table Lamp White

Out of stock

Compare Products
Monkey Holding a Light Bulb Table Lamp Metallic Gold

Out of stock

Compare Products
Lumikki K9 Crystal Table Lamp with White Faux Silk Drum Shad Compare Products
Casco Table Lamp Base Chrome (NO SHADE) Compare Products
Casco Table Lamp Base Antique Brass (NO SHADE) Compare Products
Casco Table Lamp Base Copper (NO SHADE) Compare Products
Casco Table Lamp Base Matt Black (NO SHADE) Compare Products
Dalston Grey Geometric Table Lamp Base Compare Products

1 - 48 of 340

Page:
  1. 1
  2. 2
  3. 3
  4. 4
  5. 5
per page