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 = '787' 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 159

Page:
  1. 1
  2. 2
  3. 3
  4. 4
per page
Buddy The Bluetooth LED RGB Garden Speaker IP44 10W 120mm Compare Products
O'Connor Large Bronze Table Lamp with Black Shade Compare Products
MiniSun Mini High Power 3W G9 LED Bulb 3000K 300lm Compare Products
Fire Rated Hexagonal GU10 Downlight Chrome NO BULB Compare Products
Florida Colonial Matt Black Leaf 52 Ceiling Fan With Remote Compare Products
MinSun Set of 6 Pro3 Razor Skylite LED Panels 6500K Compare Products
Deena White / Mint Floating Shelf With E27 Lampholder Compare Products
Wilhelm Antique Brass Electric Pendant Olive / Sage Green Me Compare Products
MiniSun Pro3 Razor LED Panel - 300mm x 1200mm 4000K Compare Products
MiniSun Pro3 Razor LED Panel - 600mm x 600mm 4000K Compare Products
Lington Morph Clear Blown Glass NE Pendant Shade Compare Products
Shea Ribbed Cone Smoke Glass NE Pendant Shade Compare Products
Shea Ribbed Cone Amber Glass NE Pendant Shade Compare Products

Rosie Single Spotlight Grey

Product Code: 23499
Rosie Single Spotlight Grey Compare Products
MiniSun SES 20w Energy Saving Daylight Spiral Bulb Compare Products
Dimmable 3W SMD LED G9 Bulb Ceramic / Plastic 3000K 280lm Compare Products
Medusa NE Pendant Shade Copper Black / Frosted Compare Products
5w SMD LED GU10 Thermal Plastic Bodied Bulb 6500K Compare Products
Retro Eyeballs 3 Way Round Plate Spotlight Chrome Compare Products
MiniSun 30w ES Energy Saving Daylight Spiral Bulb 6500k Compare Products
Triado Black Ceramic Table Lamp with Black Shade Compare Products

MiniSun Pack of 10 10w 12v G4 Halogen Capsule Bulb

Product Code: 16469
Discontinued
MiniSun Pack of 10 10w 12v G4 Halogen Capsule Bulb Compare Products
MiniSun Pack of 10 20w 12v G4 Halogen Capsule Bulb Compare Products
Satin Nickel Midi Floor Lamp with Skyline Cut-out Shade Compare Products
Trumpet Touch Table Lamp Chrome / Red Compare Products
Trumpet Touch Table Lamp Black Chrome / Red Compare Products
IP44 Windsor Outdoor 1.3m Bollard Light Polypropylene Compare Products
6w BC LED Globe Bulb 6000K 580lm 20000 hours Compare Products
MiniSun Pack of 10 15mm Red LED Decking Lights Compare Products
IP65 9w SMD LED Outdoor Wall / Ceiling Bulkhead Daylight Compare Products
MiniSun BC 4w 36 SMD LED Candle Bulb 6000k 330 Lumens Compare Products

Ukai Black Fishermans Wall Light

Product Code: 18858
Ukai Black Fishermans Wall Light Compare Products
Children’s Patchwork Countryside NE Fabric Pendant Shade Compare Products
16W, 4ft T8 LED Tube, 4000K, 1,770lm Compare Products
16W, 4ft T8 LED Tube, 6000K, 1,770lm Compare Products
MiniSun Pack of 30 40mm Blue LED Decking Lights Compare Products

Mini G9 IP44 Flush Bathroom Light

Product Code: 16704
Mini G9 IP44 Flush Bathroom Light Compare Products
Trumpet Touch Table Lamp Black Chrome / White Compare Products
Trumpet Touch Table Lamp Chrome / Black Compare Products

Nevada 4 Tiered NE Pendant Cream

Product Code: 15627
Discontinued
Nevada 4 Tiered NE Pendant Cream Compare Products
Illuminated Extending Magnifying Mirror Battery Operated 150mm Compare Products
MiniSun 9W LED 4 PIN 2700K (16W) 2D Retro Fit Bulb Compare Products
MiniSun 12W LED 4 PIN 2700K (28W) 2D Retro Fit Bulb Compare Products
MiniSun 18W LED 4 PIN 6500K (38W) 2D Retro Fit Bulb Compare Products
Arnside Polypropylene 60W  IP44 Bulkhead White Compare Products
Flush Surface Mounted Microwave Sensor Compare Products
Cooper Adjustable Head light Table Lamp CHROME Compare Products

Delta NE Pendant Shade SILVER

Product Code: 19089
Delta NE Pendant Shade SILVER Compare Products

1 - 48 of 159

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