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 300 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

Căutare

Produse ce potrivesc criteriilor de căutare


LANTERNA LEDLENSER TFX ARCTURUS 6500 6500LM/LI-ION CABLU USB
Exclusiv online!

LANTERNA LEDLENSER TFX ARCTURUS 6500 6500LM/LI-ION CABLU USB

a8.z502559
Livrare 24-48 ore

1.135,51Lei

LANTERNA LEDLENSER K4R 120LM LI-ION
Exclusiv online!

LANTERNA LEDLENSER K4R 120LM LI-ION

a8.z502574
Livrare 24-48 ore

87,16Lei

LANTERNA LEDLENSER TFX PROPUS 3500 3500LM/LI-ION CABLU USB
Exclusiv online!

LANTERNA LEDLENSER TFX PROPUS 3500 3500LM/LI-ION CABLU USB

a8.z502557
Livrare 24-48 ore

689,19Lei

LANTERNA LEDLENSER TFX ARCTURUS 5000 5000LM/LI-ION CABLU USB
Exclusiv online!

LANTERNA LEDLENSER TFX ARCTURUS 5000 5000LM/LI-ION CABLU USB

a8.z502558
Livrare 24-48 ore

887,48Lei

Lanterna Portofel LedLenser Black 150lm + Acumulator + USB -20%
Exclusiv online!

Lanterna Portofel LedLenser Black 150lm + Acumulator + USB

a8.z502315
Livrare 24-48 ore

74,43Lei(-20%) 59,54Lei

Set Lanterne LedLenser P7R Core + P3 Core -20%
Exclusiv online!

Set Lanterne LedLenser P7R Core + P3 Core

a8.z502947
Livrare 24-48 ore

569,37Lei(-20%) 455,50Lei

Acumulator Ledlenser Li-FePO4 3,2v/3000mAh pentru I9R IRON
Exclusiv online!

Acumulator Ledlenser Li-FePO4 3,2v/3000mAh pentru I9R IRON

a8.zsp5609.r.sr
Livrare 24-48 ore

52,01Lei

Lanterna Cap Ledlenser MH3 Grey, 200lm
Exclusiv online!

Lanterna Cap Ledlenser MH3 Grey, 200lm

a8.z501597
Livrare 24-48 ore

169,90Lei

Lanterna, Portofel, LedLenser, Brown, 150lm, +, Acumulator, +, USB, a8.z502400, Lanterne de Mana, Lanterne de Mana Led Lenser, Lanterne Led Lenser, Mana Led Lenser, Led Lenser -20%
Lanterna, de, Cap, LedLenser, MH7, cu, Acumulator,, Grey,, 600lm, a8.z501599, Lanterne de Cap, Lanterne de Cap Led Lenser, Lanterne Led Lenser, Cap Led Lenser, Led Lenser -20%
PROTECTIE LEDLENSER PT. LANTERNA H14 L7 M7 P7 T7
Exclusiv online!

PROTECTIE LEDLENSER PT. LANTERNA H14 L7 M7 P7 T7

a8.z0313
Livrare 24-48 ore

12,05Lei

INCARCATOR LEDLENSER MAGNETIC TYPE A PENTRU P/H

INCARCATOR LEDLENSER MAGNETIC TYPE A PENTRU P/H

a8.z502265
Livrare imediată!

33,94Lei

LANTERNA LEDLENSER P18R SIGNATURE 4500LM/LI-ION CABLU USB
Exclusiv online!

LANTERNA LEDLENSER P18R SIGNATURE 4500LM/LI-ION CABLU USB

a8.z502191
Livrare 24-48 ore

1.311,53Lei

LEDLENSER KIDLED 4R DINOSAUR 40LM+ACUM

LEDLENSER KIDLED 4R DINOSAUR 40LM+ACUM

a8.z502535
Livrare imediată!

98,26Lei

LANTERNA LEDLENSER P6R CORE QC 270LM/LI-ION +CABLU USB
Exclusiv online!

LANTERNA LEDLENSER P6R CORE QC 270LM/LI-ION +CABLU USB

a8.z502517
Livrare 24-48 ore

458,99Lei

LEDLENSER LANTERNA CAP MH5 BLACK/ORANGE 400LM/ACU.

LEDLENSER LANTERNA CAP MH5 BLACK/ORANGE 400LM/ACU.

a8.z502143
Stoc epuizat

246,00Lei

LEDLENSER MH11 BLACK-ORANGE BLUETOOTH 1000LM+ACUM+USB

LEDLENSER MH11 BLACK-ORANGE BLUETOOTH 1000LM+ACUM+USB

a8.z502166
Stoc epuizat

794,77Lei

LEDLENSER LANTERNA CAP MH3 BLACK/BLUE 200LM

LEDLENSER LANTERNA CAP MH3 BLACK/BLUE 200LM

a8.z502150
Stoc epuizat

170,00Lei

LANTERNA LEDLENSER TFX GACRUX 2500 2500LM

