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 - Lansete Feeder

Produse ce potrivesc criteriilor de căutare


COADA KAMASAKI MINCIOG SUPER 3 M

COADA KAMASAKI MINCIOG SUPER 3 M

71080300
Livrare imediată!

71,00Lei

VARF KAMASAKI TUBULAR CARBON 1m 3,9/1,6mm
Exclusiv online!

VARF KAMASAKI TUBULAR CARBON 1m 3,9/1,6mm

80126039
Livrare 24-48 ore

73,99Lei

CAP SECERA KAMASAKI

CAP SECERA KAMASAKI

77041230
Livrare imediată!

21,00Lei

KAMASAKI, Cap, Suport, Lansete, 17045, 77041445, Capete Suporti Fata, Capete Suporti Fata Kamasaki, Kamasaki
Lanseta Kamasaki Super Cat 3.00m, 100-300g

Lanseta Kamasaki Super Cat 3.00m, 100-300g

14160300
Livrare imediată!

184,00Lei

Suport, Kamasaki, Lansete, Rabatabil, Feeder, 77041583, Capete Suport Feeder, Capete Suport Feeder Kamasaki, Kamasaki
KAMASAKI, Cap, Suport, Lansete, 17042, 77041552, Capete Suport Feeder, Capete Suport Feeder Kamasaki, Kamasaki
FIR, TEXTIL, KAMASAKI, SUPER, BRAID, 1000M, 0.25MM, 30520925, Fire Textile Rapitori, Fire Textile Rapitori Kamasaki, Kamasaki
FIR Kamasaki Super Xxl 500m

FIR Kamasaki Super Xxl 500m

30009940
Livrare imediată!

19,00Lei

FIR, TEXTIL, KAMASAKI, SUPER, BRAID, 100M, 0,18, MM, 30905018, Fire Textile Rapitori, Fire Textile Rapitori Kamasaki, Kamasaki
VARF KAMASAKI TUBULARFIBRA DE STICLA 1,4m 8,0/2,8mm
Exclusiv online!

VARF KAMASAKI TUBULARFIBRA DE STICLA 1,4m 8,0/2,8mm

80126180
Livrare 24-48 ore

56,00Lei

FIR TEXTIL DYNEEMAX KAMASAKI FORFAC 0.12MM 10M

FIR TEXTIL DYNEEMAX KAMASAKI FORFAC 0.12MM 10M

34020012
Livrare imediată!

9,50Lei

VARF PLIN KAMASAKI FIBRA DE STICLA MULTICOLOR 80cm 6,0/1,0m

VARF PLIN KAMASAKI FIBRA DE STICLA MULTICOLOR 80cm 6,0/1,0m

80126260
Livrare imediată!

24,50Lei

VARF KAMASAKI TUBULAR CARBON 1m 4,7/2,0mm

VARF KAMASAKI TUBULAR CARBON 1m 4,7/2,0mm

80126047
Livrare imediată!

65,00Lei

Set Avertizoare Kamasaki Thunder C3-W AAA 2+1
Exclusiv online!

Set Avertizoare Kamasaki Thunder C3-W AAA 2+1

78007302
Livrare 24-48 ore

307,00Lei

FIR, TEXTIL, KAMASAKI, SUPER, BRAID, 100M, 0,20, MM, 30905020, Fire Textile Rapitori, Fire Textile Rapitori Kamasaki, Kamasaki
Fir Monofilament EnergoTeam Kamasaki Super XXL 04 0.10mm 2000m
Exclusiv online!

Fir Monofilament EnergoTeam Kamasaki Super XXL 04 0.10mm 2000m

30009410
Livrare 24-48 ore

35,00Lei

PLUTA KAMASAKI SUPRAFATA SOMN STUPEK 58 cm Neagra

PLUTA KAMASAKI SUPRAFATA SOMN STUPEK 58 cm Neagra

79310151
Livrare imediată!

39,00Lei

Prastie KAMASAKI Galben

Prastie KAMASAKI Galben

79650960
Livrare imediată!

10,00Lei

Bait, Bander, ENERGOTEAM, KAMASAKI, APLICARE, INEL, SILICONIC, 79015500, Alte Accesorii Monturi, Alte Accesorii Monturi Kamasaki, Alte Kamasaki, Accesorii Kamasaki, Monturi Kamasaki, Kamasaki
Afişare 81 - 100 din 355 (18 pagini)
Queries: 14, Total time: 271.355 ms [By time] [By id] [By file]
1 (0.097)
SELECT data
FROM `oc_session`
WHERE session_id = 'ef337d71212170fef0e35ca279'
/var/www/clients/client1/web1/web/system/library/session/db.php:23
2 (0.090)
SELECT *
FROM oc_platforma_promovari LIMIT 1
/var/www/clients/client1/web1/web/index.php:128
3 (0.091)
SELECT `trigger`, `action`
FROM oc_event
/var/www/clients/client1/web1/web/index.php:422
4 (0.042)
DROP TEMPORARY TABLE IF EXISTS oc_bf_tmp_product
/var/www/clients/client1/web1/web/catalog/model/module/brainyfilter.php:692
5 (260.974)
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` GROUP BY tax_class_id) AS tx ON (p.tax_class_id = tx.tax_class_id)
WHERE p2s.store_id = '0' AND (pd.tag LIKE "%kamasaki%") 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:693
6 (0.184)
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:1547
7 (2.700)
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 80, 20
/var/www/clients/client1/web1/web/catalog/model/catalog/product.php:181
8 (0.539)
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:1204
9 (0.095)
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:1223
10 (0.178)
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:978
11 (6.053)
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:900
12 (0.127)
SELECT *
FROM oc_platforma_promovari
/var/www/clients/client1/web1/web/catalog/model/common/platforma.php:4
13 (0.087)
SELECT *
FROM oc_platforma_promovari
/var/www/clients/client1/web1/web/catalog/model/common/platforma.php:4
14 (0.098)
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