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


Fir Textil Konger Kevlon X4 Black 0.16mm, 15.9kg, 150m
Exclusiv online!

Fir Textil Konger Kevlon X4 Black 0.16mm, 15.9kg, 150m

110606250151016
Livrare 48-72 ore

47,72Lei

Fir Textil Konger Kevlon X4 Black 0.20mm, 22.3kg, 150m
Exclusiv online!

Fir Textil Konger Kevlon X4 Black 0.20mm, 22.3kg, 150m

110606250151020
Livrare 48-72 ore

47,72Lei

Fir Textil Konger Kevlon X4 Orange Fluo 0.18mm, 17.3kg, 150m
Exclusiv online!

Fir Textil Konger Kevlon X4 Orange Fluo 0.18mm, 17.3kg, 150m

110606250153018
Livrare 48-72 ore

52,53Lei

Fir Textil Konger Rigging Line Kevlon X4 Black 0.16mm, 15.9kg, 10m

Fir Textil Konger Rigging Line Kevlon X4 Black 0.16mm, 15.9kg, 10m

110806250014016
Livrare imediată!

7,39Lei

Fir Textil Konger Rigging Line Kevlon X4 Black 0.20mm, 22.3kg, 10m
Exclusiv online!

Fir Textil Konger Rigging Line Kevlon X4 Black 0.20mm, 22.3kg, 10m

110806250014020
Livrare 48-72 ore

7,39Lei

Lip Grip Konger Cu Cantar Si Metru, 22kg, 28cm
Exclusiv online!

Lip Grip Konger Cu Cantar Si Metru, 22kg, 28cm

43006989100009
Livrare 48-72 ore

106,22Lei

Montura Somn Konger Dread Cat Carlig Rattle Snake 80cm, 36.3kg, Nr.4/0, 1buc/pac
Exclusiv online!

Montura Somn Konger Dread Cat Carlig Rattle Snake 80cm, 36.3kg, Nr.4/0, 1buc/pac

120406865100001
Livrare 48-72 ore

38,31Lei

Penar Riguri Konger Lux Leader Rig Wallet, 26x13cm
Exclusiv online!

Penar Riguri Konger Lux Leader Rig Wallet, 26x13cm

90406970006018
Livrare 48-72 ore

85,14Lei

Spinnertail Konger Boogie, 004 Fire Tiger, 4g

Spinnertail Konger Boogie, 004 Fire Tiger, 4g

131606381100004
Stoc epuizat

27,41Lei

Carlige Somn Konger Dread Cat Power Game Black Nickel Nr.10/0, 3buc/plic

Carlige Somn Konger Dread Cat Power Game Black Nickel Nr.10/0, 3buc/plic

121006865000019
Stoc epuizat

18,23Lei

Carlige Konger Carplabs Curve Shank Barbless Titanium Grey Ringed Nr.8, 6buc/plic

Carlige Konger Carplabs Curve Shank Barbless Titanium Grey Ringed Nr.8, 6buc/plic

120506765116908
Stoc epuizat

10,31Lei

Carlige Konger Carplabs Specimen Titanium Grey Ringed Nr.4, 6buc/plic

Carlige Konger Carplabs Specimen Titanium Grey Ringed Nr.4, 6buc/plic

120506765104904
Stoc epuizat

7,14Lei

Lanseta Konger Endura Feeder 3.90m, 150g, 3+3seg

Lanseta Konger Endura Feeder 3.90m, 150g, 3+3seg

20506154007390
Stoc epuizat

329,74Lei

Carlige Konger Carplabs Short Shank Titanium Grey Ringed Nr.4, 6buc/plic

Carlige Konger Carplabs Short Shank Titanium Grey Ringed Nr.4, 6buc/plic

120506765102904
Stoc epuizat

10,31Lei

Lanseta Konger Dynamix Jig L2322, 2.32m, 3-14g, 2seg

Lanseta Konger Dynamix Jig L2322, 2.32m, 3-14g, 2seg

20406155004232
Stoc epuizat

248,58Lei

Carlige Konger Carplabs Curve Shank Barbless Titanium Grey Ringed Nr.6, 6buc/plic

Carlige Konger Carplabs Curve Shank Barbless Titanium Grey Ringed Nr.6, 6buc/plic

120506765116906
Stoc epuizat

10,31Lei

Carlige Konger Carplabs Short Shank Titanium Grey Ringed Nr.6, 6buc/plic

Carlige Konger Carplabs Short Shank Titanium Grey Ringed Nr.6, 6buc/plic

120506765102906
Stoc epuizat

10,31Lei

Carlige Konger Carplabs Method Feeder Barbless Titanium Grey Ringed Nr.16, 6buc/pac
Carlige Konger Carplabs Specimen Titanium Grey Ringed Nr.8, 6buc/plic

Carlige Konger Carplabs Specimen Titanium Grey Ringed Nr.8, 6buc/plic

120506765104908
Stoc epuizat

7,14Lei

Conector Konger Carplabs Multi Bead 10buc/plic

Conector Konger Carplabs Multi Bead 10buc/plic

41606765000074
Stoc epuizat

10,31Lei

Afişare 341 - 360 din 413 (21 pagini)
Queries: 12, Total time: 15.104 ms [By time] [By id] [By file]
1 (0.171)
SELECT data
FROM `oc_session`
WHERE session_id = '9e35581596a3769d6df9701e25'
/var/www/clients/client1/web1/web/system/library/session/db.php:23
2 (0.127)
SELECT `trigger`, `action`
FROM oc_event
/var/www/clients/client1/web1/web/index.php:428
3 (8.191)
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 = '2' AND (MATCH(pd.tag) AGAINST('+konger' 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
4 (0.189)
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
5 (1.662)
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 340, 20
/var/www/clients/client1/web1/web/catalog/model/catalog/product.php:184
6 (0.128)
SELECT *
FROM oc_stock_status
WHERE furnizor LIKE '%"PRODUSE INACTIVE"%' AND language_id = '2'
/var/www/clients/client1/web1/web/catalog/model/catalog/product.php:130
7 (0.116)
SELECT *
FROM oc_stock_status
WHERE furnizor LIKE '%"PRODUSE INACTIVE"%' AND language_id = '2'
/var/www/clients/client1/web1/web/catalog/model/catalog/product.php:130
8 (0.347)
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
9 (0.107)
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
10 (0.152)
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
11 (3.802)
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
12 (0.112)
SELECT *
FROM `oc_mxt_setting`
WHERE store_id = '2' AND name = 'lichidare_stoc'
/var/www/clients/client1/web1/web/catalog/model/catalog/category.php:38