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 = '552' 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 96

Page:
  1. 1
  2. 2
per page
Manti Matt Black Designer Floor Lamp (NO SHADE) Compare Products
Rorik Skandi Tripod Floor Lamp Silver (NO SHADE) Compare Products
Rorik Skandi Tripod Floor Lamp Black (NO SHADE) Compare Products
Vida Modern Single Stem Black Floor Lamp (NO SHADE) Compare Products
Barbro Black Wood Tripod Floor Lamp (NO SHADE)

Out of stock

Compare Products
Barbro Light Wood Tripod Floor Lamp (NO SHADE) Compare Products
Clipper Grey / Chrome Tripod Floor Lamp Base Only Compare Products
Memphis Twist Traditional Antique Brass Floor Lamp (NO SHADE Compare Products
Rousse Large Curved Black Floor Lamp (NO SHADE) Compare Products
Camden Tripod Floor Lamp Grey (BASE ONLY) Compare Products
Orick Chrome Floor Lamp / Flexi Arm Reading Light (NO SHADE) Compare Products
Eleanor Gold Floor Lamp with Clear Acrylic Balls (NO SHADE) Compare Products
Manti Copper Designer Floor Lamp (NO SHADE) Compare Products
Manti Cool Grey Designer Floor Lamp (NO SHADE) Compare Products
Bedford Tripod Floor Lamp Gloss Black / Silver (BASE ONLY)

Out of stock

Compare Products
Bedford Tripod Floor Lamp Gloss Black / Copper (BASE ONLY) Compare Products
Vintage Gold Style Candlestick Floor Lamp (NO SHADE) Compare Products
Vintage Silver Style Candlestick Floor Lamp (NO SHADE) Compare Products
Camden Tripod Floor Lamp CHROME (BASE ONLY) Compare Products
Camden Tripod Floor Lamp Gloss White (BASE ONLY) Compare Products
Camden Tripod Floor Lamp Gloss Black (BASE ONLY)

Out of stock

Compare Products
Crawford Tripod Floor Lamp Cool Grey Painted (BASE ONLY) Compare Products
Charlie Grey Painted Modern Stem Floor Lamp (NO SHADE) Compare Products
Eleanor Chrome Floor Lamp with Clear Acrylic Balls (NO SHADE Compare Products
Angus Pewter Grey Geometric Adjustable Floor Lamp Compare Products

Ducy 3 Way Floor Lamp Chrome

Product Code: 24083
Ducy 3 Way Floor Lamp Chrome Compare Products
Marr 18W LED Uplighter Floor Lamp 1620lm Memory Dimmer Compare Products
ICONIC Fiske Floor Lamp Copper / Matt Black Compare Products
Morpho Tripod Floor Lamp Black with Gold Inner Shade

Out of stock

Compare Products
ICONIC Hensley Black / Brass Floor Lamp

Out of stock

Compare Products
ICONIC Dorian Copper Retro Dome Shade Floor Lamp Compare Products
ICONIC Dorian Matt Black Retro Dome Shade Floor Lamp Compare Products
ICONIC Forton Adjustable Floor Lamp Copper Compare Products
Alysha Satin Nickel Modern Skandi Floor Lamp Compare Products
Rocha 3 Way Chrome Floor Lamp with Linen Grey Drum Shade Compare Products
Twister GU10 Floor Uplighter Black Compare Products
Clipper White Wood / Chrome Tripod Floor Lamp Base Only Compare Products
Clipper Black Wood / Chrome Tripod Floor Lamp Base Only Compare Products
Clipper Light Wood / Chrome Tripod Floor Lamp Base Only Compare Products
Rowe Slim Cool Grey Floor Lamp (BASE ONLY) Compare Products
Rowe Slim Matt Black Floor Lamp (BASE ONLY) Compare Products
Theydon Satin Nickel Stem & Ball Floor Lamp (BASE ONLY) Compare Products
Theydon Copper Stem & Ball Floor Lamp (BASE ONLY) Compare Products
Argent Grey 3 Way Floor Lamp With Shades Compare Products

Twister GU10 Floor Uplighter Grey

Product Code: 24452
Twister GU10 Floor Uplighter Grey Compare Products
Jaspa Polished Chrome Wire Floor Lamp (BASE ONLY) Compare Products
Brampton Eyelet  Chrome Floor Lamp (NO SHADE) Compare Products
Angus Copper Geometric Adjustable Floor Lamp Compare Products

1 - 48 of 96

Page:
  1. 1
  2. 2
per page