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 = '678' 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 1533

Page:
  1. 1
  2. 2
  3. 3
  4. 4
  5. 5
per page
ICONIC Dorian Copper Retro Dome Shade Ceiling Light Compare Products
ICONIC Austen Domed Electric Pendant Chrome Compare Products
ICONIC Austen Domed Electric Pendant Copper Compare Products
ICONIC Cubik Cubism Matt Black Electric Pendant Compare Products
ICONIC Cubik Cubism Gold Electric Pendant Compare Products
ICONIC Donovan Large Industrial Loft Pendant Matt Black Compare Products
ICONIC Palladium Gold K9 Flush Ceiling Light Compare Products
ICONIC Eleanor XL Ribbed Silver Table Lamp with Shade Compare Products
ICONIC Dorian Copper Retro Dome Shade Table Lamp Compare Products
ICONIC Dorian Matt Black Retro Dome Shade Floor Lamp Compare Products
ICONIC Dorian Copper Retro Dome Shade Floor Lamp Compare Products
ICONIC Hensley Black / Brass Table Lamp Compare Products
ICONIC Hensley Black / Brass Floor Lamp

Out of stock

Compare Products
ICONIC Hypatia Matt Black Ceiling Light Glass Shade 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 Ice Cube Chrome Waterfall Droplet Flush Ceiling Light Compare Products
ICONIC Dynasty 5 Way LED Chrome Glass Droplet Ceiling Light Compare Products
ICONIC Lucia Satin Nickel / Black Pendant Ceiling Light Compare Products
ICONIC Fiske 3 Way Over Table Light Copper / Matt Black Compare Products
ICONIC Mersea K5 Crystal LED 30W Electric Pendant Compare Products
ICONIC Velar K5 Crystal LED 24W Flush Ceiling Light 4000K Compare Products
ICONIC Sapporo Double Loop 46W LED Crystal Ceiling Light Compare Products
ICONIC Inga 24W LED Crystal Ring Ceiling Light 4000K Compare Products
ICONIC Yeoman Chrome Dome Shade Ceiling Light Compare Products
ICONIC Satellite Copper Table Lamp

Out of stock

Compare Products

IP44 Flush Ceiling Light Chrome

Product Code: 16410
IP44 Flush Ceiling Light Chrome Compare Products
Reyka 3 Way Cross Over Chrome Ceiling Light Swirl Glass Compare Products
Hannah Wood And Light Pink LED Task Lamp Compare Products
Dolus 18W LED Black Pendant Ceiling Light Compare Products
Marley Matt Black Curved Floor Lamp Red Flex Compare Products
Sheridan Steampunk Electric Pendant Amber Glass Shade

Out of stock

Compare Products
ICONIC Satellite Chrome 5 Way 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
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
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

1 - 48 of 1533

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