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 = '725' 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 187

Page:
  1. 1
  2. 2
  3. 3
  4. 4
per page
Angus 3 Way Satin Black Basket Ceiling Electric Pendant Compare Products
Casco Curved Table Lamp Chrome (NO SHADE) Compare Products
Alysha Satin Nickel Modern Skandi Desk Lamp Compare Products
Angus 3 Way Brushed Copper Basket Ceiling Electric Pendant Compare Products
Smedley Steampunk 3-Way Fitting In Black & Gold Compare Products
Edmund 3 Way Spotlight Chrome Matt Black Compare Products
Edmund 4 Way Spotlight Chrome Matt Black Compare Products
Quay Matt Black Nautical Electric Ceiling Pendant Compare Products
Schofield Cement Cube Table Lamp Base

Out of stock

Compare Products
ICONIC Donovan Large Industrial Loft Pendant Matt Black Compare Products
Tabbart Wooden Steam Punk Angled Wall Light (NO SHADE) Compare Products
Umbrella Steampunk Black Rise And Fall Over Table Light Compare Products
Calumet Tapered Cement Electric Pendant Shade Compare Products
Albany Angular Cement Electric Pendant Shade Compare Products
Colonial Steampunk Antique Brass Black Ceiling Pendant Compare Products
Anderton Black Steampunk Pulley Wall Light (NO SHADE) Compare Products

Ukai Chrome Fishermans Wall Light

Product Code: 18859
Ukai Chrome Fishermans Wall Light Compare Products

Ukai Black Fishermans Wall Light

Product Code: 18858
Ukai Black Fishermans Wall Light Compare Products
Ukai Antique Brass Fishermans Wall Light Compare Products
Designer Suspended Lampholder Pendant Light Antique Brass Compare Products
Salisbury Traditional Knuckle Joint Wall Light Antique Brass Compare Products
Antique Edison Bulb Table Lamp E27 60W ES GLS Compare Products
Ukai Antique Brass Fishermans Non Electric Pendant Compare Products
Angus Non Electric Brushed Copper Basket Pendant Shade Compare Products
Angus Non Electric Polished Chrome Basket Pendant Shade Compare Products
Ukai Duck Egg Blue Fishermans Touch Table Lamp Compare Products
Ukai Polished Copper Fishermans Non Electric Pendant Compare Products
Ukai Antique Brass Fishermans Touch Table Lamp Compare Products
Designer Suspended Lampholder Pendant Light Copper Compare Products

Chain Suspension Kit Satin Nickel

Product Code: 16520
Chain Suspension Kit Satin Nickel Compare Products

Chain Suspension Kit Black Chrome

Product Code: 18248
Chain Suspension Kit Black Chrome Compare Products
Chain Suspension Kit Matt White (Painted) Compare Products
Diablo Black Wire Frame Non Electric Pendant Shade Compare Products
Diablo White Wire Frame Non Electric Pendant Shade Compare Products
Diablo Red Wire Frame Non Electric Pendant Shade Compare Products
Diablo Copper Wire Frame Non Electric Pendant Shade Compare Products
Penglai Wire Basket Fishermans Ceiling Pendant Shade-Black Compare Products
Penglai Wire Basket Fishermans Ceiling Pendant Shade-Cream Compare Products
Penglai Wire Basket Fishermans Ceiling Pendant Shade-Duck Egg Blue Compare Products
Otto Cartwheel 5 Way Over Table Light Black Compare Products
Antique Edison Bulb Table Lamp Aged Brass E27 60W ES GLS Compare Products
Ukai Polished Copper Fishermans Wall Light Compare Products
Lloyd Chrome Wall Light with Conical Glass Coolie Shade Compare Products
Wilhelm Antique Brass Style Wall Light Olive / Sage Green Metal Shade Compare Products
Wilhelm Antique Brass Style Wall Light Duck Egg Blue Metal Shade Compare Products

Angus Copper Single Spot Light

Product Code: 20848
Angus Copper Single Spot Light

Out of stock

Compare Products
Designer Suspended Lampholder Pendant Light Copper with Shade Ring Compare Products
Penglai Wire Basket Fishermans N/E Pendant Copper / White Inner Compare Products

1 - 48 of 187

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