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


VOBLER JAXON ATRACT MINI F J 3.5CM 3.5GR

VOBLER JAXON ATRACT MINI F J 3.5CM 3.5GR

vr-xhg035j
Stoc epuizat

12,99Lei

SET AVERTIZOARE FOX MINI MICRON X LIMITE EDITION CAMO 4+1 -16%

SET AVERTIZOARE FOX MINI MICRON X LIMITE EDITION CAMO 4+1

cei214
Stoc epuizat

1.912,46Lei(-16%) 1.599,99Lei

Technopufi Mini Vanilie

Technopufi Mini Vanilie

79480001
Stoc epuizat

4,00Lei

Pelete Method Feeder Sensas Mini Sticky Crazy 2mm 700g

Pelete Method Feeder Sensas Mini Sticky Crazy 2mm 700g

a0.s44783
Stoc epuizat

30,59Lei

Vobler Rapala Mini Fat Rap, Culoare CBN, 3cm, 4g

Vobler Rapala Mini Fat Rap, Culoare CBN, 3cm, 4g

mfr03 cbn
Stoc epuizat

42,99Lei

Croseta Ridge Monkey RM-Tec Mini Stick Needle -10%

Croseta Ridge Monkey RM-Tec Mini Stick Needle

rmt074
Stoc epuizat

22,23Lei(-10%) 20,00Lei

POP-UP Mini MAINLINE Alb/Roz Cell 150ml

POP-UP Mini MAINLINE Alb/Roz Cell 150ml

a0.m.m21034
Stoc epuizat

48,86Lei

SET AVERTIZOARE FOX MINI MICRON X LIMITE EDITION CAMO 3+1 -17%

SET AVERTIZOARE FOX MINI MICRON X LIMITE EDITION CAMO 3+1

cei213
Stoc epuizat

1.529,96Lei(-17%) 1.269,99Lei

KIT PROLOGIC K1 MINI HANGER 4 CULORI 3BUC/SET

KIT PROLOGIC K1 MINI HANGER 4 CULORI 3BUC/SET

a.pro.65017
Stoc epuizat

173,20Lei

Cosulet Nisa Feeders Pellet Feeders Mini 28g

Cosulet Nisa Feeders Pellet Feeders Mini 28g

z3
Stoc epuizat

8,29Lei

HANGER PROLOGIC K1 MINI SET

HANGER PROLOGIC K1 MINI SET

a.pro.65016
Stoc epuizat

42,85Lei

Suport Mostiro Mini V

Suport Mostiro Mini V

4038
Stoc epuizat

2,59Lei

Rucsac Multifunctional Sakura Mini Shoulder Bag 23x17x9cm

Rucsac Multifunctional Sakura Mini Shoulder Bag 23x17x9cm

90434saplf3021-blac/ora
Stoc epuizat

170,65Lei

Pelete Method Feeder Sensas Mini Sticky Carp Super Krill 2mm 700g

Pelete Method Feeder Sensas Mini Sticky Carp Super Krill 2mm 700g

a0.s44784
Stoc epuizat

30,59Lei

SET PLUMBI LINEAEFFE CUTIE MINI 0.15G

SET PLUMBI LINEAEFFE CUTIE MINI 0.15G

a3.8160701
Stoc epuizat

11,25Lei

JIG YARIE 611 MINI BASIC NR. 4 5.5g 5buc/plic

JIG YARIE 611 MINI BASIC NR. 4 5.5g 5buc/plic

y611jh050
Stoc epuizat

13,99Lei

SHAD NOMURA SOFT MINI 076 7.5CM 2.5G 5BUC/PLIC

SHAD NOMURA SOFT MINI 076 7.5CM 2.5G 5BUC/PLIC

f1.nm.76107607
Stoc epuizat

24,92Lei

JIG YARIE 611 MINI BASIC NR. 4 3.5g 5buc/plic

JIG YARIE 611 MINI BASIC NR. 4 3.5g 5buc/plic

y611jh035
Stoc epuizat

13,99Lei

Alune tigrate Enterprise Tackle Sinking Mini

Alune tigrate Enterprise Tackle Sinking Mini

et30ms
Stoc epuizat

14,00Lei

Geanta Guru EVA Mini Fusion Net

Geanta Guru EVA Mini Fusion Net

a8.gu.glg026
Stoc epuizat

370,49Lei

Afişare 521 - 540 din 567 (29 pagini)
Queries: 10, Total time: 22.561 ms [By time] [By id] [By file]
1 (0.093)
SELECT data
FROM `oc_session`
WHERE session_id = '2ffc7d2a78635a4d6c1645115b'
/var/www/clients/client1/web1/web/system/library/session/db.php:23
2 (0.113)
SELECT `trigger`, `action`
FROM oc_event
/var/www/clients/client1/web1/web/index.php:428
3 (19.194)
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('+mini' 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 (2.562)
SELECT p.*, pp.sort_order, pp.viewed, IF ((pp.quantity) > 0, 1, 0) AS array_quantity
FROM `oc_bf_tmp_product` AS p
INNER JOIN `oc_product_description` AS pd ON (pd.product_id = p.product_id)
INNER JOIN `oc_product` AS pp ON (pp.product_id = p.product_id)
WHERE match_filters = 1 AND pd.language_id = '2'
ORDER BY array_quantity DESC, pp.sort_order ASC, pp.viewed DESC, pd.name ASC LIMIT 520, 20
/var/www/clients/client1/web1/web/catalog/model/catalog/product.php:184
5 (0.133)
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
6 (0.125)
SELECT *
FROM oc_stock_status
WHERE furnizor LIKE '%"ENERGOFISH DEZACTIVATE"%' AND language_id = '2'
/var/www/clients/client1/web1/web/catalog/model/catalog/product.php:130
7 (0.099)
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
8 (0.078)
SELECT *
FROM oc_stock_status
WHERE furnizor LIKE '%"CARP INTELLIGENCE LTD"%' AND language_id = '2'
/var/www/clients/client1/web1/web/catalog/model/catalog/product.php:130
9 (0.076)
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
10 (0.088)
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