Check out our range of outdoor lighting products, including Buddy the Blue Tooth Speaker.
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 = '516' 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 118

Page:
  1. 1
  2. 2
  3. 3
per page
3m Extension Cable for Minisun 40mm Deck Lights Compare Products
3m Extension Cable for Minisun 15mm Deck Lights Compare Products
MiniSun Pack of 10 40mm Warm White LED Decking Lights Compare Products
MiniSun Pack of 10 15mm White LED Decking Lights Compare Products
MiniSun Pack of 6 40mm White LED Decking Lights Compare Products
MiniSun Pack of 10 40mm White LED Decking Lights Compare Products
MiniSun Pack of 20 40mm White LED Decking Lights Compare Products
MiniSun Pack of 30 40mm White LED Decking Lights Compare Products
MiniSun Pack Of 6 60mm Cool White LED Decking Lights Compare Products
MiniSun Pack Of 9 60mm Cool White LED Decking Lights Compare Products
MiniSun Pack of 10 15mm Warm White LED Decking Lights Compare Products
MiniSun Pack Of 6 60mm Warm White LED Decking Lights Compare Products
MiniSun Pack Of 9 60mm Warm White LED Decking Lights Compare Products
MiniSun Pack of 10 15mm Blue LED Decking Lights Compare Products
MiniSun Pack of 20 15mm Blue LED Decking Lights Compare Products
MiniSun Pack of 6 40mm Blue LED Decking Lights Compare Products
MiniSun Pack of 10 40mm Blue LED Decking Lights Compare Products
MiniSun Pack of 20 40mm Blue LED Decking Lights Compare Products
MiniSun Pack of 30 40mm Blue LED Decking Lights Compare Products
MiniSun Pack Of 6 60mm Blue LED Decking Lights Compare Products
MiniSun Pack Of 9 60mm Blue LED Decking Lights Compare Products
MiniSun Pack of 10 15mm Red LED Decking Lights Compare Products
MiniSun Pack of 10 15mm Lilac LED Decking Lights Compare Products
MiniSun Pack of 10 40mm Lilac LED Decking Lights Compare Products
MiniSun Pack of 10 40mm Remote Control RGB LED Decking Light Compare Products
MiniSun Pack of 6 15mm White LED Decking Lights Compare Products
MiniSun Pack of 20 15mm White LED Decking Lights Compare Products
MiniSun Pack of 6 15mm Blue LED Decking Lights Compare Products
Stern IP66 Round Polished Aluminium Nautical Bulkhead Compare Products
Buddy The Bluetooth LED RGB Garden Speaker IP44 10W 120mm Compare Products
Aquirre IP44 Stainless Steel Twin Outdoor Box Wall Light Compare Products
Ryston IP54 Outdoor Black Up Down Wall Light Compare Products
Colbert IP44 Stainless Steel Curved Outdoor Box Wall Light Compare Products
Copper PIR IP44 Up Down Wall Light Copper Compare Products
Delgado IP44 Stainless Steel Outdoor Box Wall Light Compare Products
Dorset IP44 Outdoor Wall Lantern Black Stainless Steel Compare Products
Seaton Black IP45 External Wall Light Compare Products
Planter White Glaze Wall Light - Paint Me Compare Products
Stainless Steel IP44 Outdoor Up/Down Wall Light for Energy Saving Bulbs Compare Products
Black Outdoor IP44 Up/Down Wall Light Energy Saving GU10 Compare Products
Gainsford 50W GU10 Up / Down IP44  Wall Light Stainless Steel Compare Products
Gainsford 50W GU10 Up / Down IP44  Wall Light Copper Compare Products
Trenley 2x 3W LED GU10 Up / Down Light IP44  Wall Light Compare Products
Barrow 50W GU10 Down Light IP44  Wall Light Stainless Steel Compare Products
Stainless Steel IP44 Wall Down Light NO BULBS Compare Products
Darlington 35W GU10 IP44  Wall Light Stainless Steel Compare Products
Berwick IP65 3 in 1  Ground, Wall Spike Outdoor Light Compare Products
MiniSun Outdoor Ground Spike / Wall Light Compare Products

1 - 48 of 118

Page:
  1. 1
  2. 2
  3. 3
per page
Check out our range of outdoor lighting products, including Buddy the Blue Tooth Speaker.