Please wait...

Product added to Basket successfully

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

Reflector Bulbs

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

Reflector Bulbs

Reflector bulbs are most commonly used in spotlights. The interior is usually painted silver to reflect the light. With a wide beam angle they are suited for directional lighting such as track lighting, recessed ceiling lights and desk lamps. The bulb is shaped in such a manner that the required light distribution is achieved by reflection from the coating. In order to eliminate highlights, which are particularly noticeable in illumination at short distances, part of the bulb through which the lamp’s light flux passes is given a frosted finish.

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