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 = '557' 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 754

Page:
  1. 1
  2. 2
  3. 3
  4. 4
  5. 5
per page
Reyka 3 Way Cross Over Chrome Ceiling Light Swirl Glass Compare Products
Dolus 18W LED Black Pendant Ceiling Light Compare Products
Sheridan Steampunk Electric Pendant Amber Glass Shade

Out of stock

Compare Products
ICONIC Sputnik Chrome 8 Way Ceiling Light Glass Shades

Out of stock

Compare Products
ICONIC Cabaret 9 Way Matt Black 2 Tier Ceiling Light Compare Products
ICONIC Dynasty 5 Way LED Chrome Glass Droplet Ceiling Light Compare Products
Rivette K5 Crystal Droplet IP44 Flush Ceiling Fitting Chrome Compare Products
Amadeus Wire Non Electric Pendant Shade Gold Compare Products
ORB! 5 Way Chrome Ceiling Spiral Pendant Compare Products
ORB! 5 Way Matt Black Ceiling Spiral Pendant Compare Products
ORB! 5 Way Copper Ceiling Spiral Pendant Compare Products
ORB! 4 Way Chrome Ceiling Bar Pendant Compare Products
ORB! 4 Way Copper Ceiling Bar Pendant Compare Products
Samurai Non Electric Pendant Black Compare Products
ICONIC Lucia Satin Nickel / Black Pendant Ceiling Light Compare Products
Marie Therese Gold / Clear 3 Way Ceiling Light Compare Products
Marie Therese Chrome / Clear 3 Way Ceiling Light Compare Products
Marie Therese Gold / Clear 5 Way Ceiling Light Compare Products
Marie Therese Chrome / Clear 5 Way Ceiling Light Compare Products
ICONIC Fiske 3 Way Over Table Light Copper / Matt Black Compare Products
Rocha 5 Way Chrome Ceiling Light with Linen Grey Drum Shade

Out of stock

Compare Products
ORB! 4 Way Matt Black Ceiling Bar Pendant Compare Products
Hudson Chrome 3 Way Intertwined Rings Acrylic Ceiling Light

Out of stock

Compare Products
Fossett Dimpled Glass  Electric Pendant Shade Compare Products
ICONIC Mersea K5 Crystal LED 30W Electric Pendant Compare Products
Haylo White LED 56W Modern 2 Tier Electric Pendant 6000K Compare Products
Haylo Grey LED 56W Modern 2 Tier Electric Pendant 6000K Compare Products
Varuna IP44 Chrome Bathroom Chandelier Glass Droplets Compare Products

Castoro 3 Way Pendant Drop Copper

Product Code: 22917
Castoro 3 Way Pendant Drop Copper Compare Products
ICONIC Inga 24W LED Crystal Ring Ceiling Light 4000K Compare Products
ICONIC Yeoman Chrome Dome Shade Ceiling Light Compare Products
Argent 5 Way Grey Ceiling Light With Shades Compare Products
ICONIC Hypatia Matt Black Ceiling Light Glass Shade Compare Products
Omar Matt Black Wire Star Electric Ceiling Pendant Compare Products
Omar Copper Wire Star Electric Ceiling Pendant Compare Products
ICONIC Wemyss Industrial Black Pendant Compare Products
ICONIC Malvern Industrial Chrome Pendant Compare Products
Hudson Intertwined 3 Way Ceiling Pendant Light Chrome Clear Compare Products
ICONIC Satellite Chrome 5 Way Ceiling Light Compare Products
ICONIC Satellite Copper 5 Way Ceiling Light Compare Products
ICONIC Belgravia 5 Way Chrome / Crystal Ceiling Pendant Compare Products
ICONIC Vincent Glitz Drum Ceiling Pendant Chrome / Clear Compare Products
ICONIC Fiske 3 Way Over Table Light Chrome / Matt Grey Compare Products
Reyka 5 Way Cross Over Chrome Ceiling Light Swirl Glass Compare Products
Usama Black 3 Way Cross Over Ceiling Light with Fabric Shade Compare Products
Cruzar Satin Nickel Large Cross Smoked Glass Ceiling Light Compare Products
Prague 5 Way Lead Crystal Flush Ceiling Light Copper Compare Products
Brigantine Twin Arm Wall Light Vintage White With Acrylic Compare Products

1 - 48 of 754

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