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 = '742' AND cat_index.is_parent=1 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 435

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

Lille 5 Way Ceiling Light Silver

Product Code: 80726
Discontinued
Lille 5 Way Ceiling Light Silver

Out of stock

Compare Products

Lille 3 Way Ceiling Light Silver

Product Code: 80729
Discontinued
Lille 3 Way Ceiling Light Silver

Out of stock

Compare Products

Helensburgh Tiffany Uplighter Floor Lamp

Product Code: 15674
Discontinued
Helensburgh Tiffany Uplighter Floor Lamp

Out of stock

Compare Products

Titania Tiffany Uplighter Floor Lamp

Product Code: 15675
Discontinued
Titania Tiffany Uplighter Floor Lamp

Out of stock

Compare Products

Myra N E Pendant

Product Code: 13934
Discontinued
Myra N E Pendant

Out of stock

Compare Products

Ducy KD NE Pendant

Product Code: 14075
Discontinued
Ducy KD NE Pendant

Out of stock

Compare Products

Vermont 3 Tiered NE Pendant Champagne Gold

Product Code: 15591
Discontinued
Vermont 3 Tiered NE Pendant Champagne Gold

Out of stock

Compare Products

Vermont 3 Tiered NE Pendant Red

Product Code: 15594
Discontinued
Vermont 3 Tiered NE Pendant Red

Out of stock

Compare Products

Justus NE Pendant Black

Product Code: 15667
Discontinued
Justus NE Pendant Black

Out of stock

Compare Products

Justus NE Pendant Pink

Product Code: 15669
Discontinued
Justus NE Pendant Pink

Out of stock

Compare Products
Satin Nickel Touch Table Lamp Skyline Cut-out Chrome Shade

Out of stock

Compare Products

Satin Nickel Touch Table Lamp with Black Shade

Product Code: 15457
Discontinued
Satin Nickel Touch Table Lamp with Black Shade

Out of stock

Compare Products
Satin Nickel Touch Table Lamp New York Skyline Cut-out Chrome Shade

Out of stock

Compare Products

Large White Frosted Globe Glass Table Lamp 20cm

Product Code: 15490
Discontinued
Large White Frosted Globe Glass Table Lamp 20cm

Out of stock

Compare Products

Marie Therese 5 way Chandelier Ceiling Light Chrome

Product Code: 15840
Discontinued
Marie Therese 5 way Chandelier Ceiling Light Chrome

Out of stock

Compare Products

B22 to E27 Lamp Socket Converter

Product Code: 15861
Discontinued
B22 to E27 Lamp Socket Converter

Out of stock

Compare Products

Flexi Neck Floor Lamp Red

Product Code: 15891
Discontinued
Flexi Neck Floor Lamp Red

Out of stock

Compare Products

Flexi Neck Floor Lamp White

Product Code: 15892
Discontinued
Flexi Neck Floor Lamp White

Out of stock

Compare Products
Stick Base Touch Table Lamp with Skyline Cut-out Shade Satin Nickel

Out of stock

Compare Products
Gloss Black Touch Table Lamp Skyline Cut-out Shade Gloss Black

Out of stock

Compare Products
Gloss Black Touch Table Lamp New York Skyline Cut-out Shade

Out of stock

Compare Products

Mini Scroll Sculpture Table Lamp Bronze

Product Code: 15958
Discontinued
Mini Scroll Sculpture Table Lamp Bronze

Out of stock

Compare Products

Vintage Union Jack Flag NE Pendant Shade

Product Code: 16160
Discontinued
Vintage Union Jack Flag NE Pendant Shade

Out of stock

Compare Products

Small Rose White LED Branch Lights

Product Code: 16216
Discontinued
Small Rose White LED Branch Lights

Out of stock

Compare Products

1.2m White Branch Lights with Red Flowers

Product Code: 16220
Discontinued
1.2m White Branch Lights with Red Flowers

Out of stock

Compare Products

1.2m Twig Lights Gold

Product Code: 16230
Discontinued
1.2m Twig Lights Gold

Out of stock

Compare Products

45cm LED Sakura Tree Light Cool White LED's

Product Code: 16700
Discontinued
45cm LED Sakura Tree Light Cool White LED's

Out of stock

Compare Products

45cm LED Sakura Tree Light Red LED's

Product Code: 16701
Discontinued
45cm LED Sakura Tree Light Red LED's

Out of stock

Compare Products

45cm LED Sakura Tree Light Blue LED's

Product Code: 16702
Discontinued
45cm LED Sakura Tree Light Blue LED's

Out of stock

Compare Products

MiniSun 70w BC GLS Halogen Energy Reducing Bulb

Product Code: 16144
Discontinued
MiniSun 70w BC GLS Halogen Energy Reducing Bulb

Out of stock

Compare Products
MiniSun 42w SES Bent Tip Candle Energy Saving Halogen Bulbs

Out of stock

Compare Products

Swan Neck Touch Table Lamp Chrome

Product Code: 16562
Discontinued
Swan Neck Touch Table Lamp Chrome

Out of stock

Compare Products

Wire Beaded KD NE Pendant Shade Black

Product Code: 16165
Discontinued
Wire Beaded KD NE Pendant Shade Black

Out of stock

Compare Products

MiniSun 28w G9 Halogen Energy Reducing Bulb

Product Code: 16152
Discontinued
MiniSun 28w G9 Halogen Energy Reducing Bulb

Out of stock

Compare Products

MiniSun 35w GU10 Halogen Energy Reducing Bulb

Product Code: 16154
Discontinued
MiniSun 35w GU10 Halogen Energy Reducing Bulb

Out of stock

Compare Products

MiniSun 400w R7S 118mm Halogen Energy Reducing Bulb

Product Code: 16155
Discontinued
MiniSun 400w R7S 118mm Halogen Energy Reducing Bulb

Out of stock

Compare Products

MiniSun 35w Mini GU10 Halogen Bulb

Product Code: 16153
Discontinued
MiniSun 35w Mini GU10 Halogen Bulb

Out of stock

Compare Products

MiniSun 80w PAR38 Eco Halogen Spotlight Bulb

Product Code: 16158
Discontinued
MiniSun 80w PAR38 Eco Halogen Spotlight Bulb

Out of stock

Compare Products
Ice Cube Single Bathroom Spotlight IP44 White / Chrome

Out of stock

Compare Products
Minisun Flexi Neck LED Desk Lamp 8w 6500k Daylight Bulb

Out of stock

Compare Products

Mini Scroll Sculpture Table Lamp Red

Product Code: 15960
Discontinued
Mini Scroll Sculpture Table Lamp Red

Out of stock

Compare Products
Trad 3 Way Round Plate Spotlight Distressed White NO BULBS

Out of stock

Compare Products
Gloss Black Midi Floor Lamp with Skyline Cut-out Shade

Out of stock

Compare Products

Claudia 2 Way Touch Table Lamp Chrome

Product Code: 16910
Discontinued
Claudia 2 Way Touch Table Lamp Chrome

Out of stock

Compare Products
Pair of Satin Nickel Touch Table Lamps with Red Shades

Out of stock

Compare Products
Pair of Satin Nickel Touch Table Lamps with Blue Shades

Out of stock

Compare Products

Claudia 2 Way Touch Table Lamp Black Chrome

Product Code: 16911
Discontinued
Claudia 2 Way Touch Table Lamp Black Chrome

Out of stock

Compare Products
MiniSun BC 4w 36 SMD LED Candle Bulb 2700k 330 Lumens

Out of stock

Compare Products

1 - 48 of 435

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