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


Jig VMC Mystic Moon Tail 7158 FT3.5 Nr.2/0, 3.5g, 2buc/pac
Exclusiv online!

Jig VMC Mystic Moon Tail 7158 FT3.5 Nr.2/0, 3.5g, 2buc/pac

7158 ft3,5
Livrare 48-72ore

49,71Lei

Jig VMC Mystic Moon Tail 7158 PFU10.5 Nr.3/0, 10.5g, 2buc/pac
Exclusiv online!

Jig VMC Mystic Moon Tail 7158 PFU10.5 Nr.3/0, 10.5g, 2buc/pac

7158 pfu10,5
Livrare 48-72ore

49,71Lei

Jig VMC Mystic Moon Tail 7158 PFU3.5 Nr.2/0, 3.5g, 2buc/pac
Exclusiv online!

Jig VMC Mystic Moon Tail 7158 PFU3.5 Nr.2/0, 3.5g, 2buc/pac

7158 pfu3,5
Livrare 48-72ore

49,71Lei

Jig VMC Mystic Moon Tail 7158 WHT10.5 Nr.3/0, 10.5g, 2buc/pac
Exclusiv online!

Jig VMC Mystic Moon Tail 7158 WHT10.5 Nr.3/0, 10.5g, 2buc/pac

7158 wht10,5
Livrare 48-72ore

49,71Lei

Jig VMC Mystic Moon Tail 7158 WHT3.5 Nr.2/0, 3.5g, 2buc/pac
Exclusiv online!

Jig VMC Mystic Moon Tail 7158 WHT3.5 Nr.2/0, 3.5g, 2buc/pac

7158 wht3,5
Livrare 48-72ore

49,71Lei

Jig VMC Mystic Moon Tail 7158 WHT7 Nr.2/0, 7g, 2buc/pac
Exclusiv online!

Jig VMC Mystic Moon Tail 7158 WHT7 Nr.2/0, 7g, 2buc/pac

7158 wht7
Livrare 48-72ore

49,71Lei

Vobler FL FL158 Sinking 70mm 9.6g Depth All Round Colour 788

Vobler FL FL158 Sinking 70mm 9.6g Depth All Round Colour 788

fl158-sinking-allround-70mm-9.6g-788
Livrare imediată!

18,39Lei

Vobler FL FL158 Sinking 70mm 9.6g Depth All Round Colour 855

Vobler FL FL158 Sinking 70mm 9.6g Depth All Round Colour 855

fl158-sinking-allround-70mm-9.6g-855
Livrare imediată!

19,40Lei

Vobler FL FL158 Sinking 70mm 9.6g Depth All Round Colour 784

Vobler FL FL158 Sinking 70mm 9.6g Depth All Round Colour 784

fl158-sinking-allround-70mm-9.6g-784
Livrare imediată!

19,40Lei

Vobler FL FL158 Sinking 70mm 9.6g Depth All Round Colour 854

Vobler FL FL158 Sinking 70mm 9.6g Depth All Round Colour 854

fl158-sinking-allround-70mm-9.6g-854
Livrare imediată!

18,39Lei

Vobler FL FL158 Sinking 70mm 9.6g Depth All Round Colour 783

Vobler FL FL158 Sinking 70mm 9.6g Depth All Round Colour 783

fl158-sinking-allround-70mm-9.6g-783
Livrare imediată!

18,39Lei

Shad Savage Gear Cannibal, Flou Yellow Glow, 12.5cm, 20g, 4buc/pac
Exclusiv online!

Shad Savage Gear Cannibal, Flou Yellow Glow, 12.5cm, 20g, 4buc/pac

f1.sg.77158
Livrare 24-48 ore

25,82Lei

Carlige HAYABUSA BEK 562BN Nr.2/0, 6buc/pac
Exclusiv online!

Carlige HAYABUSA BEK 562BN Nr.2/0, 6buc/pac

7158
Livrare 48-72 ore

11,07Lei

Hanorac Trakker CR Logo Hoody, Kaki, Marime 2XL -13%

Hanorac Trakker CR Logo Hoody, Kaki, Marime 2XL

207158
Livrare imediată!

234,95Lei(-13%) 204,07Lei

Pelete WLC Krill X 6mm 800g

Pelete WLC Krill X 6mm 800g

w1156
Livrare imediată!

23,40Lei

SCAUN KORUM AERONIUM SUPA LITE CHAIR V2 47X58/70-80CM

SCAUN KORUM AERONIUM SUPA LITE CHAIR V2 47X58/70-80CM

