Pentru o livrare cat mai rapida va recomandam sa alegeti produse cu stoc in Magazin fizic si in Depozit Online. Produsele cu Stoc furnizor au termen de livrare mai mare si pot intarzia comanda dvs.
articole de pescuit Gama variata de produse

La Claumar Pescar poti alege simplu si rapid dintr-o gama variata de articole de pescuit.

transport gratuit Transport Gratuit

Comenzile peste 400 lei pot beneficia de transport gratuit.

Vezi mai multe detalii

plata in rate Plata cu cardul

Plata cu cardul in rate fara dobanda.

Vezi mai multe detalii

suport Suport 10-18

Suportul telefonic este 10-18. Orice intrebare ai avea, stim ca nu poate astepta. Apeleaza serviciul Suport 10-18! Un consultant asteapta sa iti preia apelul in intervalul orar 10-18 de luni pana vineri.

Vezi mai multe detalii

returnare Returnare simplu in 14 zile

Retur simplu in 14 zile.

Vezi mai multe detalii

Filtreaza

Felinar Nebo Galileo Air 1000 Lm, 2500mah 104050 3.7v Lithium Poly

Felinar Nebo Galileo Air 1000 Lm, 2500mah 104050 3.7v Lithium Poly

neb-ltn-1003-g
Livrare imediată!

179,90Lei

Felinar Nebo Big Poppy Rechargeable, 300 Lm

Felinar Nebo Big Poppy Rechargeable, 300 Lm

ne6908
Livrare imediată!

159,90Lei

Sistem Iluminare Fox Rx+ Security Sistem
Exclusiv online!

Sistem Iluminare Fox Rx+ Security Sistem

cei222
Livrare 7-14 zile

1.889,96Lei

Sistem Iluminare Fox Rx+ Light & Remote
Exclusiv online!

Sistem Iluminare Fox Rx+ Light & Remote

cei218
Livrare 7-14 zile

1.349,96Lei

Lampa De Cort Ngt Power Bank System Large, 21x3.5x3.5cm

Lampa De Cort Ngt Power Bank System Large, 21x3.5x3.5cm

ngt-ftl-bivvylight-lrg
Livrare imediată!

129,00Lei

Felinar Nebo Poppy, 300 Lm, Aa Batteries

Felinar Nebo Poppy, 300 Lm, Aa Batteries

neb-ltn-6555-g
Livrare imediată!

99,90Lei

Felinar Black Cat Rechargable Bivvy Light
Exclusiv online!

Felinar Black Cat Rechargable Bivvy Light

bo300002
Livrare 7-14 zile

112,46Lei

Lanterna Coleman Batteryguard 600lcu Baterii -31%

Lanterna Coleman Batteryguard 600lcu Baterii

2000033874
Stoc epuizat

215,00Lei(-31%) 148,51Lei

Lanterna Cort Sonik Herox Bivvy Light

Lanterna Cort Sonik Herox Bivvy Light

hc0103
Stoc epuizat

152,24Lei

Lanterna Cattara Multifunctionala Led 600lm Cob Cu Tripod Pliabil

Lanterna Cattara Multifunctionala Led 600lm Cob Cu Tripod Pliabil

tt13153
Stoc epuizat

69,00Lei

Lampa Si Baterie Externa Ngt Powerbank 10400mah Multifunctional -29%

Lampa Si Baterie Externa Ngt Powerbank 10400mah Multifunctional

ngt-ftl-light-bank
Stoc epuizat

225,01Lei(-29%) 160,71Lei

Lampa Cort Ngt Large Plus Power Bank System -29%

Lampa Cort Ngt Large Plus Power Bank System

ngt-ftl-bvvylight-lrg
Stoc epuizat

129,00Lei(-29%) 92,14Lei

Lampa Camping Nevis Cu Acumulator -28%

Lampa Camping Nevis Cu Acumulator

4813-001
Stoc epuizat

117,00Lei(-28%) 83,75Lei

Lampa Prologic Magnetica Cu Telecomanda +cablu Usb -42%

Lampa Prologic Magnetica Cu Telecomanda +cablu Usb

svs65000
Stoc epuizat

172,75Lei(-42%) 99,90Lei

Lampa Carp Zoom Cort Dimmable 3w 220 Lumens -23%

Lampa Carp Zoom Cort Dimmable 3w 220 Lumens

cz3023
Stoc epuizat

73,99Lei(-23%) 57,12Lei

Lanterna Magnetica Reincarcabila Led Lenser If8r Powerbank 4500 Lumeni -24%

Lanterna Magnetica Reincarcabila Led Lenser If8r Powerbank 4500 Lumeni

a8.z502002
Stoc epuizat

1.085,45Lei(-24%) 822,31Lei

Reflector Fox Halo Photography Light

