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


Lanseta Nash Scope Black Ops 9ft 2.70M 3.0lb S

Lanseta Nash Scope Black Ops 9ft 2.70M 3.0lb S

t1722
Stoc epuizat

2.099,99Lei

Picheti Masurare Distanta NASH Spot On UV Distance Sticks, 70cm

Picheti Masurare Distanta NASH Spot On UV Distance Sticks, 70cm

t0722-tp
Livrare imediată!

70,00Lei

Scaun Trakker RLX Scout Chair, 50x22x50cm

Scaun Trakker RLX Scout Chair, 50x22x50cm

217225
Livrare imediată!

299,90Lei

WAGLER MAVER TRANSPARENT PLUMBAT GIGANT 4BB

WAGLER MAVER TRANSPARENT PLUMBAT GIGANT 4BB

h1422
Livrare imediată!

10,50Lei

Pantaloni Nash Tackle Joggers Black L

Pantaloni Nash Tackle Joggers Black L

c1122
Livrare imediată!

175,99Lei

Croseta FL Leadcore Needle Fine 1.22mm

Croseta FL Leadcore Needle Fine 1.22mm

ak-k1.22
Livrare imediată!

6,70Lei

INEL CULISANT JAXON NR 4 2.2MM

INEL CULISANT JAXON NR 4 2.2MM

ok-11422
Livrare imediată!

21,00Lei

INEL CULISANT JAXON NR 6 2.2MM
Exclusiv online!

INEL CULISANT JAXON NR 6 2.2MM

ok-11622
Livrare 48-72 ore

21,00Lei

INEL CULISANT JAXON NR 8 2.2MM
Exclusiv online!

INEL CULISANT JAXON NR 8 2.2MM

ok-11822
Livrare 48-72 ore

21,00Lei

Borseta Sensas P&M Eaux Source S, 35x18x16cm
Exclusiv online!

Borseta Sensas P&M Eaux Source S, 35x18x16cm

a8.spm.32722
Livrare 24-48 ore

146,10Lei

Spinnertail SENSAS Gunki Shocker Vib 4.5, Acid Shad, 2.2cm, 5.95g
Exclusiv online!

Spinnertail SENSAS Gunki Shocker Vib 4.5, Acid Shad, 2.2cm, 5.95g

spm.17122
Livrare 24-48 ore

32,61Lei

Plumbi Strategy Central Shocker System 121g Green

Plumbi Strategy Central Shocker System 121g Green

008035-00722-00000
Livrare imediată!

35,00Lei

Vobler Gunki Gamera 63HW Gold Trout 6,3 cm 6.4g

Vobler Gunki Gamera 63HW Gold Trout 6,3 cm 6.4g

spm.37122
Livrare imediată!

37,24Lei

Carlige Maver Power Hair Rig Barbless, Nr.14, 10buc/plic
Exclusiv online!

Carlige Maver Power Hair Rig Barbless, Nr.14, 10buc/plic

g1222
Livrare 48-72 ore

11,50Lei

LANSETA SPORTEX NOVA VERTICAL RS-2 BAITCAST 1.95M 30G 2seg
Exclusiv online!

LANSETA SPORTEX NOVA VERTICAL RS-2 BAITCAST 1.95M 30G 2seg

pt1922
Livrare 48-72 ore

809,00Lei

VARTEJ TRIPLU EXTRA CARP NR.12 5BUC/BLISTER 9 KG
Exclusiv online!

VARTEJ TRIPLU EXTRA CARP NR.12 5BUC/BLISTER 9 KG

f1422
Livrare 48-72 ore

9,50Lei

Carlige DECOY Worm 144 Flippin Straight Nr.2/0, 5buc/pac

Carlige DECOY Worm 144 Flippin Straight Nr.2/0, 5buc/pac

817223
Livrare imediată!

18,00Lei

Vobler Duel Hardcore Bullet Crank 7+ 100F BCL, 10cm, 55g
Exclusiv online!

Vobler Duel Hardcore Bullet Crank 7+ 100F BCL, 10cm, 55g

r1422-bcl
Livrare 48-72ore

90,00Lei

Vobler Duel Hardcore Bullet Crank 7+ 100F JPG 10cm, 55g
Exclusiv online!

Vobler Duel Hardcore Bullet Crank 7+ 100F JPG 10cm, 55g

r1422-jpg
Livrare 48-72ore

90,00Lei

SAVAGE GEAR SPINNER DA BUSH 21G WHITE SILVER HOLO FLAME -40%
Exclusiv online!

SAVAGE GEAR SPINNER DA BUSH 21G WHITE SILVER HOLO FLAME

sg.71752
Livrare 24-48 ore

41,79Lei(-40%) 25,07Lei

