Video Placeholder
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 = '724' 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 236

Page:
  1. 1
  2. 2
  3. 3
  4. 4
  5. 5
per page
IP44 Flush Ceiling Light Satin Nickel Compare Products
Capitol 3 Way Pendant Over Table Chrome Ceiling Light Compare Products
Cabosse Hammered Painted Copper Touch Table Lamp Black Shade Compare Products
Cabosse Hammered Painted Satin Nickel Touch Table Lamp White  Shade Compare Products
Burgess Matt Black Modern Table Lamp (NO SHADE) Compare Products
Acorn Non Electric Pendant White / Chrome Wire Cage Compare Products
Bantam K9 Faceted Crystal Table Lamp Cream Faux Silk Shade Compare Products
Bjorn Doughnut Non-Electric White Rattan Twine Pendant Compare Products

Gold Ice Cube Touch Table Lamp

Product Code: 22531
Gold Ice Cube Touch Table Lamp Compare Products
Feyenoord Cool Grey / Gold NE Pendant Shade Compare Products
Feyenoord White / Gold NE Pendant Shade Compare Products
Feyenoord Mint Green/ Gold NE Pendant Shade Compare Products
Penglai Wire Basket Fishermans NE Pendant Matt Grey Compare Products
Monza NE Large Felt Weave Drum Shade Grey 200mm X 350mm Compare Products
Flask Wire Basket Fishermans NE Pendant Oak /Grey / Chrome Compare Products
Angus Geometric Brushed Copper Base Table Lamp White Shade Compare Products
Talisman Black + Gold Table Lamp White Marble Base Compare Products
Ducy Gold K9 Crystal Cylinder Touch Table Lamp Compare Products
Austin Cement Tall Cylinder Table Lamp (BASE ONLY) Compare Products
Trumpet Touch Table Lamp Chrome / Grey Compare Products
Trumpet Touch Table Lamp Chrome / Mustard Compare Products
Crackle Glass Ball Touch Table Lamp Chrome Grey Shade

Out of stock

Compare Products
Stakke 3 Tier Non Elec White Inner  Table Lamp Compare Products
Cement / Chrome 6 Way Square Plate Spotlight Compare Products
Jesmond Gold Droplet NE Pendant Shade Compare Products

Jesmond Grey Pendant Shade

Product Code: 22405
Jesmond Grey Pendant Shade Compare Products
Lynton Black IP44 Outdoor Swan Neck Wall Lantern Compare Products
Barrow SS 50W GU10 Dusk Till Dawn Down Light IP44 Wall Light Compare Products
Dorset IP44 Outdoor Wall Lantern Black Stainless Steel Compare Products
Malmo White Electric Pendant Walnut / Copper Compare Products
Wilhelm Antique Brass Electric Pendant Red Metal Shade Zebra Compare Products
Wilhelm Antique Brass Electric Pendant Olive / Sage Green Me Compare Products
Clear Glass / Chrome Pineapple Touch Table Lamp Off White Shade Compare Products
Clear Glass / Gold Pineapple Touch Table Lamp Black Shade Compare Products
Marissa Chrome Touch Table Lamp Mustard Shade

Out of stock

Compare Products
Marissa Chrome Touch Table Lamp Grey Shade

Out of stock

Compare Products
Rowan Antique Brass Flush Ceiling Light Marble Glass Compare Products
Jewel Tiffany Non Electric Uplighter Amber Compare Products
Pair Of Teardrop Touch Table Lamp Chrome / Grey Shade Compare Products
Pair Of Teardrop Touch Table Lamp Chrome / Mustard Shade Compare Products
Rosie 3 Way Straight Bar Spot Light Chrome / Grey Compare Products
Rosie 3 Way Straight Bar Spot Light Chrome / Gold Compare Products
Sophia Small Grey White Non Electric Pendant Shade Compare Products
4 Way Suspended Lampholder Pendant Light Chrome WHITE CABLE

Out of stock

Compare Products
Stakke 3 Tier Non Elec Copper White Inner Compare Products
Stakke 3 Tier Copper Floor Lamp White Inner Compare Products
Cadena Satin Nickel Touch Table Lamp With Chain Effect Shade Compare Products

Owl Glass Jar NE Pendant Cream

Product Code: 21497
Owl Glass Jar NE Pendant Cream Compare Products

1 - 48 of 236

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