Reflector Fox Halo Photography Light

cei176
Stoc epuizat

202,45Lei

Lampa De Cort Carp Spirit Cu Led Si Functie Acumulator -25%

Lampa De Cort Carp Spirit Cu Led Si Functie Acumulator

acs380011
Stoc epuizat

229,00Lei(-25%) 172,55Lei

Proiector Ngt Profiler 21 Led Solar 525 Lumeni 15 X 9.5 X 3.5 Cm -29%

Proiector Ngt Profiler 21 Led Solar 525 Lumeni 15 X 9.5 X 3.5 Cm

ngt-ftl-light-profiler
Stoc epuizat

221,99Lei(-29%) 158,57Lei

Lampa Delphin Zuum 10x4x4cm

Lampa Delphin Zuum 10x4x4cm

900013014
Stoc epuizat

29,00Lei

Afişare 61 - 80 din 86 (5 pagini)

Descoperă gama noastră de lămpi și felinare, ideale pentru camping, pescuit și activități outdoor.
Lămpile LED și felinarele reîncărcabile oferă iluminare puternică și autonomie extinsă.
Alege lămpi solare și felinare portabile, perfecte pentru utilizare fără baterii suplimentare.
Modelele impermeabile și rezistente la apă sunt ideale pentru orice condiții meteo.
Lămpile pentru pescuit asigură vizibilitate optimă în timpul partidelor nocturne.
Felinarele cu acumulator și autonomie mare sunt excelente pentru excursii lungi.
Produsele cu design compact și greutate redusă sunt ușor de transportat și depozitat.
Felinarele pentru drumeții oferă o lumină stabilă și eficientă pe trasee dificile.
Toate produsele sunt testate pentru durabilitate și siguranță în utilizare intensă.
Alege lămpi și felinare de calitate pentru o iluminare fiabilă în orice aventură!

