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


Cutie magnetica Stonfo 150x100x14mm
Exclusiv online!

Cutie magnetica Stonfo 150x100x14mm

248
Livrare 48-72 ore

65,00Lei

Husa Magnetica Shimano Sync Small Magnetic Pouch

Husa Magnetica Shimano Sync Small Magnetic Pouch

shtsc31
Livrare imediată!

9,90Lei

Cutie Accesorii Mikado Magnetica Dubla, 14.5x10.5x2cm

Cutie Accesorii Mikado Magnetica Dubla, 14.5x10.5x2cm

uabm-036
Livrare imediată!

28,00Lei

Bara Magnetica Pentru Cutite Victorinox, 35 cm, Negru
Exclusiv online!

Bara Magnetica Pentru Cutite Victorinox, 35 cm, Negru

7.7091.3
Livrare 48-72ore

130,00Lei

Conector Carp Academy cu Eliberare Rapida Magnetica

Conector Carp Academy cu Eliberare Rapida Magnetica

8100-306
Livrare imediată!

15,01Lei

CUTIE NGT RIGIDA XPR CU INCHIDERE MAGNETICA, 24X13X4CM

CUTIE NGT RIGIDA XPR CU INCHIDERE MAGNETICA, 24X13X4CM

ngt-ftb-boxsystem-xpr
Livrare imediată!

59,00Lei

LED LENSER PRINDERE MAGNETICA PENTRU LANTERNELE M10/M14

LED LENSER PRINDERE MAGNETICA PENTRU LANTERNELE M10/M14

a8.z501033
Livrare imediată!

209,38Lei

Cutie Magnetica pentru Accesorii C-Tec Session Box, 24x13x4cm
Exclusiv online!

Cutie Magnetica pentru Accesorii C-Tec Session Box, 24x13x4cm

006405-00035-00000
Livrare 48-72 ore

59,00Lei

CUTIE NGT RIGIDA PENTRU ACCESORII BIT XPR CU INCHIDERE MAGNETICA, 14 COMPARTIMENTE, 12X10X3.5CM

CUTIE NGT RIGIDA PENTRU ACCESORII BIT XPR CU INCHIDERE MAGNETICA, 14 COMPARTIMENTE, 12X10X3.5CM

ngt-ftb-bit-xpr
Livrare imediată!

16,51Lei

Cutie magnetica Delphin MAGBOX 12.5x8x2cm -47%

Cutie magnetica Delphin MAGBOX 12.5x8x2cm

902110400
Stoc epuizat

28,00Lei(-47%) 14,90Lei

Busola Coghlans magnetica de buzunar -42%

Busola Coghlans magnetica de buzunar

c8048
Stoc epuizat

54,00Lei(-42%) 31,23Lei

LAMPA PROLOGIC MAGNETICA CU TELECOMANDA +CABLU USB -42%

LAMPA PROLOGIC MAGNETICA CU TELECOMANDA +CABLU USB

svs65000
Stoc epuizat

172,75Lei(-42%) 99,90Lei

Cutie Magnetica Filex Chod si Zig cu 12 Eva Rig Winders 36x16x4cm -29%

Cutie Magnetica Filex Chod si Zig cu 12 Eva Rig Winders 36x16x4cm

fil0998
Stoc epuizat

89,00Lei(-29%) 63,57Lei

LANTERNA MAGNETICA REINCARCABILA LED LENSER IF8R POWERBANK 4500 LUMENI -24%

LANTERNA MAGNETICA REINCARCABILA LED LENSER IF8R POWERBANK 4500 LUMENI

a8.z502002
Stoc epuizat

1.085,45Lei(-24%) 822,31Lei

Conector Magnetic Frichy Magnetic Net Relese
Exclusiv online!

Conector Magnetic Frichy Magnetic Net Relese

414x67
Livrare 48-72 ore

35,11Lei

ADAPTOR KORDA MAGNETIC

ADAPTOR KORDA MAGNETIC

keb15
Livrare imediată!

36,25Lei

STICK KORDA MAGNETIC HOCKEY

STICK KORDA MAGNETIC HOCKEY

keb14
Livrare imediată!

49,94Lei

Patent Rapala Magnetic 18cm
Exclusiv online!

Patent Rapala Magnetic 18cm

rcdmp6
Livrare 48-72ore

149,00Lei

Conector Zfish Quick Magnetic Clip, Black

Conector Zfish Quick Magnetic Clip, Black

zf-8585
Livrare imediată!

27,68Lei

CONECTOR RAPID FL MAGNETIC BLACK LABEL

CONECTOR RAPID FL MAGNETIC BLACK LABEL

64-2126
Livrare imediată!

35,90Lei

