minimum 3 symbolds
Office Supplies

Torches

FILTER
  • Price
    from
    to
  • Manufacturer
    more
  • Color
    more
  • Lamp Type
    more
  • Light flow
    more
  • Lantern Type
    more
  • Switching-on versions
    more
  • Lamp power
    more
SELECT `e`.*, `cat_index`.`position` AS `cat_index_position`, `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_entity` AS `e` INNER JOIN `catalog_category_product_index` AS `cat_index` ON cat_index.product_id=e.entity_id AND cat_index.store_id=2 AND cat_index.visibility IN(2, 4) AND cat_index.category_id = '503' 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 ORDER BY `e`.`entity_id` DESC, `cat_index_position` DESC LIMIT 12
Torches
Hama "Outdoor" LED Lamp (107298)
sku. 4931180
  • Warranty: 0
  • Lantern Type: LED
  • Lamp Type: LED
  • Number of lamps: 1
  • Color: black/orange
  • Weight: 160 g
  • Manufacturer: Hama
Torches
Era Torch EL96S/B0026988
sku. 492551
  • Warranty: 0
  • Lantern Type: LED
  • Lamp Type: LED
  • Lamp power: 5 W
  • Light flow: 320 lm
  • Color: white/orange
  • Manufacturer: ERA
Torches
Era Torch EL60S/B0026987
sku. 492550
  • Warranty: 0
  • Lantern Type: LED
  • Lamp Type: LED
  • Lamp power: 6.9 W
  • Light flow: 414 lm
  • Color: white/orange
  • Manufacturer: ERA
Torches
Hama FL-70 Torch (123198)
sku. 493067
  • Warranty: 0
  • Lantern Type: LED
  • Lamp Type: LED
  • Lamp power: 0.5 W
  • Light flow: 30 lm
  • Battery type: 12 V/7 Ah
  • Weight: 50 g
  • Manufacturer: Hama
Torches
Trofi Torch TL30 30xLED/B0002595
sku. 492606
  • Warranty: 0
  • Lantern Type: LED
  • Lamp Type: LED
  • Color: silver
  • Manufacturer: Trofi
Torches
Trofi Torch TK20 20xLED/B0002591
sku. 492605
  • Warranty: 0
  • Lantern Type: LED
  • Lamp Type: LED
  • Color: orange
  • Manufacturer: Trofi
Torches
Trofi Torch TA7 7xLED/B0004431
sku. 492604
  • Warranty: 0
  • Lantern Type: LED
  • Lamp Type: LED
  • Color: black/orange
  • Manufacturer: Trofi
Torches
Trofi Torch TA11/B0010038
sku. 492603
  • Warranty: 0
  • Lantern Type: LED
  • Lamp Type: LED
  • Lamp power: 1 W
  • Color: black/orange
  • Manufacturer: Trofi
Torches
Trofi Torch TA1 1xLED/B0005797
sku. 492602
  • Warranty: 0
  • Lantern Type: LED
  • Lamp Type: LED
  • Color: black/orange
  • Manufacturer: Trofi
Torches
Era Torch UB-402 3A/B0029193
sku. 492515
  • Warranty: 0
  • Lantern Type: LED
  • Lamp Type: LED
  • Number of lamps: 5
  • Lamp power: 1.5 W
  • Light flow: 120 lm
  • Battery type: SR-1130
  • Manufacturer: ERA
Torches
Era Torch SDA30M/B0020023
sku. 492514
  • Warranty: 0
  • Lantern Type: LED
  • Lamp Type: LED
  • Number of lamps: 5
  • Lamp power: 0.5 W
  • Light flow: 40 lm
  • Accumulator type: Ni-MH
  • Color: black
  • Manufacturer: ERA
Torches
Era Torch KA10S/B0025642
sku. 492509
  • Warranty: 0
  • Lantern Type: LED
  • Lamp Type: LED
  • Lamp power: 1 W
  • Light flow: 72 lm
  • Accumulator type: Ni-MH
  • Color: white
  • Manufacturer: ERA