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 COLMIC KIRA M1 MATCH 4.50M 25GR

LANSETA COLMIC KIRA M1 MATCH 4.50M 25GR

cbki01b
Stoc epuizat

1.020,00Lei

Lanseta Daiwa Black Widow Match 3.90m 6-18g 3seg

Lanseta Daiwa Black Widow Match 3.90m 6-18g 3seg

d.bwm393paf
Stoc epuizat

325,10Lei

CAP MINCIOG COLMIC RUBBER MATCH CAUCIUCAT 40x45cm

CAP MINCIOG COLMIC RUBBER MATCH CAUCIUCAT 40x45cm

guzh08b
Stoc epuizat

119,00Lei

MULINETA DAIWA TDR MATCH AND FEEDER 4012QD

MULINETA DAIWA TDR MATCH AND FEEDER 4012QD

d.10215.412
Stoc epuizat

1.213,31Lei

CAP MINCIOG MAVER MATCH TOP GREEN 55x45CM

CAP MINCIOG MAVER MATCH TOP GREEN 55x45CM

1974002
Stoc epuizat

132,99Lei

CAP MINCIOG MAVER MATCH SOFT 55x45CM

CAP MINCIOG MAVER MATCH SOFT 55x45CM

1970002
Stoc epuizat

101,99Lei

FIR COLMIC ARWEN MATCH SINNKING 150M 0.20mm

FIR COLMIC ARWEN MATCH SINNKING 150M 0.20mm

nying20
Stoc epuizat

27,00Lei

MULINETA LINEAEFFE VIGOR SOL RD 4000

MULINETA LINEAEFFE VIGOR SOL RD 4000

l.1207204
Stoc epuizat

39,29Lei

LANSETA COLMIC TELEMATCH ALIANT 4.20M 80GR

LANSETA COLMIC TELEMATCH ALIANT 4.20M 80GR

caal90b
Stoc epuizat

410,00Lei

Mulineta DAM Quick 2 3000 FD

Mulineta DAM Quick 2 3000 FD

3020956967
Stoc epuizat

171,90Lei

Fir monofilament Maver Smart Stone River 0.14mm/5.5kg/150m - sinking

Fir monofilament Maver Smart Stone River 0.14mm/5.5kg/150m - sinking

654014
Stoc epuizat

28,00Lei

CAP MINCIOG MAVER MATCH TOP GREEN 50x40CM

CAP MINCIOG MAVER MATCH TOP GREEN 50x40CM

1974001
Stoc epuizat

121,00Lei

CAP MINCIOG MAVER MATCH SOFT 50x40CM

CAP MINCIOG MAVER MATCH SOFT 50x40CM

1970001
Stoc epuizat

96,00Lei

LANSETA COLMIC KIRA M1 MATCH 4.20M 25GR

LANSETA COLMIC KIRA M1 MATCH 4.20M 25GR

cbki01a
Stoc epuizat

915,00Lei

Cap de Minciog NGT Stationar 56x46x50cm

Cap de Minciog NGT Stationar 56x46x50cm

ngt-fnh-net-match-std
Stoc epuizat

42,00Lei

FIR TRABUCCO TF XPS MATCH STRONG 50mt/0,20mm

FIR TRABUCCO TF XPS MATCH STRONG 50mt/0,20mm

053-80-200
Stoc epuizat

20,00Lei

GEACA MAVER POLAR MATCH THIS XXXL -30%

GEACA MAVER POLAR MATCH THIS XXXL

n964
Stoc epuizat

373,01Lei(-30%) 261,00Lei

FIR JAXON SATORI MATCH 0.16mm 150m

FIR JAXON SATORI MATCH 0.16mm 150m

zj-sam016a
Stoc epuizat

17,50Lei

GEACA MAVER POLAR MATCH THIS XXL -30%

GEACA MAVER POLAR MATCH THIS XXL

n963
Stoc epuizat

373,01Lei(-30%) 261,00Lei

LANSETA TRABUCCO PULSE TELEMATCH 4.00M-80G

LANSETA TRABUCCO PULSE TELEMATCH 4.00M-80G

151-99-400
Stoc epuizat

180,00Lei

Afişare 881 - 900 din 1246 (63 pagini)
Queries: 5, Total time: 51.457 ms [By time] [By id] [By file]
1 (0.071)
SELECT data
FROM `oc_session`
WHERE session_id = 'd8b0f0a4a4fff1f70f15ec835e'
/var/www/clients/client1/web1/web/system/library/session/db.php:23
2 (0.111)
SELECT `trigger`, `action`
FROM oc_event
/var/www/clients/client1/web1/web/index.php:428
3 (45.985)
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('+match' 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 (5.166)
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 880, 20
/var/www/clients/client1/web1/web/catalog/model/catalog/product.php:184
5 (0.124)
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