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 = '519' 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

28 Item(s)

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

28 Item(s)

per page