Afişare 1 - 20 din 56 (3 pagini)
Queries: 13, Total time: 2.666 ms [By time] [By id] [By file]
1 (0.115)
SELECT data
FROM `oc_session`
WHERE session_id = 'f53077d59cd95948584fd4c577'
/var/www/clients/client1/web1/web/system/library/session/db.php:24
2 (0.108)
SELECT `trigger`, `action`
FROM oc_event
/var/www/clients/client1/web1/web/index.php:453
3 (0.120)
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.189)
INSERT INTO oc_bf_tmp_product (product_id, sort_order, quantity, manufacturer_id, match_filters, actual_price, sort) VALUES ("83322", "2", "0", "59", "1", "1764.700000000000", "1"),("236346", "1", "1", "59", "1", "58.820000000000", "2"),("229147", "2", "5", "476", "1", "252.020000000000", "3"),("27178", "2", "1001", "49", "1", "8.820000000000", "4"),("100598", "1", "2", "59", "1", "147.890000000000", "5"),("130203", "1", "1009", "13", "1", "5.630000000000", "6"),("17554", "2", "1001", "42", "1", "17.650000000000", "7"),("17560", "2", "1000", "42", "1", "17.650000000000", "8"),("17567", "2", "1000", "42", "1", "17.650000000000", "9"),("203021", "2", "1000", "62", "1", "122.770000000000", "10"),("226651", "1", "1000", "62", "1", "27.400000000000", "11"),("53144", "2", "1", "71", "1", "29.410000000000", "12"),("118899", "2", "1001", "480", "1", "31.290000000000", "13"),("167185", "1", "1000", "49", "1", "9.660000000000", "14"),("154915", "2", "1000", "192", "1", "679.830000000000", "15"),("63551", "2", "1000", "96", "1", "7.980000000000", "16"),("214239", "2", "1004", "356", "1", "15.130000000000", "17"),("171179", "2", "1000", "337", "1", "75.630000000000", "18"),("171180", "2", "1000", "337", "1", "75.630000000000", "19"),("112246", "1", "1000", "85", "1", "21.070000000000", "20"),("171178", "2", "1000", "337", "1", "75.630000000000", "21"),("94697", "2", "1000", "20", "1", "21.180000000000", "22"),("217393", "1", "1000", "751", "1", "331.800000000000", "23"),("94698", "2", "1000", "20", "1", "21.180000000000", "24"),("84566", "2", "1000", "85", "1", "51.570000000000", "25"),("115143", "1", "1003", "85", "1", "24.740000000000", "26"),("242899", "2", "1001", "149", "1", "89.920000000000", "27"),("210787", "2", "1", "751", "1", "331.800000000000", "28"),("172506", "1", "1002", "85", "1", "13.180000000000", "29"),("115144", "1", "1001", "85", "1", "24.740000000000", "30"),("242912", "2", "1001", "149", "1", "133.610000000000", "31"),("84565", "2", "1000", "85", "1", "51.570000000000", "32"),("116449", "2", "1000", "85", "1", "14.910000000000", "33"),("234110", "1", "0", "59", "1", "49.570000000000", "34"),("83319", "2", "0", "59", "1", "1764.700000000000", "35"),("234433", "2", "0", "59", "1", "865.540000000000", "36"),("198871", "1", "0", "59", "1", "1176.460000000000", "37"),("83316", "2", "0", "59", "1", "1764.700000000000", "38"),("234516", "1", "0", "59", "1", "19.320000000000", "39"),("167647", "1", "0", "59", "1", "1848.730000000000", "40"),("83373", "2", "0", "59", "1", "1176.460000000000", "41"),("109770", "2", "0", "85", "1", "82.910000000000", "42"),("106775", "2", "0", "49", "1", "13.600000000000", "43"),("113738", "2", "0", "59", "1", "655.450000000000", "44"),("92595", "2", "0", "85", "1", "14.650000000000", "45"),("171181", "2", "0", "337", "1", "45.000000000000", "46"),("94696", "2", "0", "20", "1", "15.130000000000", "47"),("112243", "1", "0", "85", "1", "26.190000000000", "48"),("115147", "1", "0", "85", "1", "28.290000000000", "49"),("91993", "2", "0", "85", "1", "42.740000000000", "50"),("77838", "2", "0", "85", "1", "42.740000000000", "51"),("115142", "1", "0", "85", "1", "26.190000000000", "52"),("138361", "2", "0", "85", "1", "119.520000000000", "53"),("77839", "2", "0", "85", "1", "42.740000000000", "54"),("146515", "2", "0", "85", "1", "35.000000000000", "55"),("115141", "1", "0", "85", "1", "24.710000000000", "56")
/var/www/clients/client1/web1/web/catalog/model/module/brainyfilter.php:846
5 (0.130)
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.238)
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.124)
SELECT *
FROM oc_stock_status
WHERE furnizor LIKE '%"TACKLE SHOP ARENA SRL"%' AND language_id = '2'
/var/www/clients/client1/web1/web/catalog/model/catalog/product.php:130
8 (0.125)
SELECT *
FROM oc_stock_status
WHERE furnizor LIKE '%"TACKLE SHOP ARENA SRL"%' AND language_id = '2'
/var/www/clients/client1/web1/web/catalog/model/catalog/product.php:130
9 (0.254)
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.118)
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.111)
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.919)
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.116)
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