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

19 Item(s)

per page
MiniSun Cobra2 Round 18W LED Downlight 6500K 1300 Lumens Compare Products
MiniSun Cobra2 Round 18W LED Downlight 3000K 1300 Lumens Compare Products
MiniSun Cobra2 Round 12W LED Downlight 6500K 900 Lumens

Out of stock

Compare Products
MiniSun Cobra2 Round 12W LED Downlight 3000K 900 Lumens Compare Products
MiniSun Cobra2 Round 8W LED Downlight 3000K 500 Lumens Compare Products
MiniSun Cobra2 Round 5W LED Downlight 3000K 320 Lumens Compare Products
Vault Over Table 20W LED SMD Suspension 1800lm Compare Products
Zenith Tri-Tone Blue White (12W + 6W) LED Downlight 6500K Compare Products
Voyager 12V LED Recessed Silver Downlight 6500K Compare Products
MiniSun Cobra Round 12W LED Downlight 3000K 960 lumens Compare Products
MiniSun Cobra Round 18W LED Downlight 6500K 1280 lumens

Out of stock

Compare Products
MiniSun Celica Square 9W LED Downlight 3000K 720 lumens Compare Products
MiniSun Celica Square 12W LED Downlight 3000K 960 lumens Compare Products
MiniSun Celica Square 15W LED Downlight 3000K 1200 lumens Compare Products
MiniSun Celica Square 18W LED Downlight 3000K 1280 lumens Compare Products
MiniSun Celica Square 12W LED Downlight 6500K 960 lumens Compare Products
MiniSun Celica Square 15W LED Downlight 6500K 1200 lumens Compare Products
MiniSun Cobra2 Round 5W LED Downlight 6500K 320 Lumens

Out of stock

Compare Products
MiniSun Cobra2 Round 8W LED Downlight 6500K 500 Lumens

Out of stock

Compare Products

19 Item(s)

per page