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

Căutare - vu.2.5878

Produse ce potrivesc criteriilor de căutare


INCARCATOR LEDLENSER MAGNETIC TYPE A PENTRU P/H

INCARCATOR LEDLENSER MAGNETIC TYPE A PENTRU P/H

a8.z502265
Livrare imediată!

33,94Lei

Lanterna Led Lenser P2R Core
Exclusiv online!

Lanterna Led Lenser P2R Core

a8.z502176
Livrare 24-48 ore

133,45Lei

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 CAP LED LENSER H5R WORK 500LM+CABLU MAGNETIC
Exclusiv online!

LANTERNA CAP LED LENSER H5R WORK 500LM+CABLU MAGNETIC

a8.z502194
Livrare 24-48 ore

459,24Lei

INCARCATOR LED LENSER DUBLU PENTRU I7R
Exclusiv online!

INCARCATOR LED LENSER DUBLU PENTRU I7R

a8.z0369
Livrare 24-48 ore

149,98Lei

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

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

a8.z502143
Stoc epuizat

246,00Lei

Lanterna cap Led Lenser MH5 400LM

Lanterna cap Led Lenser MH5 400LM

a8.z502144
Stoc epuizat

245,33Lei

LANTERNA LED LENSER P7R CORE

LANTERNA LED LENSER P7R CORE

a8.z502181
Stoc epuizat

569,37Lei

LEDLENSER LANTERNA CAP MH3 BLACK/BLUE 200LM

LEDLENSER LANTERNA CAP MH3 BLACK/BLUE 200LM

a8.z502150
Stoc epuizat

170,00Lei

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

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

a8.z502559
Stoc epuizat

1.135,51Lei

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

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

a8.z502557
Stoc epuizat

689,19Lei

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

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

a8.z502558
Stoc epuizat

887,48Lei

LANTERNA LEDLENSER TFX GACRUX 2500 2500LM

LANTERNA LEDLENSER TFX GACRUX 2500 2500LM

a8.z502556
Stoc epuizat

414,27Lei

LANTERNA TFX PROPUS 1200, 1200 LUMENI LI-ION + CABLU USB

LANTERNA TFX PROPUS 1200, 1200 LUMENI LI-ION + CABLU USB

a8.z502555
Stoc epuizat

445,80Lei

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

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

a8.z502190
Stoc epuizat

833,49Lei

LANTERNA LED LENSER PENTRU COPII GREEN BOX

LANTERNA LED LENSER PENTRU COPII GREEN BOX

a8.z502754
Stoc epuizat

102,60Lei

LANTERNA LED LENSER P18R WORK 4500LM/LI-ION + INCARCATOR

LANTERNA LED LENSER P18R WORK 4500LM/LI-ION + INCARCATOR

a8.z502188
Stoc epuizat

1.313,43Lei

Lantera Led Lenser W5R Work Black 600lm + USB

Lantera Led Lenser W5R Work Black 600lm + USB

a8.z502735
Stoc epuizat

290,48Lei

Set Filtre Lanterna Led Lenser 40mm, Color

Set Filtre Lanterna Led Lenser 40mm, Color

a8.z502308
Stoc epuizat

89,86Lei

Afişare 41 - 60 din 81 (5 pagini)
Queries: 11, Total time: 6.051 ms [By time] [By id] [By file]
1 (0.090)
SELECT data
FROM `oc_session`
WHERE session_id = '4389df80eca42fcd9140fbbcd3'
/var/www/clients/client1/web1/web/system/library/session/db.php:23
2 (0.118)
SELECT `trigger`, `action`
FROM oc_event
/var/www/clients/client1/web1/web/index.php:428
3 (0.135)
SELECT *
FROM oc_url_alias
WHERE keyword = 'search'
/var/www/clients/client1/web1/web/catalog/controller/common/seo_url.php:48
4 (3.666)
CREATE TEMPORARY TABLE oc_bf_tmp_product (PRIMARY KEY (`product_id`), INDEX my_index (match_filters, sort_order, manufacturer_id)) ENGINE=MEMORY 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_description` AS pd ON (pd.product_id = p.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 = '3' AND (MATCH(pd.tag) AGAINST('+lanterne +led +lenser' IN BOOLEAN MODE)) 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:737
5 (0.121)
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:1561
6 (0.534)
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 ASC LIMIT 40, 20
/var/www/clients/client1/web1/web/catalog/model/catalog/product.php:184
7 (0.186)
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:1248
8 (0.078)
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:1270
9 (0.069)
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:1035
10 (0.958)
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:949
11 (0.096)
SELECT *
FROM `oc_mxt_setting`
WHERE store_id = '3' AND name = 'lichidare_stoc'
/var/www/clients/client1/web1/web/catalog/model/catalog/category.php:38