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 90 zile

Retur simplu in 90 zile.

Vezi mai multe detalii

Căutare

Produse ce potrivesc criteriilor de căutare


KIT PROLOGIC K1 LIMITED EDITION MINI HANGER 4 CULORI MOV -39%

KIT PROLOGIC K1 LIMITED EDITION MINI HANGER 4 CULORI MOV

a.pro.65054
Livrare imediată!

305,90Lei(-39%) 187,62Lei

PICHET PROLOGIC TELESCOPIC 30-50CM

PICHET PROLOGIC TELESCOPIC 30-50CM

a6.pro.54954
Livrare imediată!

23,30Lei

FOARFECA RETRACTABILA PRO FL PORTOCALIE

FOARFECA RETRACTABILA PRO FL PORTOCALIE

65-25758
Livrare imediată!

15,13Lei

HANORAC PROLOGIC EDEN ZIP BLACK CAVIAR MARIME XL
Exclusiv online!

HANORAC PROLOGIC EDEN ZIP BLACK CAVIAR MARIME XL

a8.pro.73754
Livrare 24-48 ore

232,88Lei

SET 2 BUC PLUMB Sondare PRO FL BOMB 30G INLINE

SET 2 BUC PLUMB Sondare PRO FL BOMB 30G INLINE

64-65764
Livrare imediată!

14,12Lei

LANSETA CRAP PRO FL POWER TELE CARP 3.90M 160-360G
Exclusiv online!

LANSETA CRAP PRO FL POWER TELE CARP 3.90M 160-360G

64-45445
Livrare 24-48 ore

176,81Lei

SET CARP TOOLS CROSETE, BURGHIU, KNOT PULER SI FOARFECA PRO FL

SET CARP TOOLS CROSETE, BURGHIU, KNOT PULER SI FOARFECA PRO FL

65-25734
Livrare imediată!

31,40Lei

LANSETA CRAP PRO FL TELE STRATEGIST 3.90M 3.75LBS

LANSETA CRAP PRO FL TELE STRATEGIST 3.90M 3.75LBS

3754-3907
Livrare imediată!

229,68Lei

LANSETA CRAP PRO FL TELE STRATEGIST 3.60M 3.75LBS

LANSETA CRAP PRO FL TELE STRATEGIST 3.60M 3.75LBS

3754-3607
Livrare imediată!

219,51Lei

CARLIGE LEGATE FEEDER PRO FL FLUOROCARBON 10CM 10BUC CARLIG NR 6 CU SPIN

CARLIGE LEGATE FEEDER PRO FL FLUOROCARBON 10CM 10BUC CARLIG NR 6 CU SPIN

64-65054
Livrare imediată!

19,20Lei

MANER MINCIOG PRO FL COMPETITION TELE 2.00M

MANER MINCIOG PRO FL COMPETITION TELE 2.00M

64-45766
Livrare imediată!

75,13Lei

MANER MINCIOG PRO FL COMPETITION TELE 4.00M
Exclusiv online!

MANER MINCIOG PRO FL COMPETITION TELE 4.00M

64-45780
Livrare 24-48 ore

93,42Lei

MANER MINCIOG PRO FL COMPETITION TELE 3.00M
Exclusiv online!

MANER MINCIOG PRO FL COMPETITION TELE 3.00M

64-45773
Livrare 24-48 ore

89,36Lei

UNDITA PRO FL STRATEGIST FORCE 8MT 40-100G UP TO 4.5KG

UNDITA PRO FL STRATEGIST FORCE 8MT 40-100G UP TO 4.5KG

64-4074
Livrare imediată!

550,99Lei

CROSETA PROLOGIC BOILIES LIP NEEDLE -35%

CROSETA PROLOGIC BOILIES LIP NEEDLE

a.pro.49954
Stoc epuizat

22,20Lei(-35%) 14,39Lei

Fir Monifilament Prologic XD Distance Mono Hi-Viz, Yellow, 1000m, 0.25mm, 4.8kg
SAPCA PROLOGIC BANK BOUND FLAT BILL NEGRU/CAMO -25%

SAPCA PROLOGIC BANK BOUND FLAT BILL NEGRU/CAMO

a8.pro.54654
Stoc epuizat

53,93Lei(-25%) 40,72Lei

LANSETA CRAP PRO FL Legend Carp 3.90M 3.75LBS 2SEGMENTE -38%

LANSETA CRAP PRO FL Legend Carp 3.90M 3.75LBS 2SEGMENTE

64-45353
Stoc epuizat

176,81Lei(-38%) 108,90Lei

LANSETA CRAP PRO FL TELE CARP 3.60M 160-360G -38%

LANSETA CRAP PRO FL TELE CARP 3.60M 160-360G

64-45384
Stoc epuizat

165,62Lei(-38%) 102,85Lei

Afişare 1 - 19 din 19 (1 pagini)
Queries: 12, Total time: 1.699 ms [By time] [By id] [By file]
1 (0.101)
SELECT data
FROM `oc_session`
WHERE session_id = 'c59b37fa55930e2f782705b6e4'
/var/www/clients/client1/web1/web/system/library/session/db.php:24
2 (0.084)
SELECT `trigger`, `action`
FROM oc_event
/var/www/clients/client1/web1/web/index.php:453
3 (0.132)
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.120)
INSERT INTO oc_bf_tmp_product (product_id, sort_order, quantity, manufacturer_id, match_filters, actual_price, sort) VALUES ("143293", "2", "1", "47", "1", "155.060000000000", "1"),("47455", "2", "1", "47", "1", "19.260000000000", "2"),("181229", "1", "1007", "13", "1", "12.500000000000", "3"),("120776", "1", "1000", "47", "1", "192.460000000000", "4"),("226777", "2", "1014", "13", "1", "11.670000000000", "5"),("200545", "1", "1000", "13", "1", "146.120000000000", "6"),("181231", "2", "1016", "13", "1", "25.950000000000", "7"),("181461", "1", "1004", "13", "1", "189.820000000000", "8"),("181459", "1", "1003", "13", "1", "181.410000000000", "9"),("219566", "1", "1003", "13", "1", "15.870000000000", "10"),("178089", "1", "1003", "13", "1", "62.090000000000", "11"),("178091", "1", "1000", "13", "1", "77.210000000000", "12"),("178090", "1", "1000", "13", "1", "73.850000000000", "13"),("201845", "1", "1001", "13", "1", "455.360000000000", "14"),("68023", "2", "0", "47", "1", "11.890000000000", "15"),("172437", "1", "0", "47", "1", "62.230000000000", "16"),("43356", "2", "0", "47", "1", "33.650000000000", "17"),("199937", "1", "0", "13", "1", "90.000000000000", "18"),("200563", "1", "0", "13", "1", "85.000000000000", "19")
/var/www/clients/client1/web1/web/catalog/model/module/brainyfilter.php:846
5 (0.121)
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.209)
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.110)
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.174)
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
9 (0.112)
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
10 (0.063)
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
11 (0.353)
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
12 (0.120)
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