Gama variata de produse

La Claumar Pescar poti alege simplu si rapid dintr-o gama variata de articole de pescuit.

Transport Gratuit

Comenzile peste 300 lei pot beneficia de transport gratuit.

Vezi mai multe detalii

Plata cu cardul

Plata cu cardul in rate fara dobanda.

Vezi mai multe detalii

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 simplu in 14 zile

Retur simplu in 14 zile.

Vezi mai multe detalii

Căutare

Filtreaza

Produse ce potrivesc criteriilor de căutare

Sortare după:

BRAT MODULAR PRESTON SUSTINERE TAVA UNI SYDE TRAY SUPPORT

p0110036

Stoc epuizat

134,96Lei

Fir P-Line Shinsei Fluorocarbon 50m - 0.210mm/6.8LB

750187905

Stoc epuizat

41,00Lei

-6%

Fir P-Line Shinsei Fluorocarbon 50m - 0.379mm/19.5LB

750187911

Stoc epuizat

53,00Lei(-6%) 50,00Lei

LANSETA PRESTON C-DROME POWER METHOD FEEDER 3.30M, 100G, 2+3SEG

p0080008

Stoc epuizat

285,56Lei

Suport Preston Competition Pro Roost Standard, 12 Posturi

p0220023

Stoc epuizat

314,96Lei

Tub anti-tangle Enterprise Tackle Anti-tangle Leger Booms - 4cm

et78s

Stoc epuizat

15,01Lei

Brat Feeder Korum Any Chair XS Feeder Arm Tele

k0300035

Stoc epuizat

166,46Lei

Fir P-Line Shinsei Fluorocarbon 50m - 0.188mm

750187904

Stoc epuizat

40,00Lei

Fir P-Line Shinsei Fluorocarbon 50m - 0.225mm/7.4LB

750187906

Stoc epuizat

42,99Lei

Mulineta Colmic Laris FD 6000 8+1BB

mullar60

Stoc epuizat

359,00Lei

Scaun Colmic Veteran 100

pa105a

Stoc epuizat

1.300,00Lei

Varf Guru N-Gauge Specimen 4oz

gu.grd185

Stoc epuizat

92,67Lei

Conector Cosulet Feeder Filfishing Running Rig, 70mm, 2buc/plic

fil6960

Stoc epuizat

5,00Lei

Fir P-Line Shinsei Fluorocarbon 50m - 0.253mm/9.4LB

750187907

Stoc epuizat

50,00Lei

-6%

Fir P-Line Shinsei Fluorocarbon 50m - 0.295mm/12.5LB

750187908

Stoc epuizat

50,00Lei(-6%) 47,01Lei

Mulineta Tica Sea Mentor SEM5000M, 7+1rul

sem5000m

Stoc epuizat

275,00Lei

-28%

Lanseta Okuma Custom Black Feeder MH, 12' 360cm, 40-80g, 3+3seg MG/MLG/LG

cb-f-1203mh40-80

Stoc epuizat

413,10Lei(-28%) 299,00Lei

Mulineta Daiwa TDR Distance 25QD 0.28mm/150m, 4.7:1, 6rul

d.10922.026

Stoc epuizat

1.798,23Lei

Fir Monofilament Preston Reflo Precision Power, 0.79kg ,0.07mm, 50m

pcp/07

Stoc epuizat

22,00Lei

JUVELNIC TRABUCCO ROTUND, 2.5m

082-50-250

Stoc epuizat

139,00Lei

Afişare 11981 - 12000 din 12283 (615 pagini)

Queries: 11, Total time: 5,985.964 ms [By time] [By id] [By file]

1 (0.158)

SELECT data
FROM `oc_session`
WHERE session_id = 'e7a4f36adb1c28bab3b2e5bbb2'

/var/www/clients/client1/web1/web/system/library/session/db.php:23

2 (0.129)

SELECT *
FROM oc_platforma_promovari LIMIT 1

/var/www/clients/client1/web1/web/index.php:128

3 (0.115)

SELECT `trigger`, `action`
FROM oc_event

/var/www/clients/client1/web1/web/index.php:422

4 (2,379.551)

SELECT p.product_id, p.sort_order, p.quantity, p.manufacturer_id, "1" AS match_filters, pp.sort_order, pp.viewed, IF ((pp.quantity) > 0, 1, 0) AS array_quantity
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)
INNER JOIN `oc_product` AS pp ON (pp.product_id = p.product_id)
WHERE p2s.store_id = '0' AND (pd.tag LIKE "%feeder%") AND p.status_filtru > 0 AND p.price > 0 AND pd.language_id = '2' GROUP BY p.product_id HAVING match_filters = 1
ORDER BY array_quantity DESC, pp.sort_order ASC, pp.viewed DESC, pd.name ASC LIMIT 11980, 20

/var/www/clients/client1/web1/web/catalog/model/catalog/product.php:184

5 (0.170)

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

6 (2,457.897)

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` GROUP BY tax_class_id) AS tx ON (p.tax_class_id = tx.tax_class_id)
WHERE p2s.store_id = '0' AND (pd.tag LIKE "%feeder%") 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:697

7 (4.696)

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:1066

8 (1,135.966)

SELECT COUNT(*) 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:911

9 (0.173)

SELECT *
FROM oc_platforma_promovari

/var/www/clients/client1/web1/web/catalog/model/common/platforma.php:4

10 (5.895)

SELECT *
FROM oc_platforma_promovari

/var/www/clients/client1/web1/web/catalog/model/common/platforma.php:4

11 (1.214)

SELECT *
FROM `oc_mxt_setting`
WHERE store_id = '0' AND name = 'lichidare_stoc'

/var/www/clients/client1/web1/web/catalog/model/catalog/category.php:38

Produsul a fost adăugat în coș

Anunță-mă când intră în stoc!

Căutare

Produse ce potrivesc criteriilor de căutare