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

Produse ce potrivesc criteriilor de căutare


Manusa NASH Casting Glove Dreapta

Manusa NASH Casting Glove Dreapta

c0311
Livrare imediată!

58,99Lei

Manusa De Protectie Gamakatsu Dreapta XXL

Manusa De Protectie Gamakatsu Dreapta XXL

a.gk7103.300
Livrare imediată!

69,23Lei

DEGETAR GAMAKATSU MANA DREAPTA MASURA 3XL
Exclusiv online!

DEGETAR GAMAKATSU MANA DREAPTA MASURA 3XL

a.gk7103.400
Livrare 24-48 ore

69,23Lei

Manusa De Protectie Gamakatsu Dreapta Marime L

Manusa De Protectie Gamakatsu Dreapta Marime L

a.gk7103.100
Livrare imediată!

69,23Lei

Manusa de Protectie Gamakatsu Dreapta, Marime XL

Manusa de Protectie Gamakatsu Dreapta, Marime XL

a.gk7103.200
Livrare imediată!

69,23Lei

Manusa Pentru Recuperat Pestele - Dreapta
Exclusiv online!

Manusa Pentru Recuperat Pestele - Dreapta

umr-10-r
Livrare 48-72 ore

79,00Lei

Degetar Manusa Claumar Mana Dreapta Marime Universala

Degetar Manusa Claumar Mana Dreapta Marime Universala

clm239365
Livrare imediată!

22,90Lei

Mulineta Zeck VR 5 Manivela Dreapta

Mulineta Zeck VR 5 Manivela Dreapta

30805100006
Livrare imediată!

1.274,50Lei

Penseta Nevis 15cm Dreapta

Penseta Nevis 15cm Dreapta

8100-001
Livrare imediată!

20,50Lei

Penseta Nevis 18cm Dreapta

Penseta Nevis 18cm Dreapta

8100-003
Livrare imediată!

26,91Lei

Penseta Nevis 20cm Dreapta
Exclusiv online!

Penseta Nevis 20cm Dreapta

8100-005
Livrare 48-72 ore

29,90Lei

Pensa Dreapta DAM 12.50cm -40%
Exclusiv online!

Pensa Dreapta DAM 12.50cm

a.dam.15236
Livrare 24-48 ore

34,51Lei(-40%) 20,71Lei

Pensa Lunga Dreapta EnergoTeam 25cm

Pensa Lunga Dreapta EnergoTeam 25cm

79590025
Livrare imediată!

36,00Lei

PENSA DAIWA PROREX DREAPTA 28CM

PENSA DAIWA PROREX DREAPTA 28CM

a.15409.010
Livrare imediată!

62,31Lei

PENSA DREAPTA FOARFECA CORMORAN 18 CM

PENSA DREAPTA FOARFECA CORMORAN 18 CM

a.84.10018
Livrare imediată!

32,09Lei

Pensa Dreapta Foarfeca Zfish Plier straight, 15cm, Argintie
Exclusiv online!

Pensa Dreapta Foarfeca Zfish Plier straight, 15cm, Argintie

zf-1569
Livrare 48-72ore

21,73Lei

Unghiera Lama Dreapta Owner FT-12 Line Cutter Straight
Exclusiv online!

Unghiera Lama Dreapta Owner FT-12 Line Cutter Straight

6010289615-ft-12
Livrare 48-72 ore

45,29Lei

Pensa Dreapta tip Foarfeca Fox Rage, 24cm
Exclusiv online!

Pensa Dreapta tip Foarfeca Fox Rage, 24cm

ntl037
Livrare 7-14 zile

80,96Lei

Pensa Dreapta Foarfeca Zfish Plier straight, 10cm, Argintie
Exclusiv online!

Pensa Dreapta Foarfeca Zfish Plier straight, 10cm, Argintie

zf-1568
Livrare 48-72ore

19,72Lei

Degetar Claumar Mana Stanga Dreapta Marime Universala -49%

Degetar Claumar Mana Stanga Dreapta Marime Universala

clm239372
Stoc epuizat

25,89Lei(-49%) 13,27Lei