LANTERNA LEDLENSER TFX GACRUX 2500 2500LM

a8.z502556
Stoc epuizat

414,27Lei

LANTERNA LEDLENSER P7R SIGNATURE 2000LM/LI-ION CABLU USB

LANTERNA LEDLENSER P7R SIGNATURE 2000LM/LI-ION CABLU USB

a8.z502190
Stoc epuizat

833,49Lei

Afişare 1 - 20 din 26 (2 pagini)
Queries: 11, Total time: 753.524 ms [By time] [By id] [By file]
1 (0.131)
SELECT data
FROM `oc_session`
WHERE session_id = '5c3235c9674b82c9f23921b258'
/var/www/clients/client1/web1/web/system/library/session/db.php:23
2 (0.110)
SELECT *
FROM oc_platforma_promovari LIMIT 1
/var/www/clients/client1/web1/web/index.php:128
3 (0.102)
SELECT `trigger`, `action`
FROM oc_event
/var/www/clients/client1/web1/web/index.php:422
4 (396.109)
SELECT COUNT(1) AS total
FROM ( SELECT p.product_id, p.sort_order, p.quantity, p.manufacturer_id, "1" AS match_filters
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_description` AS pd ON (pd.product_id = p.product_id)
WHERE p2s.store_id = '0' AND (pd.tag LIKE "%ledlenser%") AND p.status_filtru > 0 AND p.price > 0 GROUP BY p.product_id HAVING match_filters = 1) AS t
/var/www/clients/client1/web1/web/catalog/model/catalog/product.php:1555
5 (353.305)
SELECT p.product_id, p.sort_order, p.quantity, p.manufacturer_id, "1" AS match_filters, pp.sort_order, pp.viewed, IF ((pp.quantity) > 0, 1, 0) AS array_quantity
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_description` AS pd ON (pd.product_id = p.product_id)
INNER JOIN `oc_product` AS pp ON (pp.product_id = p.product_id)
WHERE p2s.store_id = '0' AND (pd.tag LIKE "%ledlenser%") AND p.status_filtru > 0 AND p.price > 0 AND pd.language_id = '2' GROUP BY p.product_id HAVING match_filters = 1
ORDER BY array_quantity DESC, pp.sort_order ASC, pp.viewed DESC, pd.name ASC LIMIT 0, 20
/var/www/clients/client1/web1/web/catalog/model/catalog/product.php:184
6 (1.344)
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_product` AS p ON (m.manufacturer_id = p.manufacturer_id)
INNER JOIN `oc_manufacturer_to_store` AS m2s ON (m.manufacturer_id = m2s.manufacturer_id)
INNER JOIN `oc_product_to_category` AS p2c ON (p.product_id = p2c.product_id)
WHERE p.status = 1 AND m2s.store_id = '0' AND p2c.category_id = '605'
ORDER BY m.sort_order, m.name
/var/www/clients/client1/web1/web/catalog/model/module/brainyfilter.php:1158
7 (0.188)
SELECT MIN(actual_price) AS min, MAX(actual_price) AS max
FROM ( SELECT p.product_id, p.sort_order, p.quantity, p.manufacturer_id, "1" AS match_filters
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)
INNER JOIN `oc_product_description` AS pd ON (pd.product_id = p.product_id)
WHERE p2s.store_id = '0' AND p2c.category_id = '605' AND (pd.tag LIKE "%ledlenser%") AND p.status_filtru > 0 AND p.price > 0 GROUP BY p.product_id HAVING match_filters = 1) AS p
/var/www/clients/client1/web1/web/catalog/model/module/brainyfilter.php:1014
8 (1.918)
SELECT COUNT(*) AS val, filter_group, filter_id
FROM ( SELECT p.product_id, p.sort_order, p.quantity, p.manufacturer_id, "1" AS match_filters
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)
INNER JOIN `oc_product_description` AS pd ON (pd.product_id = p.product_id)
WHERE p2s.store_id = '0' AND p2c.category_id = '605' AND (pd.tag LIKE "%ledlenser%") AND p.status_filtru > 0 AND p.price > 0 GROUP BY p.product_id HAVING match_filters = 1) AS p
INNER JOIN `oc_bf_filter` AS f ON (p.product_id = f.product_id)
WHERE f.language_id = '2' AND f.filter_group NOT LIKE 'a%' GROUP BY filter_group, filter_id
/var/www/clients/client1/web1/web/catalog/model/module/brainyfilter.php:923
9 (0.114)
SELECT *
FROM oc_platforma_promovari
/var/www/clients/client1/web1/web/catalog/model/common/platforma.php:4
10 (0.086)
SELECT *
FROM oc_platforma_promovari
/var/www/clients/client1/web1/web/catalog/model/common/platforma.php:4
11 (0.117)
SELECT *
FROM `oc_mxt_setting`
WHERE store_id = '0' AND name = 'lichidare_stoc'
/var/www/clients/client1/web1/web/catalog/model/catalog/category.php:38