Please wait...

Product added to Basket successfully

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

Novelty Lighting

Novelty Lighting

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 = '88' 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 `catalog_product_index_eav` AS `bulb_shape_idx` ON bulb_shape_idx.entity_id = e.entity_id AND bulb_shape_idx.attribute_id = '513' AND bulb_shape_idx.store_id = 6 AND bulb_shape_idx.value IN('1256') 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

Novelty Lighting

Our novelty lights cover a range of lighting designs. From sensory lamps, decorative shades and fairy lights we have it covered. Novelty lamps provide a fun alternative to traditional lighting, particularly for children's bedroom lights. With our range of playful designs and vibrant colours our novelty lighting will not disappoint. 

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