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 = '738' 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 92

Page:
  1. 1
  2. 2
per page
Timantti 3 Way Chrome Ceiling Light With Shades Compare Products
Marley Matt Black Curved Floor Lamp Red Flex Compare Products
Casco Lampholder Pendant Light 2m Cable Chrome (NO SHADE) Compare Products
Hannah Wood And Light Pink LED Task Lamp Compare Products
Wallace Steampunk Wall Light Amber Glass Shade Compare Products
Corin Glass Tumbler / Cement Table Lamp Compare Products
20 x Celebration SELV Clear Festoon Lights Compare Products
Sophia Large Grey White Non Electric Pendant Shade Compare Products
Ryston IP54 Outdoor Black Up Down Wall Light Compare Products
Consul 8 Way Flexi Z Spotlight Chrome Compare Products
Curva Trend Floor Lamp Black (NO SHADE) Compare Products
Staircase 5 Way Acrylic Electric Pendant Light Compare Products
Kathrine 3 Way Polished Chrome IP44 Ceiling Light Compare Products
Colonial Steampunk Antique Brass Black Ceiling Pendant Compare Products
Haakon Dual Taper NE Pendant Shade Grey Compare Products

Ceramic Base Floor Lamp Grey

Product Code: 23559
Ceramic Base Floor Lamp Grey Compare Products
Hesketh Large Square Flush Ceiling Light Compare Products
Jefferson 4 Way IP44 Bathroom Cube Ceiling Light Chrome Compare Products
3 Tier Acrylic Droplet Pendant in Gold and Champagne Compare Products
E27/ES 4W LED Helix Filament Pear Shaped Bulb AMBER 2200K 160lm Compare Products
Angus Geometric Grey Base Table Lamp Grey Shade Compare Products
Sophia Large Cream White Non Electric Pendant Shade Compare Products
Wilhelm Antique Brass Wall Light with Grey Shade Compare Products
Portishead GU10 Fire-Rated Downlight in Chrome Compare Products
MiniSun Cobra2 Round 18W LED Downlight 3000K 1300 Lumens Compare Products
Mojo Touch Table Lamp Satin Grey / Grey Compare Products
Rafel 3 Way Polished Chrome IP44 Ceiling Light Compare Products
Children's Unicorn NE PP Pendant Shade White Compare Products
Norton Steampunk Wall Light Clear Glass Shade Compare Products
Belgrave Acrylic Flush Basket Chrome Ceiling Light IP44 Rated Compare Products
Gorren Ceramic Paint Me Wall Light Compare Products
Rosie 8-Way Flexi Spotlight Bar In Black Chrome & Chrome Compare Products
Bensson Twisted Gold Pendant Shade Compare Products
MiniSun Cobra2 Round 5W LED Downlight 3000K 320 Lumens Compare Products
MiniSun Cobra2 Round 8W LED Downlight 3000K 500 Lumens Compare Products
MiniSun Cobra2 Round 18W LED Downlight 6500K 1300 Lumens Compare Products
Portishead GU10 Fire Rated Downlight in Chrome and Gold Compare Products
Cubbie Grey Touch Table Lamp Cube Base Grey Shade Compare Products
Sophia Large Black White Non Electric Pendant Shade Compare Products
Quinta Splash Waterfall Chrome / Acrylic Non Elec Pendant Compare Products
3m Extension Cable for Minisun 15mm Deck Lights Compare Products

Rosie Single Spotlight Grey

Product Code: 23499
Rosie Single Spotlight Grey Compare Products

Argent Grey Wall Light With Shade

Product Code: 23301
Argent Grey Wall Light With Shade Compare Products
Marley Matt Black Curved Desk Lamp Red Flex Compare Products
Zig-Zag Grey Ceramic Table Lamp With Grey Shade Compare Products
Cruz Glass Globe An A Wood Stand Table Lamp Compare Products
Rosie 8 Way Flexi Z Spot Light Black Copper Compare Products
Tapered Dome Clear Pendant Glass Shade Compare Products

1 - 48 of 92

Page:
  1. 1
  2. 2
per page