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

37 Item(s)

per page
ICONIC Washington Flush 3 Tier K9 Ceiling Light Compare Products
ICONIC Palladium Gold K9 Flush Ceiling Light Compare Products
Cymbal Round Flush Ceiling Light in Grey Compare Products
ICONIC Ice Cube Chrome Waterfall Droplet Flush Ceiling Light Compare Products
Folly 4 Way IP44 Bathroom K5 Crystal Ceiling Light Compare Products
Halston Bling 18W LED Round Ceiling Light Compare Products
Chantilly Ice Droplet IP44 Flush Ceiling Fitting Chrome Compare Products
ICONIC Velar K5 Crystal LED 24W Flush Ceiling Light 4000K Compare Products
ICONIC Sapporo Double Loop 46W LED Crystal Ceiling Light Compare Products
Hesketh Large Square Flush Ceiling Light Compare Products
Belgrave Acrylic Flush Basket Chrome Ceiling Light IP44 Rated Compare Products
Dania 12W LED K5 Crystal Flush Ceiling Light Compare Products
Mimas 9W LED K5 Crystal Flush Ceiling Light Compare Products
Alastor IP44 Flush Ceiling Bathroom Light 12W LED K5 Crystal Compare Products
Altro 12W LED IP44 K5 Crystal Flush Bathroom Ceiling Light Compare Products
Jette K5 Crystal Droplet Flush Ceiling Light Compare Products
Rikyu K5 Crystal Droplet IP44 Ceiling Light Compare Products
Maklin 9W LED Sparkle Glass Flush Ceiling Light Compare Products
Glist Sparkle Wave Flush Ceiling Light Compare Products
Mexico 18W LED Flush Ceiling Light In Gold Compare Products
Brillare 18W Crystal Halo Flush Ceiling Light Compare Products
Hesketh Small Square Flush Ceiling Light Compare Products
Jewel Tiffany Semi Flush Uplighter Amber Compare Products
Rowan Antique Brass Flush Ceiling Light Marble Glass Compare Products
Glass Flush Ceiling Light In White With Wheat Design - Valuelights Compare Products
Barton Square Flush Ceiling Light With K5 Crystal Accents Compare Products
Mirage Square Glass Flush Ceiling Light with Jewel Accents Compare Products
Small Portale Acid Etched Flush Ceiling Light 60W E27x1 Compare Products
Henley Round Flush Ceiling Light with K5 Crystal Accents Compare Products
Palmer Round Glass Flush Ceiling Light Compare Products
Cymbal Round Flush Ceiling Light with White Bezel Opal Glass Compare Products
Isaac Round Flush Ceiling Light Opal Glass Compare Products
Ohio Flush Round Ceiling Light Feather Design Glass Compare Products
Dragonfly Tiffany Flush Uplighter Ceiling Light Compare Products
Alesis Bulkhead Flush Ceiling Light 60W E27x1 Compare Products
Hesketh Medium Square Flush Ceiling Light Compare Products
Cymbal Round Flush Ceiling Light Chrome Bezel Opal Glass

Out of stock

Compare Products

37 Item(s)

per page