New In

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 = '859' 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 192

193 - 240 of 275

Page:
  1. 2
  2. 3
  3. 4
  4. 5
  5. 6
per page
Argent Grey 3 Way Floor Lamp With Shades Compare Products
MKT 4m Copper 40 Light LED Chain Light 3000K Compare Products
Unicorn Ceramic Table Lamp with White Tapered Shade Compare Products
Cheyenne NE Faux Feather Ball Pendant White 300mm Compare Products
Cheyenne NE Faux Feather Ball Pendant Pink 300mm 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
Theydon Copper Stem & Ball Floor Lamp (BASE ONLY) Compare Products
Theydon Satin Nickel Stem & Ball Floor Lamp (BASE ONLY) Compare Products
Rowe Slim Matt Black Floor Lamp (BASE ONLY) Compare Products
Rowe Slim Cool Grey Floor 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
Clipper Light Wood / Chrome Tripod Floor Lamp Base Only Compare Products
Clipper Black Wood / Chrome Tripod Floor Lamp Base Only Compare Products
Clipper White Wood / Chrome Tripod Floor Lamp Base Only

Out of stock

Compare Products
Sleek 3 Way Round Plate Spotlight Grey NO BULBS Compare Products

Rosie Single Spotlight Chrome

Product Code: 23516
Rosie Single Spotlight Chrome Compare Products
Rosie Single Spotlight Black Chrome / Chrome Compare Products
Rosie Single Spotlight White / Chrome Compare Products
Rosie 4 Way Straight Bar Spotlight Copper Compare Products
Rosie 4 Way Straight Bar Spotlight Grey / Chrome Compare Products
Eleanor Chrome Floor Lamp with Clear Acrylic Balls (NO SHADE Compare Products
Camden Tripod Table Lamp Copper Painted (BASE ONLY) Compare Products
Levon Mirrored Tile Pear Table Lamp (NO SHADE) Compare Products
Charlie Grey Painted Modern Stem Floor Lamp (NO SHADE) Compare Products
Crawford Tripod Floor Lamp Cool Grey Painted (BASE ONLY) Compare Products
Camden Tripod Table Lamp Gloss Black (BASE ONLY) Compare Products
Camden Tripod Floor Lamp Grey (BASE ONLY) Compare Products
Caribou Antler Table Lamp Natural Finish (BASE ONLY) Compare Products
Rousse Large Curved Black Floor Lamp (NO SHADE) Compare Products
Memphis Twist Traditional Antique Brass Floor Lamp (NO SHADE Compare Products
Gosforth Twist Copper Table Lamp (NO SHADE)

Out of stock

Compare Products
Clipper Grey / Chrome Tripod Floor Lamp Base Only Compare Products
Davenport Extra Large K9 Crystal Table Lamp (NO SHADE) Compare Products
Barbro Light Wood Tripod Floor Lamp (NO SHADE) Compare Products
Vida Modern Single Stem Black Floor Lamp (NO SHADE) Compare Products
Cygnus Grey Geometric Table Lamp (NO SHADE) Compare Products
Rorik Skandi Tripod Table Lamp Black (NO SHADE) Compare Products
Rorik Skandi Tripod Table Lamp Silver (NO SHADE) Compare Products
Rorik Skandi Tripod Floor Lamp Black (NO SHADE) Compare Products
Rorik Skandi Tripod Floor Lamp Silver (NO SHADE) Compare Products
Orick Chrome Floor Lamp / Flexi Arm Reading Light (NO SHADE) Compare Products
Balmoral Dual Octagon Crystal Table Lamp (NO SHADE) Compare Products
Roe Deer Table Lamp Matt Black (BASE ONLY) Compare Products

193 - 240 of 275

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