Queries: 18, Total time: 9.273 ms [By time] [By id] [By file]
1 (0.085)
SELECT data
FROM `oc_session`
WHERE session_id = 'dd28b4ead4ddedbc101713712e'
/var/www/clients/client1/web1/web/system/library/session/db.php:24
2 (0.095)
SELECT `trigger`, `action`
FROM oc_event
/var/www/clients/client1/web1/web/index.php:453
3 (0.111)
SELECT *
FROM oc_url_alias
WHERE keyword = 'camping'
/var/www/clients/client1/web1/web/catalog/controller/common/seo_url.php:48
4 (0.095)
SELECT *
FROM oc_url_alias
WHERE keyword = 'lanterne-felinare-proiectoare'
/var/www/clients/client1/web1/web/catalog/controller/common/seo_url.php:48
5 (0.088)
SELECT *
FROM oc_url_alias
WHERE keyword = 'lampi-si-felinare'
/var/www/clients/client1/web1/web/catalog/controller/common/seo_url.php:48
6 (0.388)
SELECT *
FROM oc_category c
LEFT JOIN oc_category_description cd ON (c.category_id = cd.category_id)
LEFT JOIN oc_category_to_store c2s ON (c.category_id = c2s.category_id)
WHERE c.parent_id = '607' AND cd.language_id = '2' AND c2s.store_id = '2' AND c.status = '1'
ORDER BY c.sort_order, LCASE(cd.name)
/var/www/clients/client1/web1/web/catalog/model/catalog/category.php:46
7 (2.647)
CREATE TEMPORARY TABLE oc_bf_tmp_product (PRIMARY KEY (`product_id`)) ENGINE=InnoDB SELECT p.product_id, p.sort_order, p.quantity, p.manufacturer_id, "1" AS match_filters, (IF(MIN(ps.price) IS NOT NULL, MIN(ps.price), p.price) * (1 + IFNULL(percent_tax, 0)/100) + IFNULL(fixed_tax, 0)) AS actual_price
FROM `oc_product` AS p
INNER JOIN `oc_product_to_store` AS p2s ON (p2s.product_id = p.product_id)
INNER JOIN `oc_bf_filter` AS f ON (p.product_id = f.product_id)
INNER JOIN `oc_product_to_category` AS p2c ON (p.product_id = p2c.product_id)
LEFT JOIN `oc_product_special` AS ps ON (ps.product_id = p.product_id AND (ps.date_end = '0000-00-00' OR ps.date_end > NOW()) AND (ps.date_start = '0000-00-00' OR ps.date_start < NOW()) AND ps.customer_group_id = '1')
LEFT JOIN ( SELECT SUM(fixed_rate) AS fixed_tax, SUM(percent_rate) AS percent_tax, tax_class_id
FROM `oc_bf_tax_rate`) AS tx ON (p.tax_class_id = tx.tax_class_id)
WHERE p2s.store_id = '2' AND p2c.category_id = '607' AND p.status_filtru > 0 AND p.price > 0 GROUP BY p.product_id
/var/www/clients/client1/web1/web/catalog/model/module/brainyfilter.php:857
8 (0.094)
SELECT COUNT(1) AS total
FROM ( SELECT p.*
FROM `oc_bf_tmp_product` AS p
WHERE match_filters = 1) AS t
/var/www/clients/client1/web1/web/catalog/model/catalog/product.php:1593
9 (0.601)
SELECT p.*, pp.sort_order, pp.viewed, IF ((pp.quantity) > 0, 1, 0) AS array_quantity
FROM `oc_bf_tmp_product` AS p
INNER JOIN `oc_product_description` AS pd ON (pd.product_id = p.product_id)
INNER JOIN `oc_product` AS pp ON (pp.product_id = p.product_id)
WHERE match_filters = 1 AND pd.language_id = '2'
ORDER BY array_quantity DESC, pp.sort_order ASC, pp.viewed DESC, pd.name DESC LIMIT 60, 20
/var/www/clients/client1/web1/web/catalog/model/catalog/product.php:184
10 (0.103)
SELECT *
FROM oc_stock_status
WHERE furnizor LIKE '%"RAPALA VMC ROMANIA SRL"%' AND language_id = '2'
/var/www/clients/client1/web1/web/catalog/model/catalog/product.php:130
11 (3.119)
SELECT a.attribute_group_id AS group_id, av.attribute_id AS attr_id, av.attribute_value_id AS val_id, ad.name AS attr_name, av.sort_order AS val_sort, av.value
FROM `oc_bf_product_attribute_value` AS af
INNER JOIN `oc_bf_tmp_product` AS p ON (af.product_id = p.product_id)
INNER JOIN `oc_bf_attribute_value` AS av ON (af.attribute_value_id = av.attribute_value_id)
INNER JOIN `oc_attribute` AS a ON (a.attribute_id = av.attribute_id)
INNER JOIN `oc_attribute_description` AS ad ON (ad.attribute_id = a.attribute_id)
WHERE ad.language_id = '2' AND av.language_id = '2' AND match_filters = 1 GROUP BY av.attribute_value_id
ORDER BY a.sort_order, ad.name, av.sort_order, CAST(av.value AS UNSIGNED), av.value
/var/www/clients/client1/web1/web/catalog/model/module/brainyfilter.php:1286
12 (0.264)
SELECT DISTINCT m.manufacturer_id AS id, CONCAT(UCASE(LEFT(m.name, 1)), LCASE(SUBSTRING(m.name, 2))) AS name
FROM `oc_manufacturer` AS m
INNER JOIN `oc_bf_tmp_product` AS p ON (m.manufacturer_id = p.manufacturer_id)
WHERE match_filters = 1
ORDER BY m.sort_order, m.name
/var/www/clients/client1/web1/web/catalog/model/module/brainyfilter.php:1393
13 (0.075)
SELECT stock_status_id AS id, name
FROM `oc_stock_status`
WHERE language_id = '2'
/var/www/clients/client1/web1/web/catalog/model/module/brainyfilter.php:1415
14 (0.080)
SELECT MIN(actual_price) AS min, MAX(actual_price) AS max
FROM `oc_bf_tmp_product` AS p
WHERE match_filters = 1
/var/www/clients/client1/web1/web/catalog/model/module/brainyfilter.php:1180
15 (1.054)
SELECT COUNT(1) AS val, filter_group, filter_id
FROM `oc_bf_tmp_product` AS p
INNER JOIN `oc_bf_filter` AS f ON (p.product_id = f.product_id)
WHERE match_filters = 1 AND f.language_id = '2' GROUP BY filter_group, filter_id
/var/www/clients/client1/web1/web/catalog/model/module/brainyfilter.php:1094
16 (0.140)
SELECT *
FROM `oc_pb_bundles`
WHERE `products` != '' AND `status`= '1' AND type = '1' AND `date_available` <= NOW() AND `customer_type` = 0 AND `categories_show` LIKE '%"607"%' LIMIT 0, 1000
/var/www/clients/client1/web1/web/catalog/model/module/productbundles.php:106
17 (0.151)
SELECT *
FROM `oc_pb_bundles`
WHERE `products` != '' AND `status`= '1' AND type = '0' AND `date_available` <= NOW() AND `customer_type` = 0 AND `categories_show` LIKE '%"607"%' LIMIT 0, 1000
/var/www/clients/client1/web1/web/catalog/model/module/product_recomandate.php:106
18 (0.083)
SELECT *
FROM `oc_mxt_setting`
WHERE store_id = '2' AND name = 'lichidare_stoc'
/var/www/clients/client1/web1/web/catalog/model/catalog/category.php:37