New In

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 = '859' 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 275

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
ICONIC Forton Adjustable Floor Lamp Copper Compare Products
ICONIC Washington Flush 3 Tier K9 Ceiling Light Compare Products
ICONIC Palladium Gold K9 Flush Ceiling Light 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
ICONIC Forton Adjustable Desk Lamp Copper Compare Products
Dolus 18W LED Black Pendant Ceiling Light 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
ICONIC Eleanor XL Ribbed Silver Table Lamp with Shade Compare Products
ICONIC Dorian Matt Black Retro Dome Shade Table Lamp 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
3 Tier Iridescent Pendant Shade 250mm x 350mm Compare Products
Unicorn Ceramic Table Lamp with Dusky Pink Tapered Shade 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
Sheridan Steampunk Electric Pendant Amber Glass Shade

Out of stock

Compare Products
Sheridan Steampunk Wall Light Clear Glass Shade Compare Products
Mesean Giant Grey Voile NE Pendant Shade Clear Droplets Compare Products
ICONIC Hensley Black / Brass Table Lamp 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 KD NE Zig-Zag Small Drum Shade 200mm X 250mm 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
Francis Satin Nickel Touch Table Lamp With Dusky Pink Shade Compare Products
Weaver Pink & Grey Herringbone NE Pendant Shade Compare Products

1 - 48 of 275

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