Please wait...

Product added to Basket successfully

Continue shopping
View cart & checkout
Continue shopping
View cart & checkout

Bathroom Ceiling Lights

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`, `cc`.`stock_status` AS `new`, `cc`.`qty` AS `quantity`, `bestseller`.`qty_ordered` AS `sold_quantity`, `bestseller`.`store_id` AS `best_store_id`, `newproducts`.`store_id` AS `new_store_id`, CASE WHEN `cc`.stock_status = 1 AND COALESCE(bestseller.qty_ordered) > 99 THEN 1 WHEN `cc`.stock_status = 1 AND COALESCE(bestseller.qty_ordered) > 49 AND COALESCE(bestseller.qty_ordered) < 100 THEN 2 WHEN `cc`.stock_status = 1 AND COALESCE(bestseller.qty_ordered) > 10 AND COALESCE(bestseller.qty_ordered) < 50 THEN 3 WHEN `cc`.stock_status = 1 AND COALESCE(newproducts.is_new) = 1 THEN 4 WHEN `cc`.stock_status = 1 AND COALESCE(`cc`.qty ) >= 5 THEN 5 WHEN `cc`.stock_status = 1 AND COALESCE(`cc`.qty ) < 5 AND COALESCE(`cc`.qty > 0) THEN 6 WHEN `cc`.qty = 0 OR COALESCE(`cc`.stock_status) = 0 THEN 7 END AS `dyn_pos` FROM `catalog_product_flat_6` AS `e` INNER JOIN `catalog_category_product_index` AS `cat_index` ON cat_index.product_id=e.entity_id AND cat_index.store_id=6 AND cat_index.visibility IN(2, 4) AND cat_index.category_id = '589' INNER JOIN `catalog_product_index_price` AS `price_index` ON price_index.entity_id = e.entity_id AND price_index.website_id = '1' AND price_index.customer_group_id = 0 INNER JOIN `cataloginventory_stock_status` AS `cc` ON cc.product_id = e.entity_id AND cc.website_id = 1 LEFT JOIN `aa_smart_category_bestseller` AS `bestseller` ON e.entity_id = bestseller.product_id AND bestseller.store_id=6 LEFT JOIN `aa_smart_category_newproducts` AS `newproducts` ON e.entity_id = newproducts.product_id AND newproducts.store_id=6 WHERE (e.status = 1) GROUP BY `e`.`entity_id` ORDER BY `dyn_pos` ASC, `sold_quantity` DESC LIMIT 48

Set Descending Direction
per page
Small
Large

Set Descending Direction
per page

Bathroom Ceiling Lights

Bathroom ceiling lights are an essential part of any bathroom. Our lights come with IP44 ratings, meaning you need not worry about any water damage to the lighting fixture. 

Valuelights is rated 4.6 stars by Reviews.co.uk based on 1593 reviews