k0300005
Livrare imediată!

618,67Lei

PLUMB PROLOGIC FLYING BACK 14G 2BUC/PL -39%
Exclusiv online!

PLUMB PROLOGIC FLYING BACK 14G 2BUC/PL

a3.pro.57138
Livrare 24-48 ore

18,59Lei(-39%) 11,36Lei

Carlige Trakker Choddy Hooks Barbless, Nr.8, 10buc/pac
Exclusiv online!

Carlige Trakker Choddy Hooks Barbless, Nr.8, 10buc/pac

227158
Livrare 7-14 zile

27,89Lei

BUZZ BAR PROLOGIC K1 2 POSTURI, 20CM -21%

BUZZ BAR PROLOGIC K1 2 POSTURI, 20CM

a6.pro.57150
Livrare imediată!

76,64Lei(-21%) 60,89Lei

Lanseta Prologic C1 Alpha 3.00m 3.00lbs 2 tronsoane

Lanseta Prologic C1 Alpha 3.00m 3.00lbs 2 tronsoane

o.pro.57185
Livrare imediată!

264,05Lei

Afişare 1 - 20 din 73 (4 pagini)
Queries: 17, Total time: 3.532 ms [By time] [By id] [By file]
1 (0.103)
SELECT data
FROM `oc_session`
WHERE session_id = 'ad58316de0b35e4850e2582c5f'
/var/www/clients/client1/web1/web/system/library/session/db.php:24
2 (0.124)
SELECT `trigger`, `action`
FROM oc_event
/var/www/clients/client1/web1/web/index.php:453
3 (0.134)
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.215)
INSERT INTO oc_bf_tmp_product (product_id, sort_order, quantity, manufacturer_id, match_filters, actual_price, sort) VALUES ("131039", "2", "1000", "206", "1", "41.080000000000", "1"),("131043", "2", "1000", "206", "1", "41.080000000000", "2"),("131045", "2", "1000", "206", "1", "41.080000000000", "3"),("131049", "2", "1000", "206", "1", "41.080000000000", "4"),("131051", "2", "1000", "206", "1", "41.080000000000", "5"),("131053", "2", "1000", "206", "1", "41.080000000000", "6"),("118199", "1", "1008", "13", "1", "15.200000000000", "7"),("118201", "1", "1008", "13", "1", "16.030000000000", "8"),("118198", "1", "1005", "13", "1", "16.030000000000", "9"),("118200", "1", "1004", "13", "1", "15.200000000000", "10"),("118197", "1", "1002", "13", "1", "15.200000000000", "11"),("172483", "1", "1000", "85", "1", "21.340000000000", "12"),("10955", "2", "1000", "68", "1", "9.150000000000", "13"),("205967", "1", "1002", "476", "1", "168.650000000000", "14"),("155423", "1", "5", "200", "1", "21.080000000000", "15"),("150875", "1", "3", "357", "1", "511.300000000000", "16"),("68103", "2", "1000", "47", "1", "9.390000000000", "17"),("209025", "1", "1000", "476", "1", "23.050000000000", "18"),("63886", "2", "1", "47", "1", "50.320000000000", "19"),("67525", "2", "1", "47", "1", "218.220000000000", "20"),("118686", "2", "1", "62", "1", "296.520000000000", "21"),("237448", "1", "1025", "13", "1", "20.910000000000", "22"),("222866", "1", "1085", "13", "1", "13.430000000000", "23"),("115106", "1", "1000", "85", "1", "33.790000000000", "24"),("143121", "10", "1000", "85", "1", "112.950000000000", "25"),("143125", "10", "1000", "85", "1", "112.950000000000", "26"),("143127", "10", "1000", "85", "1", "112.950000000000", "27"),("203045", "1", "3", "76", "1", "28.770000000000", "28"),("172479", "1", "1000", "85", "1", "21.340000000000", "29"),("35255", "2", "1005", "68", "1", "6.450000000000", "30"),("226206", "1", "1000", "370", "1", "168.100000000000", "31"),("172470", "1", "1000", "85", "1", "19.680000000000", "32"),("172494", "1", "1000", "85", "1", "19.680000000000", "33"),("172501", "1", "1000", "85", "1", "21.340000000000", "34"),("172538", "1", "1000", "85", "1", "19.680000000000", "35"),("210397", "1", "1052", "13", "1", "13.430000000000", "36"),("172482", "1", "1000", "85", "1", "19.650000000000", "37"),("172484", "1", "1000", "85", "1", "14.760000000000", "38"),("172487", "1", "1000", "85", "1", "19.680000000000", "39"),("172518", "1", "1000", "85", "1", "19.680000000000", "40"),("172526", "1", "1000", "85", "1", "21.340000000000", "41"),("172533", "1", "1000", "85", "1", "19.650000000000", "42"),("223641", "1", "1000", "296", "1", "37.800000000000", "43"),("223642", "1", "1000", "296", "1", "37.800000000000", "44"),("223643", "1", "1000", "296", "1", "37.800000000000", "45"),("223644", "1", "1000", "296", "1", "37.800000000000", "46"),("223645", "1", "1000", "296", "1", "37.800000000000", "47"),("223646", "1", "1000", "296", "1", "37.800000000000", "48"),("223648", "1", "1000", "296", "1", "37.800000000000", "49"),("103760", "2", "1000", "492", "1", "72.560000000000", "50"),("227294", "2", "1000", "528", "1", "7.380000000000", "51"),("211481", "2", "1000", "370", "1", "8.180000000000", "52"),("235648", "2", "1000", "370", "1", "13.940000000000", "53"),("43859", "2", "1003", "45", "1", "4.270000000000", "54"),("209191", "1", "1000", "370", "1", "402.480000000000", "55"),("239500", "1", "9", "767", "1", "147.800000000000", "56"),("222385", "1", "1009", "96", "1", "7.300000000000", "57"),("147299", "1", "999", "13", "1", "11.670000000000", "58"),("247819", "1", "1000", "370", "1", "9.290000000000", "59"),("131037", "2", "0", "206", "1", "30.000000000000", "60"),("131041", "2", "0", "206", "1", "30.000000000000", "61"),("131047", "2", "0", "206", "1", "30.000000000000", "62"),("110252", "10", "0", "85", "1", "68.860000000000", "63"),("234117", "2", "0", "59", "1", "25.190000000000", "64"),("238527", "1", "0", "59", "1", "101.660000000000", "65"),("68285", "2", "0", "47", "1", "46.090000000000", "66"),("110177", "10", "0", "85", "1", "52.700000000000", "67"),("48609", "2", "0", "159", "1", "63.000000000000", "68"),("67978", "2", "0", "85", "1", "27.850000000000", "69"),("37969", "2", "0", "156", "1", "51.320000000000", "70"),("172485", "1", "0", "85", "1", "13.220000000000", "71"),("223647", "1", "0", "296", "1", "37.800000000000", "72"),("223649", "1", "0", "296", "1", "37.800000000000", "73")
/var/www/clients/client1/web1/web/catalog/model/module/brainyfilter.php:846
5 (0.094)
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.170)
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.125)
SELECT *
FROM oc_stock_status
WHERE furnizor LIKE '%"RAPALA VMC ROMANIA SRL"%' AND language_id = '2'
/var/www/clients/client1/web1/web/catalog/model/catalog/product.php:130
8 (0.078)
SELECT *
FROM oc_stock_status
WHERE furnizor LIKE '%"RAPALA VMC ROMANIA SRL"%' AND language_id = '2'
/var/www/clients/client1/web1/web/catalog/model/catalog/product.php:130
9 (0.073)
SELECT *
FROM oc_stock_status
WHERE furnizor LIKE '%"RAPALA VMC ROMANIA SRL"%' AND language_id = '2'
/var/www/clients/client1/web1/web/catalog/model/catalog/product.php:130
10 (0.069)
SELECT *
FROM oc_stock_status
WHERE furnizor LIKE '%"RAPALA VMC ROMANIA SRL"%' AND language_id = '2'
/var/www/clients/client1/web1/web/catalog/model/catalog/product.php:130
11 (0.070)
SELECT *
FROM oc_stock_status
WHERE furnizor LIKE '%"RAPALA VMC ROMANIA SRL"%' AND language_id = '2'
/var/www/clients/client1/web1/web/catalog/model/catalog/product.php:130
12 (0.070)
SELECT *
FROM oc_stock_status
WHERE furnizor LIKE '%"RAPALA VMC ROMANIA SRL"%' AND language_id = '2'
/var/www/clients/client1/web1/web/catalog/model/catalog/product.php:130
13 (0.338)
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
14 (0.096)
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
15 (0.094)
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
16 (1.555)
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
17 (0.123)
SELECT *
FROM `oc_mxt_setting`
WHERE store_id = '0' AND name = 'lichidare_stoc'
/var/www/clients/client1/web1/web/catalog/model/catalog/category.php:37