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


Starlet Black Cat Light Depot 45mm
Exclusiv online!

Starlet Black Cat Light Depot 45mm

5545001
Livrare 7-14 zile

48,15Lei

Inel Despicat Black Cat Xtreme Split Ring 12mm
Exclusiv online!

Inel Despicat Black Cat Xtreme Split Ring 12mm

6157010
Livrare 7-14 zile

17,78Lei

Ceas GARMIN Instinct 3 Solar Black Curea Black 45mm

Ceas GARMIN Instinct 3 Solar Black Curea Black 45mm

hg.010.02934.00
Livrare imediată!

1.989,00Lei

Agrafa Vartej Black Cat Godzilla Swivel No.3/0 62mm
Exclusiv online!

Agrafa Vartej Black Cat Godzilla Swivel No.3/0 62mm

6156300
Livrare 7-14 zile

35,78Lei

Naluca - M-Area Maggot- 42Mm/Black - 10Buc
Exclusiv online!

Naluca - M-Area Maggot- 42Mm/Black - 10Buc

pmma-42-bk
Livrare 48-72 ore

29,00Lei

Varnis Siliconic Black Cat Rig Tube, Khaki, 2-4mm, 1m -19%
Exclusiv online!

Varnis Siliconic Black Cat Rig Tube, Khaki, 2-4mm, 1m

6611269
Livrare 7-14 zile

27,00Lei(-19%) 21,80Lei

Varnis Siliconic Black Cat Rig Tube, Red, 2-4mm, 1m -19%
Exclusiv online!

Varnis Siliconic Black Cat Rig Tube, Red, 2-4mm, 1m

6611169
Livrare 7-14 zile

27,00Lei(-19%) 21,80Lei

Tub Cauciuc Black Cat Rig Tube 2-4mm 1m Yellow

Tub Cauciuc Black Cat Rig Tube 2-4mm 1m Yellow

6611069
Livrare imediată!

21,21Lei

Oscilanta DAM Effzett Standard Holo Black 6gr 32mm -25%

Oscilanta DAM Effzett Standard Holo Black 6gr 32mm

13042969588
Livrare imediată!

15,09Lei(-25%) 11,34Lei

Fir textil Black Cat S-Line 0.42mm 45kg 250m

Fir textil Black Cat S-Line 0.42mm 45kg 250m

2352042
Livrare imediată!

103,85Lei

Fir textil Black Cat Front Zone Leader, 1.2mm, 135kg, 45m

Fir textil Black Cat Front Zone Leader, 1.2mm, 135kg, 45m

2365120
Livrare imediată!

159,70Lei

Oscilanta DAM Effzett Standard Black Orange UV 6gr 32mm
Exclusiv online!

Oscilanta DAM Effzett Standard Black Orange UV 6gr 32mm

13042969590
Livrare 48-72 ore

15,09Lei

Oscilanta DAM Effzett Standard Green Black UV 6gr 32mm
Exclusiv online!

Oscilanta DAM Effzett Standard Green Black UV 6gr 32mm

13042969592
Livrare 48-72 ore

14,68Lei

Oscilanta DAM Effzett Standard Black Orange UV 16gr 45mm
Exclusiv online!

Oscilanta DAM Effzett Standard Black Orange UV 16gr 45mm

13042969596
Livrare 48-72 ore

17,03Lei

Oscilanta DAM Effzett Standard Green Black UV 16gr 45mm
Exclusiv online!

Oscilanta DAM Effzett Standard Green Black UV 16gr 45mm

13042969598
Livrare 48-72 ore

16,62Lei

Suport Ponton Trakker Stage Stand, 12mm, Black
Exclusiv online!

Suport Ponton Trakker Stage Stand, 12mm, Black

222920
Livrare 7-14 zile

82,46Lei

Clonc DAM Madcat Klong Black Pastila 45mm

Clonc DAM Madcat Klong Black Pastila 45mm

svs8421002
Livrare imediată!

105,01Lei

Stoper Black Cat Rubber Shock Bead 10mm

Stoper Black Cat Rubber Shock Bead 10mm

6611050
Livrare imediată!

8,88Lei

Tija Cupru pt.Monturi Somn Black Cat Baiting Wire 1.0mm 120mm
Exclusiv online!

Tija Cupru pt.Monturi Somn Black Cat Baiting Wire 1.0mm 120mm

403226152000
Livrare 48-72 ore

11,98Lei

Pelete iBaits Black Halibut, 4mm, 800g

Pelete iBaits Black Halibut, 4mm, 800g

5941944352068
Livrare imediată!

29,00Lei

