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


Varnis Siliconic Stonfo Protectie Nod, Marimea 2, 4mm, 15buc/set

Varnis Siliconic Stonfo Protectie Nod, Marimea 2, 4mm, 15buc/set

8028651002473
Stoc epuizat

4,80Lei

INEL CULISANT JAXON NR 4 1.4MM

INEL CULISANT JAXON NR 4 1.4MM

ok-11414
Stoc epuizat

21,00Lei

INEL CULISANT JAXON NR 4 2.4MM

INEL CULISANT JAXON NR 4 2.4MM

ok-11424
Stoc epuizat

21,00Lei

INEL CULISANT JAXON NR 6 1.4MM

INEL CULISANT JAXON NR 6 1.4MM

ok-11614
Stoc epuizat

21,00Lei

WADERS SPRO NEOPREN 4MM MAR 41

WADERS SPRO NEOPREN 4MM MAR 41

007211-00041-00000
Stoc epuizat

483,00Lei

APICALE EXTERNA RUBEZIANA 1.4MM MAVER -20%

APICALE EXTERNA RUBEZIANA 1.4MM MAVER

317140
Stoc epuizat

10,50Lei(-20%) 8,40Lei

INEL CULISANT JAXON NR 6 2.4MM

INEL CULISANT JAXON NR 6 2.4MM

ok-11624
Stoc epuizat

21,00Lei

Varf de Rezerva pentru Lansete Matrix Aquos Ultra-D Class 58cm 3.4mm 2.5oz
Varf de Rezerva pentru Lansete Matrix Aquos Ultra-D Class 58cm 3.4mm 3.5oz
WADERS SPRO NEOPREN 4MM MAR 40

WADERS SPRO NEOPREN 4MM MAR 40

007211-00040-00000
Stoc epuizat

483,00Lei

Sita Spro Cresta Super Riddle 36cm 4mm

Sita Spro Cresta Super Riddle 36cm 4mm

006403-00105-00000
Stoc epuizat

101,50Lei

WADERS SPRO NEOPREN 4MM MAR 38

WADERS SPRO NEOPREN 4MM MAR 38

007211-00038-00000
Stoc epuizat

483,00Lei

Varf de Rezerva pentru Lansete Matrix Horizon XD Class 3.4mm 2.5 Oz -20%

Varf de Rezerva pentru Lansete Matrix Horizon XD Class 3.4mm 2.5 Oz

grd127
Stoc epuizat

110,21Lei(-20%) 88,17Lei

PELETE STIKY BAITS KRILL 4MM 900GR

PELETE STIKY BAITS KRILL 4MM 900GR

kp401
Stoc epuizat

32,00Lei

INELE JAXON VARF NR 4 1.4MM MODEL 2

INELE JAXON VARF NR 4 1.4MM MODEL 2

ok-sm0414
Stoc epuizat

15,51Lei

PELETE JAXON METHOD FEEDER HONEY 4mm 500g

PELETE JAXON METHOD FEEDER HONEY 4mm 500g

fm-pe17
Stoc epuizat

28,00Lei

INEL CULISANT JAXON NR 8 2.4MM

INEL CULISANT JAXON NR 8 2.4MM

ok-11824
Stoc epuizat

21,00Lei

Wafters Feeder Bait Mikron Wafters Fish 50ml 4mm

Wafters Feeder Bait Mikron Wafters Fish 50ml 4mm

fb27-1
Stoc epuizat

23,00Lei

PELETE CARP ZOOM SOFT 4mm 10gr Chocolate -20%

PELETE CARP ZOOM SOFT 4mm 10gr Chocolate

cz2231
Stoc epuizat

11,70Lei(-20%) 9,36Lei

PELETE JAXON PREMIUM VANILIA 4mm 1kg -30%

PELETE JAXON PREMIUM VANILIA 4mm 1kg

fj-pl402
Stoc epuizat

25,00Lei(-30%) 17,51Lei

Afişare 221 - 240 din 263 (14 pagini)
Queries: 7, Total time: 8.953 ms [By time] [By id] [By file]
1 (0.150)
SELECT data
FROM `oc_session`
WHERE session_id = '32c02ea5010d1c17a65dbd3b44'
/var/www/clients/client1/web1/web/system/library/session/db.php:24
2 (0.074)
SELECT `trigger`, `action`
FROM oc_event
/var/www/clients/client1/web1/web/index.php:428
3 (7.100)
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('+4mm' 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 (1.327)
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 220, 20
/var/www/clients/client1/web1/web/catalog/model/catalog/product.php:184
5 (0.126)
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.080)
SELECT *
FROM oc_stock_status
WHERE furnizor LIKE '%"OVIDIUS DOCTOR FISHING SRL"%' AND language_id = '2'
/var/www/clients/client1/web1/web/catalog/model/catalog/product.php:130
7 (0.096)
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