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 = '560' 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

33 Item(s)

per page
Designer Suspended Lampholder Pendant Light Satin Nickel Compare Products
Casco 5 Way Ceiling Pendant Light Chrome (NO SHADE) Compare Products
Casco 5 Way Ceiling Pendant Light Matt Black (NO SHAD Compare Products

Regina Gold Electric Mesh Pendant

Product Code: 22813
Regina Gold Electric Mesh Pendant Compare Products
Calumet Tapered Cement Electric Pendant Shade Compare Products
Wilhelm Antique Brass Electric Pendant Red Metal Shade Zebra Compare Products
Albany Angular Cement Electric Pendant Shade Compare Products
Soltar UFO Silver 20W LED Ceiling Pendant 2700K Compare Products
Umbrella Steampunk Black Rise And Fall Over Table Light Compare Products
Soltar UFO Black 20W LED Ceiling Pendant 2700K Compare Products
Colonial Steampunk Antique Brass Black Ceiling Pendant Compare Products
Designer Suspended Lampholder Pendant Light Black Compare Products
Designer Suspended Lampholder Pendant Light Copper Compare Products
Designer Suspended Lampholder Pendant Light Chrome Compare Products
Designer Suspended Lampholder Pendant Light Antique Brass Compare Products
Designer Suspended Lampholder Pendant Light White 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
Designer Suspended Lampholder Pendant Light Black with Shade Ring Compare Products
Designer Suspended Lampholder Pendant Light White with Shade Compare Products
Designer Lampholder Pendant Chrome Black Flex with Shade Ring Compare Products
Designer Lampholder Pendant Chrome Red Flex with Shade Ring Compare Products
Eyre Chrome 3 Way Electric Pendant (NO SHADES) Compare Products
Designer Suspended Lampholder Pendant Light Copper with Shade Ring Compare Products
Designer Suspended Lampholder Pendant Light Satin Brass with Shade Ring Compare Products
4m Hydro Flex Kit Plug & ES Lampholder WHITE Compare Products
Casco Lampholder Pendant Light 2m Cable Antique Brass (NO SHADE) Compare Products
Casco Lampholder Pendant Light 2m Cable Chrome (NO SHADE) Compare Products
Casco Lampholder Pendant Light 2m Cable Matt Black (NO SHADE Compare Products
Diablo Black IP44 Electric Pendant Compare Products
Horatio 3 Way Steampunk Matt Black Pendant

Out of stock

Compare Products
Casco Lampholder Pendant Light 2m Cable Copper (NO SHADE)

Out of stock

Compare Products

33 Item(s)

per page