Deals on Desk/Task lamps until 23rd August. See the full ranges below.
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 = '544' 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

20 Item(s)

per page
Hannah Wood And Light Pink LED Task Lamp Compare Products
Monda Cool Grey Adjustable Desk Lamp Compare Products
Edvard 6W LED Grey Flexible Desk Lamp Compare Products
Edvard 6W LED Grey Flexible Clamp Lamp Compare Products
Edvard 6W LED Chrome Flexible Clamp Lamp Compare Products
Marley Matt Black Curved Desk Lamp Red Flex Compare Products
Arkwright Matt Black Curved Desk Lamp Compare Products
Excee Matt Black Modern Desk Lamp Compare Products
Polaris Black 5w 6500K 350lm Dimmable Task Lamp

Out of stock

Compare Products

Portishead Cream Clip Spotlight

Product Code: 21619
Portishead Cream Clip Spotlight Compare Products
Portishead Satin Nickel Clip Spotlight

Out of stock

Compare Products
Portishead Satin Copper Clip Spotlight Compare Products

Tasca Red Clip On Spot Lamp

Product Code: 19653
Tasca Red Clip On Spot Lamp Compare Products

Portishead White Clip Spotlight

Product Code: 21617
Portishead White Clip Spotlight Compare Products
Portishead Duck Egg Blue Clip Spotlight Compare Products
Linea Silver 6W LED Adjustable Clamp Desk / Task Lamp Compare Products

Tasca White Clip On Spot Lamp

Product Code: 19651
Tasca White Clip On Spot Lamp Compare Products
KLO White Flexi Neck Clip-on Desk / Task Lamp Compare Products
Huey Single White Clip On Lamp 3W LED Lamp 6000K Compare Products
Hannah Wood and White LED Task Lamp Compare Products

20 Item(s)

per page
Deals on Desk/Task lamps until 23rd August. See the full ranges below.