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 = '536' 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 128

Page:
  1. 1
  2. 2
  3. 3
per page
Rosie 4 Way Straight Bar Spot Light Chrome Chrome Compare Products
ChiChi Black and Copper Coil Shade 3 Way Spotlight Compare Products
Alpha Single Spotlight 4.5W Funnel Shade 3000K Compare Products
Alpha 3 Way Spotlight 4.5W Funnel Shade 3000K Compare Products
Consul Grey 6 Way Rectangular Plate Spotlight Compare Products
Sangar Satin Nickel Ceiling Light with Smoked Indent Glasses Compare Products
Trad 3 Way Round Plate Spotlight Copper NO BULBS Compare Products
Dundee 3 Way Spotlight Black / Copper Compare Products
Dundee 3 Way Spotlight Grey / Chrome Compare Products
Sleek 3 Way Round Plate Spotlight Grey NO BULBS Compare Products

Rosie Single Spotlight Chrome

Product Code: 23516
Rosie Single Spotlight Chrome Compare Products
Rosie Single Spotlight Black Chrome / Chrome Compare Products
Rosie Single Spotlight White / Chrome Compare Products
Rosie 4 Way Straight Bar Spotlight Copper Compare Products
Rosie 4 Way Straight Bar Spotlight Grey / Chrome Compare Products

Angus 4 Way Bar Spot Light Grey

Product Code: 23697
Angus 4 Way Bar Spot Light Grey Compare Products
Usama Black 4 Way Ceiling Light with Fabric Shades Compare Products
Usama Black 3 Way Cross Over Ceiling Light with Fabric Shade Compare Products
Garcia Single Matt Black / Copper Ceiling Spotlight Compare Products
Consul 8 Way Flexi Z Spotlight Chrome Compare Products
Smedley Steampunk 3-Way Fitting In Black & Gold Compare Products
Sonnet 3 Way Round Spotlight Satin Nickel / Chrome Compare Products
Milford 3 Way Round Plate Spotlight White / Chrome Compare Products
Naysmyth 3 Way Grey / Chrome Ceiling Spotlight Compare Products
Rosie 4 Way Straight Bar Spot Light White Chrome Compare Products
Benton IP44 6 Way Rectangular Plate Spotlight

Out of stock

Compare Products
Edmund 3 Way Spotlight Chrome Matt Black Compare Products
Rosie 3 Way Straight Bar Spot Light Chrome / Grey Compare Products
Sonnet 3 Way Round Spotlight Steampunk Black / Antique Brass Compare Products
Milford 3 Way Round Plate Spotlight Grey / Chrome Compare Products
Consul 6 Way Flexi Z Spotlight Chrome

Out of stock

Compare Products
Rosie 3 Way Straight Bar Spot Light Cement / Chrome Compare Products
Brunel 3 Way Spotlight With Domed Heads Antique Brass Compare Products
Edmund 4 Way Spotlight Chrome Matt Black Compare Products
Kerin 3 Way Matt Black / Satin Nickel Spot Light Compare Products
Jamais Pin Up Spotlight Chrome Opal Glass Cone Shade Compare Products
Rosie 8 Way Flexi Z Spot Light Black Copper Compare Products
Salsa Bullet Head 4-Way Spotlight in Brushed Chrome

Out of stock

Compare Products
Cement / Chrome 6 Way Square Plate Spotlight Compare Products
Benton Chrome Twin Spotlight With Cable Plug & Switch Compare Products
Tassa 3 Way Spotlight 4.5W Slice Cylinder Shades 3000K Compare Products
Galena 3 Way 4.5W 3000K LED Spotlight Chrome / Opal Compare Products
Conrad White Single Spot Light With Copper Knuckle Joint Compare Products
Conrad Black 3 Way Spot Light With Copper Knuckle Joint Compare Products
Mini Retro Eyeball Single Spotlight Compare Products
Mini Retro Eyeball 3 Way Straight Bar Spotlight Black Chrome

Out of stock

Compare Products
Retro Eyeballs 3 Way Round Plate Spotlight Chrome Compare Products
Black Chrome 3 Way Arco Eyeball Pendant Ceiling Light Compare Products

1 - 48 of 128

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