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


Lanseta telescopica Delphin TAIGA NXT 330cm 3.00lbs

Lanseta telescopica Delphin TAIGA NXT 330cm 3.00lbs

101001433
Stoc epuizat

184,00Lei

Lanseta telescopica Delphin TAIGA NXT 300cm 2.75lbs

Lanseta telescopica Delphin TAIGA NXT 300cm 2.75lbs

101001432
Stoc epuizat

170,00Lei

Lanseta Delphin ZEPHYR Spin 2.10M 20g

Lanseta Delphin ZEPHYR Spin 2.10M 20g

110378210
Stoc epuizat

114,50Lei

Lanseta telescopica Delphin ARMORA 3.00M 2.75lbs

Lanseta telescopica Delphin ARMORA 3.00M 2.75lbs

101001435
Stoc epuizat

184,00Lei

Lanseta Delphin WALKYRA 330cm 850g 2seg

Lanseta Delphin WALKYRA 330cm 850g 2seg

101001438
Stoc epuizat

372,40Lei

Lanseta Delphin XERXES TeleFLOAT 390cm 30g 7seg

Lanseta Delphin XERXES TeleFLOAT 390cm 30g 7seg

101001409
Stoc epuizat

159,50Lei

Lanseta Delphin SYMBOL Match 3.90m, 40g, 3seg -30%

Lanseta Delphin SYMBOL Match 3.90m, 40g, 3seg

101001414
Stoc epuizat

238,00Lei(-30%) 166,60Lei

Lanseta telescopica Delphin ARMORA 3.30M 3.00lbs

Lanseta telescopica Delphin ARMORA 3.30M 3.00lbs

101001436
Stoc epuizat

198,00Lei

Lanseta telescopica Delphin TAIGA NXT 360cm 3.00lbs

Lanseta telescopica Delphin TAIGA NXT 360cm 3.00lbs

101001434
Stoc epuizat

191,00Lei

Lanseta Telescopica Delphin Telepikes 7.00M 85g

Lanseta Telescopica Delphin Telepikes 7.00M 85g

101001430
Stoc epuizat

297,90Lei

Lanseta Delphin XERXES TeleFLOAT 360cm 30g

Lanseta Delphin XERXES TeleFLOAT 360cm 30g

101001408
Stoc epuizat

160,30Lei

Lanseta Telescopica Delphin Telepikes 5.00M 85g

Lanseta Telescopica Delphin Telepikes 5.00M 85g

101001429
Stoc epuizat

212,80Lei

Lanseta Delphin XERXES TeleFLOAT 420cm 30g

Lanseta Delphin XERXES TeleFLOAT 420cm 30g

101001410
Stoc epuizat

163,10Lei

Lanseta Delphin XAWER TeleFLOAT 420cm 30g

Lanseta Delphin XAWER TeleFLOAT 420cm 30g

101001413
Stoc epuizat

152,70Lei

Banda Delphin LeadBARRIER 25 x 8cm

Banda Delphin LeadBARRIER 25 x 8cm

101001345
Stoc epuizat

26,00Lei

Lanseta Delphin WALKYRA 260cm 850g 2seg

Lanseta Delphin WALKYRA 260cm 850g 2seg

160914260
Stoc epuizat

352,80Lei

Husa Delphin PORTA Plus 155cm -34%

Husa Delphin PORTA Plus 155cm

101001531
Stoc epuizat

236,00Lei(-34%) 155,00Lei

Husa Delphin AREA DoubleSAFE Carpath 360-3 135cm

Husa Delphin AREA DoubleSAFE Carpath 360-3 135cm

101001525
Stoc epuizat

252,70Lei

Husa Delphin PORTA Plus 200cm -32%

Husa Delphin PORTA Plus 200cm

101001534
Stoc epuizat

272,00Lei(-32%) 185,00Lei

Husa Delphin AREA DoubleSAFE Carpath 360-2 195cm -36%

Husa Delphin AREA DoubleSAFE Carpath 360-2 195cm

101001526
Stoc epuizat

446,00Lei(-36%) 285,01Lei

Afişare 301 - 320 din 372 (19 pagini)
Queries: 11, Total time: 27.775 ms [By time] [By id] [By file]
1 (0.101)
SELECT data
FROM `oc_session`
WHERE session_id = '938d97cdff053467178876407c'
/var/www/clients/client1/web1/web/system/library/session/db.php:23
2 (0.108)
SELECT `trigger`, `action`
FROM oc_event
/var/www/clients/client1/web1/web/index.php:428
3 (0.117)
SELECT *
FROM oc_url_alias
WHERE keyword = 'search'
/var/www/clients/client1/web1/web/catalog/controller/common/seo_url.php:48
4 (17.585)
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('+lansete +delphin' 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.104)
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 (1.577)
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 300, 20
/var/www/clients/client1/web1/web/catalog/model/catalog/product.php:184
7 (0.505)
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.148)
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.205)
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 (7.209)
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.116)
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