Afişare 1 - 20 din 67 (4 pagini)
Queries: 13, Total time: 2.452 ms [By time] [By id] [By file]
1 (0.073)
SELECT data
FROM `oc_session`
WHERE session_id = '8864dcbe8dae7cec77cf50d55a'
/var/www/clients/client1/web1/web/system/library/session/db.php:24
2 (0.121)
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.266)
INSERT INTO oc_bf_tmp_product (product_id, sort_order, quantity, manufacturer_id, match_filters, actual_price, sort) VALUES ("161793", "2", "1000", "138", "1", "54.620000000000", "1"),("164633", "2", "4", "16", "1", "8.320000000000", "2"),("220204", "1", "1004", "224", "1", "23.530000000000", "3"),("219847", "1", "1000", "749", "1", "109.240000000000", "4"),("204275", "2", "1010", "45", "1", "12.610000000000", "5"),("96168", "2", "4", "287", "1", "49.580000000000", "6"),("63728", "2", "1001", "53", "1", "175.950000000000", "7"),("173069", "2", "1000", "502", "1", "49.580000000000", "8"),("96167", "2", "38", "287", "1", "13.870000000000", "9"),("75165", "2", "0", "469", "1", "12.520000000000", "10"),("72823", "2", "0", "464", "1", "26.240000000000", "11"),("116752", "2", "0", "47", "1", "83.950000000000", "12"),("175264", "1", "0", "528", "1", "53.420000000000", "13"),("92766", "2", "0", "53", "1", "691.020000000000", "14"),("70673", "2", "1000", "434", "1", "29.500000000000", "15"),("145431", "2", "1003", "73", "1", "30.460000000000", "16"),("145429", "2", "1003", "73", "1", "41.970000000000", "17"),("101007", "2", "1000", "117", "1", "125.210000000000", "18"),("212667", "2", "1069", "370", "1", "23.260000000000", "19"),("152323", "2", "1005", "13", "1", "30.170000000000", "20"),("231706", "2", "1000", "224", "1", "55.460000000000", "21"),("167168", "1", "4", "59", "1", "71.810000000000", "22"),("106810", "1", "3", "59", "1", "60.500000000000", "23"),("167167", "1", "2", "59", "1", "97.390000000000", "24"),("22177", "2", "1", "237", "1", "31.440000000000", "25"),("130223", "2", "1002", "75", "1", "36.970000000000", "26"),("104202", "1", "1000", "42", "1", "45.380000000000", "27"),("181025", "1", "1000", "138", "1", "21.010000000000", "28"),("229488", "2", "1000", "42", "1", "84.030000000000", "29"),("229489", "2", "1000", "42", "1", "36.130000000000", "30"),("122533", "1", "1000", "124", "1", "46.220000000000", "31"),("9646", "2", "20", "47", "1", "25.210000000000", "32"),("152315", "2", "5", "13", "1", "41.930000000000", "33"),("239572", "2", "1004", "13", "1", "94.030000000000", "34"),("239567", "2", "1003", "13", "1", "75.550000000000", "35"),("239571", "2", "1002", "13", "1", "83.950000000000", "36"),("229331", "2", "1000", "540", "1", "39.330000000000", "37"),("180081", "2", "1000", "13", "1", "79.750000000000", "38"),("74191", "4", "1012", "13", "1", "57.900000000000", "39"),("237553", "1", "1005", "13", "1", "58.000000000000", "40"),("239539", "2", "1005", "13", "1", "41.930000000000", "41"),("239544", "2", "1005", "13", "1", "35.210000000000", "42"),("239545", "2", "1005", "13", "1", "41.090000000000", "43"),("239542", "2", "1004", "13", "1", "54.540000000000", "44"),("223739", "2", "1000", "370", "1", "31.660000000000", "45"),("152313", "2", "3", "13", "1", "41.930000000000", "46"),("152325", "1", "1022", "13", "1", "39.410000000000", "47"),("152327", "1", "1018", "13", "1", "43.610000000000", "48"),("236285", "2", "1004", "648", "1", "35.290000000000", "49"),("188239", "1", "1002", "13", "1", "63.780000000000", "50"),("120307", "2", "1001", "53", "1", "28.520000000000", "51"),("197765", "2", "2", "287", "1", "16.800000000000", "52"),("106977", "1", "3", "287", "1", "105.040000000000", "53"),("121180", "2", "2", "287", "1", "57.140000000000", "54"),("199537", "2", "1008", "648", "1", "18.910000000000", "55"),("145869", "2", "1000", "53", "1", "356.510000000000", "56"),("125519", "4", "1000", "13", "1", "268.820000000000", "57"),("87580", "2", "0", "468", "1", "8.200000000000", "58"),("152311", "2", "0", "13", "1", "32.000000000000", "59"),("110856", "10", "0", "82", "1", "36.970000000000", "60"),("95981", "2", "0", "514", "1", "58.000000000000", "61"),("225097", "2", "0", "96", "1", "19.330000000000", "62"),("95830", "2", "0", "98", "1", "198.080000000000", "63"),("95831", "2", "0", "98", "1", "209.480000000000", "64"),("14484", "2", "0", "115", "1", "29.000000000000", "65"),("95754", "2", "0", "287", "1", "19.810000000000", "66"),("227912", "1", "0", "53", "1", "1013.920000000000", "67")
/var/www/clients/client1/web1/web/catalog/model/module/brainyfilter.php:846
5 (0.089)
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.213)
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.151)
SELECT *
FROM oc_stock_status
WHERE furnizor LIKE '%"AG COMEXIM SRL"%' AND language_id = '2'
/var/www/clients/client1/web1/web/catalog/model/catalog/product.php:130
8 (0.126)
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.257)
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
10 (0.081)
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
11 (0.074)
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
12 (0.748)
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
13 (0.119)
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