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 = '545' 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 198

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

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
Dalston Marble Effect Geometric Table Lamp Base Compare Products
Dalston Terrazzo Effect Geometric Table Lamp Base Compare Products
Harmony Mosaic Chrome Table Lamp with Grey Shade Compare Products
Harmony Mosaic Chrome Table Lamp with Black Shade Compare Products

Argent Grey Table Lamp With Shade

Product Code: 23304
Argent Grey Table Lamp With Shade Compare Products
Unicorn Ceramic Table Lamp with White Tapered Shade Compare Products
Talus Chrome / Burgundy Stem Table Lamp (NO SHADE) Compare Products
Theydon Copper Stem & Ball Table Lamp (BASE ONLY) Compare Products
Theydon Satin Nickel Stem & Ball Table Lamp (BASE ONLY) Compare Products
Clarke Satin Nickel Stem Table Lamp / USB Charger (NO SHADE) Compare Products
Clipper Light Wood / Chrome Tripod Table Lamp Base Only Compare Products
Clipper Black Wood / Chrome Tripod Table Lamp Base Only Compare Products
Clipper White Wood / Chrome Tripod Table Lamp Base Only Compare Products
Camden Tripod Table Lamp Copper Painted (BASE ONLY) Compare Products
Levon Mirrored Tile Pear Table Lamp (NO SHADE) Compare Products
Camden Tripod Table Lamp Chrome (BASE ONLY)

Out of stock

Compare Products
Camden Tripod Table Lamp Gloss Black (BASE ONLY) Compare Products
Caribou Antler Table Lamp Natural Finish (BASE ONLY) Compare Products
Gosforth Twist Copper Table Lamp (NO SHADE)

Out of stock

Compare Products
Davenport Extra Large K9 Crystal Table Lamp (NO SHADE) Compare Products

1 - 48 of 198

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