Please wait...

Product added to Basket successfully

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

Living Room Table Lamps

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 = '578' 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
Page:
  1. 1
  2. 2
  3. 3
  4. 4
  5. 5
per page
Small
Large

Set Descending Direction
Page:
  1. 1
  2. 2
  3. 3
  4. 4
  5. 5
per page

Living Room Table Lamps

Our collection of living room table lamps come in a huge variety of styles. This will enable you to beautifully combine styles of lighting to create the perfect living room setting.

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