Afişare 1 - 20 din 65 (4 pagini)
Queries: 11, Total time: 2.875 ms [By time] [By id] [By file]
1 (0.165)
SELECT data
FROM `oc_session`
WHERE session_id = 'ad18202ca8c6547d5b87ec5767'
/var/www/clients/client1/web1/web/system/library/session/db.php:24
2 (0.129)
SELECT `trigger`, `action`
FROM oc_event
/var/www/clients/client1/web1/web/index.php:453
3 (0.130)
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.202)
INSERT INTO oc_bf_tmp_product (product_id, sort_order, quantity, manufacturer_id, match_filters, actual_price, sort) VALUES ("102677", "2", "1000", "294", "1", "40.460000000000", "1"),("56192", "2", "1000", "294", "1", "14.940000000000", "2"),("237533", "10", "1001", "315", "1", "1671.430000000000", "3"),("115761", "1", "1000", "294", "1", "30.070000000000", "4"),("210671", "1", "1000", "224", "1", "24.370000000000", "5"),("231529", "1", "1000", "294", "1", "18.320000000000", "6"),("231530", "1", "1000", "294", "1", "18.320000000000", "7"),("102656", "2", "1007", "294", "1", "17.820000000000", "8"),("103367", "2", "1", "124", "1", "9.530000000000", "9"),("115872", "2", "1001", "294", "1", "87.270000000000", "10"),("167195", "2", "1003", "294", "1", "134.200000000000", "11"),("103369", "2", "1000", "124", "1", "12.680000000000", "12"),("103371", "2", "1000", "124", "1", "12.340000000000", "13"),("103375", "2", "1000", "124", "1", "14.310000000000", "14"),("103377", "2", "1000", "124", "1", "13.970000000000", "15"),("210235", "2", "1000", "476", "1", "69.290000000000", "16"),("175204", "2", "1", "124", "1", "88.240000000000", "17"),("102653", "2", "1010", "294", "1", "7.460000000000", "18"),("70325", "2", "1000", "294", "1", "10.070000000000", "19"),("237544", "1", "1015", "573", "1", "34.060800000000", "20"),("116661", "1", "6", "565", "1", "30.528000000000", "21"),("100298", "1", "2", "28", "1", "29.363200000000", "22"),("179448", "1", "1000", "603", "1", "68.910000000000", "23"),("210237", "2", "1000", "476", "1", "69.290000000000", "24"),("219115", "2", "1000", "292", "1", "65.766400000000", "25"),("164603", "1", "1054", "402", "1", "5.880000000000", "26"),("100304", "1", "9", "28", "1", "28.185600000000", "27"),("64648", "2", "2", "100", "1", "28.185600000000", "28"),("200977", "2", "1000", "224", "1", "29.410000000000", "29"),("243311", "10", "1000", "315", "1", "2083.190000000000", "30"),("114810", "1", "1004", "402", "1", "5.460000000000", "31"),("187827", "1", "1027", "52", "1", "17.160000000000", "32"),("213585", "1", "1001", "224", "1", "15.130000000000", "33"),("218960", "2", "1000", "292", "1", "39.923200000000", "34"),("216545", "1", "1001", "292", "1", "39.923200000000", "35"),("70914", "2", "1000", "123", "1", "40.490000000000", "36"),("242031", "2", "1000", "725", "1", "128.240000000000", "37"),("179444", "1", "1000", "603", "1", "68.910000000000", "38"),("199567", "1", "1000", "58", "1", "116.810000000000", "39"),("5487", "2", "5", "103", "1", "12.020000000000", "40"),("5486", "2", "4", "103", "1", "12.020000000000", "41"),("168370", "1", "1000", "58", "1", "108.400000000000", "42"),("168372", "1", "1000", "58", "1", "108.400000000000", "43"),("201347", "1", "1003", "224", "1", "21.010000000000", "44"),("48863", "2", "5", "85", "1", "13.450000000000", "45"),("236429", "1", "3", "769", "1", "63.296000000000", "46"),("242954", "1", "1000", "75", "1", "36.970000000000", "47"),("170109", "2", "6", "69", "1", "25.830400000000", "48"),("177121", "2", "2", "659", "1", "15.970000000000", "49"),("207093", "2", "1000", "224", "1", "73.950000000000", "50"),("185561", "1", "1000", "543", "1", "37.780000000000", "51"),("207087", "2", "1000", "224", "1", "73.950000000000", "52"),("207095", "2", "1000", "224", "1", "73.950000000000", "53"),("123459", "1", "1008", "423", "1", "4.790000000000", "54"),("146037", "10", "0", "315", "1", "2912.240000000000", "55"),("231624", "10", "0", "315", "1", "4578.990000000000", "56"),("103373", "2", "0", "124", "1", "10.160000000000", "57"),("146009", "10", "0", "315", "1", "2170.649900000000", "58"),("146011", "10", "0", "315", "1", "2912.240000000000", "59"),("110465", "2", "0", "162", "1", "50.828800000000", "60"),("206063", "2", "0", "224", "1", "13.530000000000", "61"),("229090", "10", "0", "315", "1", "3981.730000000000", "62"),("234197", "1", "0", "59", "1", "19.320000000000", "63"),("103391", "1", "0", "354", "1", "46.131200000000", "64"),("199569", "1", "0", "58", "1", "116.810000000000", "65")
/var/www/clients/client1/web1/web/catalog/model/module/brainyfilter.php:846
5 (0.123)
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.191)
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.424)
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
8 (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
9 (0.093)
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
10 (1.199)
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
11 (0.108)
SELECT *
FROM `oc_mxt_setting`
WHERE store_id = '2' AND name = 'lichidare_stoc'
/var/www/clients/client1/web1/web/catalog/model/catalog/category.php:37