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


Fir Textil Zeck Hulk Line Verde, 0.40mm, 27kg, 250m
Exclusiv online!

Fir Textil Zeck Hulk Line Verde, 0.40mm, 27kg, 250m

110405130044
Livrare 48-72 ore

218,97Lei

Greutate Zeck 190gr Disk Teaser Green

Greutate Zeck 190gr Disk Teaser Green

40305150041
Livrare imediată!

55,01Lei

Lanseta Cormoran Seacor Deep Zone 2.35m, 400-600g, 2seg

Lanseta Cormoran Seacor Deep Zone 2.35m, 400-600g, 2seg

c.29.856023
Livrare imediată!

264,24Lei

Lanseta Penn Regiment III Solid Carbon Boat ML, 6-12lbs, 2.30m, 1+1seg
Exclusiv online!

Lanseta Penn Regiment III Solid Carbon Boat ML, 6-12lbs, 2.30m, 1+1seg

1571211
Livrare 7-14 zile

616,21Lei

Lanseta Sportex Catfire CS-2 Boat 2.80m, 150-300g, 2seg
Exclusiv online!

Lanseta Sportex Catfire CS-2 Boat 2.80m, 150-300g, 2seg

cf2808
Livrare 48-72 ore

880,01Lei

Lingura Somn Mikado Clicker 65G/11Cm - Silver

Lingura Somn Mikado Clicker 65G/11Cm - Silver

pmb-wctd-65-s
Livrare imediată!

38,00Lei

Montura Somn Golden Catch Big Bait 8/0
Exclusiv online!

Montura Somn Golden Catch Big Bait 8/0

gcz-4365276
Livrare 48-72ore

67,50Lei

Montura Somn Golden Catch Double Hook 6/0
Exclusiv online!

Montura Somn Golden Catch Double Hook 6/0

gcz-4365255
Livrare 48-72ore

50,00Lei

Montura Somn Golden Catch Double Hook 8/0
Exclusiv online!

Montura Somn Golden Catch Double Hook 8/0

gcz-4365256
Livrare 48-72ore

52,50Lei

Montura Somn Golden Catch Single and Treble Hooks 6/0
Exclusiv online!

Montura Somn Golden Catch Single and Treble Hooks 6/0

gcz-4365270
Livrare 48-72ore

57,50Lei

Montura Somn Golden Catch Single and Treble Hooks 8/0
Exclusiv online!

Montura Somn Golden Catch Single and Treble Hooks 8/0

gcz-4365271
Livrare 48-72ore

60,00Lei

Montura Somn Golden Catch Single Hook Texas 6/0
Exclusiv online!

Montura Somn Golden Catch Single Hook Texas 6/0

gcz-4365261
Livrare 48-72 ore

53,90Lei

Montura Somn Golden Catch Single Hook Texas 8/0
Exclusiv online!

Montura Somn Golden Catch Single Hook Texas 8/0

gcz-4365262
Livrare 48-72ore

60,00Lei

Montura Somn Golden Catch Single Hook With Rattle 4/0
Exclusiv online!

Montura Somn Golden Catch Single Hook With Rattle 4/0

gcz-4365250
Livrare 48-72ore

47,50Lei

Mulineta Penn Warfare Star Drag Right Handle 20N Reel Box
Exclusiv online!

Mulineta Penn Warfare Star Drag Right Handle 20N Reel Box

1366200
Livrare 7-14 zile

449,96Lei

Agrafa cu Vartej Mikado Heavy Swivel With Screwed Snap 5mm, Black Matt, 5Buc/plic
Exclusiv online!

Agrafa cu Vartej Mikado Heavy Swivel With Screwed Snap 5mm, Black Matt, 5Buc/plic

ama-c4032-5
Livrare 48-72 ore

26,00Lei

Carlige BKK Big Baits Nr.4/0, 6buc/plic

Carlige BKK Big Baits Nr.4/0, 6buc/plic

6939067007599
Livrare imediată!

37,00Lei

Carlige BKK Big Baits Nr.5/0, 5buc/plic
Exclusiv online!

Carlige BKK Big Baits Nr.5/0, 5buc/plic

6939067007605
Livrare 48-72 ore

37,00Lei

Carlige DAM Madcat A-Static Teaser Nr.7/0, 4buc/pac
Exclusiv online!

Carlige DAM Madcat A-Static Teaser Nr.7/0, 4buc/pac

a.mad.56839
Livrare 24-48 ore

33,53Lei

Carlige Somn Zeck Classic Cat Hook M, 4buc/pac
Exclusiv online!

Carlige Somn Zeck Classic Cat Hook M, 4buc/pac

120405110221
Livrare 48-72 ore

40,67Lei

Afişare 481 - 500 din 2568 (129 pagini)
Queries: 16, Total time: 81.776 ms [By time] [By id] [By file]
1 (0.111)
SELECT data
FROM `oc_session`
WHERE session_id = '61654f0284ceaad21f96ef4ece'
/var/www/clients/client1/web1/web/system/library/session/db.php:23
2 (0.075)
SELECT `trigger`, `action`
FROM oc_event
/var/www/clients/client1/web1/web/index.php:428
3 (55.796)
CREATE TEMPORARY TABLE oc_bf_tmp_product (PRIMARY KEY (`product_id`), INDEX my_index (match_filters, sort_order, manufacturer_id)) ENGINE=MEMORY SELECT p.product_id, p.sort_order, p.quantity, p.manufacturer_id, "1" AS match_filters, (IF(MIN(ps.price) IS NOT NULL, MIN(ps.price), p.price) * (1 + IFNULL(percent_tax, 0)/100) + IFNULL(fixed_tax, 0)) AS actual_price
FROM `oc_product` AS p
INNER JOIN `oc_product_to_store` AS p2s ON (p2s.product_id = p.product_id)
INNER JOIN `oc_bf_filter` AS f ON (p.product_id = f.product_id)
INNER JOIN `oc_product_description` AS pd ON (pd.product_id = p.product_id)
LEFT JOIN `oc_product_special` AS ps ON (ps.product_id = p.product_id AND (ps.date_end = '0000-00-00' OR ps.date_end > NOW()) AND (ps.date_start = '0000-00-00' OR ps.date_start < NOW()) AND ps.customer_group_id = '1')
LEFT JOIN ( SELECT SUM(fixed_rate) AS fixed_tax, SUM(percent_rate) AS percent_tax, tax_class_id
FROM `oc_bf_tax_rate`) AS tx ON (p.tax_class_id = tx.tax_class_id)
WHERE p2s.store_id = '2' AND (MATCH(pd.tag) AGAINST('+somn' IN BOOLEAN MODE)) AND p.status_filtru > 0 AND p.price > 0 GROUP BY p.product_id
/var/www/clients/client1/web1/web/catalog/model/module/brainyfilter.php:737
4 (0.418)
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:1561
5 (0.143)
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
6 (0.127)
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
7 (0.129)
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.120)
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.120)
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
10 (0.120)
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
11 (0.119)
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
12 (1.917)
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:1248
13 (0.116)
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:1270
14 (0.485)
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:1035
15 (21.835)
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:949
16 (0.145)
SELECT *
FROM `oc_mxt_setting`
WHERE store_id = '2' AND name = 'lichidare_stoc'
/var/www/clients/client1/web1/web/catalog/model/catalog/category.php:38