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 = '561' 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 467

Page:
  1. 1
  2. 2
  3. 3
  4. 4
  5. 5
per page
Rolla KD NE XL Pendant Drum Shade Navy Blue / Gold 250mm X 4 Compare Products
Cream Rolla KD NE XL Pendant Drum Shade 250mm x 450mm Compare Products
Black Rolla KD NE XL Pendant Drum Shade 250mm x 450mm Compare Products
Mink Rolla KD NE XL Pendant Drum Shade Compare Products
Rolla KD NE XL Pendant Drum Shade Grey 250mm X 450mm Compare Products
3 Tier Iridescent Pendant Shade 250mm x 350mm Compare Products
Set Of 3 Torbery Nesting NE Pendants With Diffusers Grey Compare Products
Rolla KD NE Large Pendant Drum Shade Copper 250mm x 350mm Compare Products
Rolla KD NE XL Pendant Drum Shade Copper 250mm X 450mm Compare Products
Mesean Giant Grey Voile NE Pendant Shade Clear Droplets Compare Products
Fordyce Non Electric Satin Black Basket Pendant Shade Compare Products
Bensson Twisted Non Electric Matt Cool Grey Pendant Shade Compare Products
Rolla KD NE XL Pendant Drum Shade Iridescent 250mm x 450mm Compare Products
Rolla Grey KD NE Smooth Velvet Small Drum Shade 200mm X 250m

Out of stock

Compare Products
Rolla Grey KD NE Smooth Velvet Large Drum Shade 250mm X 350m

Out of stock

Compare Products
Rolla KD NE Zig-Zag Small Drum Shade 200mm X 250mm Compare Products
Rolla KD NE Yellow Geo Small Drum Shade 200mm X 250mm

Out of stock

Compare Products
Rolla KD NE Zig-Zag Large Drum Shade 250mm X 350mm Compare Products
Rolla KD NE Small Pendant Drum Shade Dusky Pink 200mmX250mm Compare Products
Aspen Small Tapered Shade 190mm x 250mm White Compare Products
Aspen Small Tapered Shade 190mm x 250mm Black Compare Products
Aspen Small Tapered Shade 190mm x 250mm Navy Blue Compare Products
Aspen Small Tapered Shade 190mm x 250mm Mustard Compare Products
Aspen Small Tapered Shade 190mm x 250mm Dusky Pink Compare Products
Aspen Small Tapered Shade 190mm x 250mm Grey Compare Products
Aspen Small Tapered Shade 190mm x 250mm Beige Compare Products
Toke Matt / Copper Black Geometric Shade Compare Products
Rolla KD NE Large Pendant Drum Shade Dusky Pink 250mm X 350m Compare Products
Aspen Large Tapered Shade 270mm x 350mm White Compare Products
Aspen Large Tapered Shade 270mm x 350mm Black Compare Products
Aspen Large Tapered Shade 270mm x 350mm Navy Blue Compare Products
Aspen Large Tapered Shade 270mm x 350mm Dusky Pink Compare Products
Aspen Large Tapered Shade 270mm x 350mm Grey Compare Products
Aspen Large Tapered Shade 270mm x 350mm Beige Compare Products
Nevada 4 Tiered NE Pleated Pendant Grey Compare Products
Weaver Pink & Grey Herringbone NE Pendant Shade Compare Products
Rolla KD NE SML Pendant Drum Shade Iridescent 200mm x 250mm Compare Products
Rolla KD NE LGE Pendant Drum Shade Iridescent 250mm x 350mm Compare Products
Twist Non Elec PP Pendant Shade Copper Compare Products
Rolla KD NE Small Pendant Drum Shade Black / Copper 200mm x Compare Products
Rolla KD NE Large Pendant Drum Shade Grey / Copper 250mm X 3 Compare Products
Rolla KD NE Large Pendant Drum Shade Grey/Chrome 250mmX350mm Compare Products
Rolla KD NE Large Pendant Drum Shade Unicorn 250mm X 350mm Compare Products
Rolla KD NE Large Pendant Drum Shade Tropical 250mm X 350mm Compare Products
Blue Sky / Clouds Rolla NE Pendant Shade with Acrylic Drops Compare Products
Grey Sky / Clouds Rolla NE Pendant Shade with Acrylic Drops Compare Products
Pink Sky / Clouds Rolla NE Pendant Shade with Acrylic Drops Compare Products
Strad Non Electric Tall Drum Pendant Shade Compare Products

1 - 48 of 467

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