Afişare 1 - 20 din 30 (2 pagini)
Queries: 14, Total time: 1.989 ms [By time] [By id] [By file]
1 (0.129)
SELECT data
FROM `oc_session`
WHERE session_id = 'f0e3bc42f86cf96925efe7d1c8'
/var/www/clients/client1/web1/web/system/library/session/db.php:24
2 (0.112)
SELECT `trigger`, `action`
FROM oc_event
/var/www/clients/client1/web1/web/index.php:453
3 (0.090)
CREATE TEMPORARY TABLE oc_bf_tmp_product ( product_id int PRIMARY KEY, sort_order int, quantity int, manufacturer_id int, match_filters int, actual_price DECIMAL(10, 4), sort int, INDEX my_index (match_filters, sort_order, manufacturer_id) ) ENGINE=MEMORY
/var/www/clients/client1/web1/web/catalog/model/module/brainyfilter.php:837
4 (0.108)
INSERT INTO oc_bf_tmp_product (product_id, sort_order, quantity, manufacturer_id, match_filters, actual_price, sort) VALUES ("149209", "1", "3", "59", "1", "49.570000000000", "1"),("2146", "2", "1002", "19", "1", "58.180000000000", "2"),("22070", "2", "1000", "19", "1", "58.180000000000", "3"),("2142", "2", "1006", "19", "1", "58.180000000000", "4"),("2143", "2", "1003", "19", "1", "58.180000000000", "5"),("213345", "1", "1000", "224", "1", "66.390000000000", "6"),("100786", "-100", "41", "26", "1", "19.240000000000", "7"),("199863", "1", "1", "656", "1", "1071.010000000000", "8"),("89630", "2", "1001", "423", "1", "17.230000000000", "9"),("89631", "2", "1001", "423", "1", "22.610000000000", "10"),("89632", "2", "1000", "423", "1", "25.130000000000", "11"),("175492", "2", "1000", "124", "1", "17.400000000000", "12"),("11996", "2", "3", "24", "1", "30.250000000000", "13"),("48492", "2", "1", "11", "1", "52.360000000000", "14"),("65647", "2", "1004", "12", "1", "26.970000000000", "15"),("222652", "1", "1000", "370", "1", "18.260000000000", "16"),("165200", "2", "1000", "15", "1", "38.060000000000", "17"),("164976", "2", "1000", "455", "1", "68.030000000000", "18"),("222651", "1", "1000", "370", "1", "16.570000000000", "19"),("100787", "-100", "0", "26", "1", "11.150000000000", "20"),("243487", "2", "0", "362", "1", "23.530000000000", "21"),("142331", "2", "0", "332", "1", "240.340000000000", "22"),("70080", "2", "1000", "24", "1", "16.810000000000", "23"),("72076", "2", "1000", "27", "1", "5.040000000000", "24"),("106207", "1", "1002", "423", "1", "34.450000000000", "25"),("12676", "2", "1000", "58", "1", "31.930000000000", "26"),("153573", "1", "0", "124", "1", "22.350000000000", "27"),("72150", "4", "0", "24", "1", "34.000000000000", "28"),("168172", "2", "0", "603", "1", "69.000000000000", "29"),("62630", "2", "0", "27", "1", "57.140000000000", "30")
/var/www/clients/client1/web1/web/catalog/model/module/brainyfilter.php:846
5 (0.079)
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:1593
6 (0.173)
SELECT p.*
FROM `oc_bf_tmp_product` AS p
INNER JOIN `oc_product_description` AS pd ON (pd.product_id = p.product_id)
WHERE match_filters = 1 AND pd.language_id = '2' LIMIT 0, 20
/var/www/clients/client1/web1/web/catalog/model/catalog/product.php:184
7 (0.095)
SELECT *
FROM oc_stock_status
WHERE furnizor LIKE '%"ZFISHING SPORT WHOLESALE S.R.O"%' AND language_id = '2'
/var/www/clients/client1/web1/web/catalog/model/catalog/product.php:130
8 (0.121)
SELECT *
FROM oc_stock_status
WHERE furnizor LIKE '%"ZFISHING SPORT WHOLESALE S.R.O"%' AND language_id = '2'
/var/www/clients/client1/web1/web/catalog/model/catalog/product.php:130
9 (0.120)
SELECT *
FROM oc_stock_status
WHERE furnizor LIKE '%"CLAUMAR FISH ACCESORII"%' AND language_id = '2'
/var/www/clients/client1/web1/web/catalog/model/catalog/product.php:130
10 (0.221)
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:1393
11 (0.111)
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:1415
12 (0.101)
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:1180
13 (0.409)
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:1094
14 (0.120)
SELECT *
FROM `oc_mxt_setting`
WHERE store_id = '3' AND name = 'lichidare_stoc'
/var/www/clients/client1/web1/web/catalog/model/catalog/category.php:37