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 = '607' 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 512

Page:
  1. 1
  2. 2
  3. 3
  4. 4
  5. 5
per page
IP44 Flush Ceiling Light Satin Nickel Compare Products
4 Way Polished Chrome Spotlight Bar Compare Products
Black Chrome 3 Way Arco Eyeball Pendant Ceiling Light Compare Products
Retro Eyeballs 3 Way Round Plate Spotlight Chrome Compare Products
Eyeball 6 Way Ceiling Spotlight - Polished Chrome Compare Products
Chrome 4 way Square Plate Spotlight Compare Products
Benton 3 Way Round Plate Spotlight

Out of stock

Compare Products

Benton 6 Way Flexi Z Spotlight

Product Code: 15614
Benton 6 Way Flexi Z Spotlight Compare Products
Mini Retro Eyeball 3 Way Straight Bar Spotlight Black Chrome

Out of stock

Compare Products
Mini Retro 6 Way Flexi Z Spotlight Black Chrome Compare Products
Retro Eyeball 3 Light Droplet Chrome Compare Products
Mini Retro Eyeball Single Spotlight Compare Products
Chrome 4 Way KD Straight Bar Spotlight Compare Products
Benton Satin Nickel Single Spotlight Compare Products
Rosie 3 Way Straight Bar Spot Light Black Chrome / Chrome Compare Products
Planter White Glaze Wall Light - Paint Me Compare Products
Capri Satin Nickel Twin Picture Wall Light G9 Compare Products
Ice Cube 4 Way Bathroom Spotlight IP44 Compare Products
Ice Cube 3 Way Bathroom Spotlight IP44 Compare Products
40cm LED RGB Bubble Lamp Silver Base and Cap Compare Products
1.2m LED RGB Bubble Lamp with 8 Fish Compare Products

1.2m Twig Lights Black

Product Code: 16229
1.2m Twig Lights Black Compare Products
Ice Cube 3 Way Bathroom Spotlight IP44 White / Chrome Compare Products
Ice Cube 3 Way Bathroom Spotlight IP44 Black Chrome Compare Products
Rosie 3 Way Straight Bar Spot Light Red Compare Products

IP44 Flush Ceiling Light White

Product Code: 16411
IP44 Flush Ceiling Light White

Out of stock

Compare Products
Rosie 3 Way Straight Bar Spot Light White Compare Products
Cut-out Planter Ceramic Wall Wash Paint Me Compare Products
Capri Twin Picture Wall Light G9 Antique Brassed Compare Products
Ice Cube Single Bathroom Spotlight IP44 Chrome

Out of stock

Compare Products
Battery Operated 60cm Black Branches 15 LED bulbs 9 White Flowers

Out of stock

Compare Products
90cm LED RGB Bubble Lamp with 6 Fish Compare Products
Sunflower Battery Operated Decoration 20 LED Light Chain W W Compare Products
Mini Retro Eyeball Single Spotlight Gloss White Compare Products
Mini Retro 6 Way Flexi Z Spotlight Gloss White / Chrome Compare Products
Traditional Round Polished Chrome 3 Way Ceiling Spotlight Compare Products
Trad 3 Way Round Plate Spotlight Antique Brassed NO BULBS Compare Products
Sleek 3 Way Round Plate Spotlight Chrome NO BULBS Compare Products
Rosie 3 Way Straight Bar Spot Light Cream Compare Products
Benton 3 Way Round Plate Spotlight Chrome Compare Products
Benton 3 Way Round Plate Spotlight White/Chrome

Out of stock

Compare Products
Benton Single Spotlight Gloss Black Compare Products
Sleek 3 Way Round Plate Spotlight Black Chrome NO BULBS Compare Products

Claudia 2 Way Wall Light Chrome

Product Code: 16905
Claudia 2 Way Wall Light Chrome

Out of stock

Compare Products
Claudia 2 Way Wall Light Black Chrome Compare Products
Pair of Battery Operated Butterfly LED Chain Lights Pink Compare Products
IP65 GU10 Bathroom Downlight Chrome Compare Products

Ritz Single Spotlight

Product Code: 17110
Ritz Single Spotlight Compare Products

1 - 48 of 512

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