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 = '546' 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 122

Page:
  1. 1
  2. 2
  3. 3
per page
Harrier Modern Designer LED Touch Lamp Compare Products
Francis Satin Nickel Touch Table Lamp With Dusky Pink Shade Compare Products
Aldous Satin Nickel / White Mushroom Touch Lamp Compare Products
Aldous Copper / White Mushroom Touch Lamp Compare Products
Kajsa Satin Nickel Teardrop Touch Table Lamp (NO SHADE) Compare Products
Kajsa Satin Copper Teardrop Touch Table Lamp (NO SHADE) Compare Products
Georgina Large Pear Chrome Touch Table Lamp (NO SHADE) Compare Products
Twisty XL Stacked Mirrored Cube Touch Table Lamp (NO SHADE) Compare Products
Gatto Chrome Acrylic Spheres Touch Table Lamp (NO SHADE) Compare Products
Lytham Copper Touch Table Lamp (NO SHADE) Compare Products
Lytham Chrome Touch Table Lamp (NO SHADE) Compare Products
Mini G9 Touch Table Lamp Black Chrome Compare Products
Francis Satin Nickel Touch Table Lamp with White Shade Compare Products
Modern 'Cubbie' Copper Touch Table Lamp with Black Shade

Out of stock

Compare Products
Brushed Chrome Touch Table Lamp With Cut Out Fabric Shade-Black Compare Products
Brushed Chrome Touch Table Lamp With Cut Out Fabric Shade-Duck Egg Blue Compare Products
Brushed Chrome Touch Table Lamp With Cut Out Fabric Shade-Purple Compare Products
Cabosse Hammered Painted Copper Touch Table Lamp Black Shade Compare Products
Cabosse Hammered Painted Satin Nickel Touch Table Lamp White  Shade Compare Products

Gold Ice Cube Touch Table Lamp

Product Code: 22531
Gold Ice Cube Touch Table Lamp Compare Products
Ceramic Base Touch Table Lamp Black Compare Products
Providence Gold Touch Table Lamp Black Shade Compare Products
Austin Cement Tall Cylinder Table Lamp (BASE ONLY) Compare Products
Trumpet Touch Table Lamp Chrome / Grey Compare Products
Trumpet Touch Table Lamp Chrome / Mustard Compare Products
Crackle Glass Ball Touch Table Lamp Chrome Grey Shade

Out of stock

Compare Products
Clear Glass / Chrome Pineapple Touch Table Lamp Off White Shade Compare Products
Clear Glass / Gold Pineapple Touch Table Lamp Black Shade Compare Products
Marissa Chrome Touch Table Lamp Mustard Shade

Out of stock

Compare Products
Jaigier Brass Touch Table Lamp With Pleated Shade Compare Products
Pair Of Teardrop Touch Table Lamp Chrome / Grey Shade Compare Products
Pair Of Teardrop Touch Table Lamp Chrome / Mustard Shade Compare Products
Cubbie Grey Touch Table Lamp Cube Base Grey Shade Compare Products
Small Glass Touch Lamp White Rose Design Compare Products
Large Glass Touch Lamp Red Rose Design Compare Products
Small Glass Touch Lamp Red Rose Design Compare Products
Francis Satin Nickel Touch Table Lamp with Black Shade Compare Products
Francis Satin Nickel Touch Table Lamp with Red Shade Compare Products
Francis Satin Nickel Touch Table Lamp with Brown Shade Compare Products
Francis Satin Nickel Touch Table Lamp with Orange Shade Compare Products
Francis Satin Nickel Touch Table Lamp with Purple Shade Compare Products
Malin Touch Table Lamp Black Chrome / Black TC Shade Compare Products

Ice Cube Touch Table Lamp

Product Code: 14068
Ice Cube Touch Table Lamp Compare Products
Ice Cube Touch Table Lamp Black Chrome Compare Products

Copper Ice Cube Touch Table Lamp

Product Code: 20397
Copper Ice Cube Touch Table Lamp Compare Products
Pair of Teardrop Touch Table Lamp Chrome / Cream Shade Compare Products
Pair of Teardrop Touch Table Lamp Chrome / Black Shade Compare Products
Pair of Teardrop Touch Table Lamp Chrome / Red Shade Compare Products

1 - 48 of 122

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