Please wait...

Product added to Basket successfully

Continue shopping
Go to shopping basket
Continue shopping
Go to shopping basket

Tripod Floor Lamps

Tripod Floor 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_5` AS `e` INNER JOIN `catalog_category_product_index` AS `cat_index` ON cat_index.product_id=e.entity_id AND cat_index.store_id=5 AND cat_index.visibility IN(2, 4) AND cat_index.category_id = '315' INNER JOIN `catalog_product_index_price` AS `price_index` ON price_index.entity_id = e.entity_id AND price_index.website_id = '2' 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 = 2 LEFT JOIN `aa_smart_category_bestseller` AS `bestseller` ON e.entity_id = bestseller.product_id AND bestseller.store_id=5 LEFT JOIN `aa_smart_category_newproducts` AS `newproducts` ON e.entity_id = newproducts.product_id AND newproducts.store_id=5 WHERE (e.status = 1) GROUP BY `e`.`entity_id` ORDER BY `dyn_pos` ASC, `sold_quantity` DESC LIMIT 48

Items 1 to 48 of 316 total

Set Descending Direction
per page

Page:
  1. 1
  2. 2
  3. 3
  4. 4
  5. 5
Small
Large

Items 1 to 48 of 316 total

Set Descending Direction
per page

Page:
  1. 1
  2. 2
  3. 3
  4. 4
  5. 5

TRIPOD FLOOR LAMPS

Lighting can make or break a room so finding the right tripod floor lamp for your home is important. Our impressive range gives you the chance to explore your creativity and be bold with style. From our Camden to our Crawford, tripod floor lamps are a perfect alternative to a simple wall or ceiling light.

View Description

Iconiclights is rated 4.5 out of 5 stars by Reviews.co.uk based on 1278 reviews