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


MORMISTE JAXON WOLFRAM KD03 D 0.32 cm

MORMISTE JAXON WOLFRAM KD03 D 0.32 cm

mw-kd03d
Stoc epuizat

72,00Lei

SAPCA JAXON Z 2 -30%

SAPCA JAXON Z 2

uj-cz02
Stoc epuizat

15,01Lei(-30%) 10,50Lei

SWINGER JAXON BRAN GALBEN -30%

SWINGER JAXON BRAN GALBEN

aj-sys105d
Stoc epuizat

46,01Lei(-30%) 32,20Lei

CICADA JAXON TARLON 6.5GR 3C -30%

CICADA JAXON TARLON 6.5GR 3C

bw-hj3c
Stoc epuizat

9,00Lei(-30%) 6,30Lei

MINCIOG JAXON BARCA OVAL 55x65CM 3.0M

MINCIOG JAXON BARCA OVAL 55x65CM 3.0M

pl-acd1300f
Stoc epuizat

159,00Lei

PELERINA PLOAIE JAXON NEPTUN XXL

PELERINA PLOAIE JAXON NEPTUN XXL

uj-apxxl
Stoc epuizat

139,00Lei

SURUB JAXON BOILIE CLIP OPEN GALBEN

SURUB JAXON BOILIE CLIP OPEN GALBEN

ac-pc103c
Stoc epuizat

4,50Lei

FIR JAXON CROCODILE GREEN 150m 0.18mm -23%

FIR JAXON CROCODILE GREEN 150m 0.18mm

zj-crg018a
Stoc epuizat

9,00Lei(-23%) 6,90Lei

TUB OVAL JAXON 155CM 5.00Cmx7.00Cm

TUB OVAL JAXON 155CM 5.00Cmx7.00Cm

aj-tu5070155v
Stoc epuizat

79,00Lei

CICADA JAXON TARLON 6.5GR 3E -30%

CICADA JAXON TARLON 6.5GR 3E

bw-hj3e
Stoc epuizat

9,00Lei(-30%) 6,30Lei

SCAUN JAXON PLIANT HEAVY DUTY 35x30x43cm

SCAUN JAXON PLIANT HEAVY DUTY 35x30x43cm

ak-kzy101
Stoc epuizat

118,00Lei

ANCORA JAXON SUMATO SILVER PS NR 5/0

ANCORA JAXON SUMATO SILVER PS NR 5/0

hy-kb5/0ps
Stoc epuizat

42,00Lei

BRELOC JAXON

BRELOC JAXON

aj-ft013
Stoc epuizat

37,00Lei

DANDINETA JAXON LA 2C 7.5GR 6.1 cm

DANDINETA JAXON LA 2C 7.5GR 6.1 cm

bp-la2c
Stoc epuizat

11,50Lei

TUB PROTECTIE NOD JAXON 40mm Verde

TUB PROTECTIE NOD JAXON 40mm Verde

ac-pc123cm
Stoc epuizat

9,00Lei

CARABINA JAXON SAFETY NR 2

CARABINA JAXON SAFETY NR 2

aj-ag10102c
Stoc epuizat

2,50Lei

CAP MINCIOG JAXON ROTUND CURBAT 6MM 40X50CM

CAP MINCIOG JAXON ROTUND CURBAT 6MM 40X50CM

ps-lxe5040
Stoc epuizat

76,01Lei

MULINETA JAXON MAGNET CARP FRXL 300 3RUL

MULINETA JAXON MAGNET CARP FRXL 300 3RUL

kj-mca300xl
Stoc epuizat

250,99Lei

FIR TEXTIL JAXON MONOLITH FLUO 125m 0.10mm

FIR TEXTIL JAXON MONOLITH FLUO 125m 0.10mm

zj-gof010g
Stoc epuizat

110,00Lei

CUTIE PLUMBI COLMIC 3 ALICE 6 COMPARTIMENTE 90gr

CUTIE PLUMBI COLMIC 3 ALICE 6 COMPARTIMENTE 90gr

pomap3
Stoc epuizat

32,00Lei

Afişare 2661 - 2680 din 6627 (332 pagini)
Queries: 7, Total time: 172.042 ms [By time] [By id] [By file]
1 (0.100)
SELECT data
FROM `oc_session`
WHERE session_id = 'c32edd55fee5cce3ca5cbcd710'
/var/www/clients/client1/web1/web/system/library/session/db.php:23
2 (0.078)
SELECT `trigger`, `action`
FROM oc_event
/var/www/clients/client1/web1/web/index.php:428
3 (147.616)
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 = '3' AND (MATCH(pd.tag) AGAINST('+jaxon' 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 (23.920)
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 2660, 20
/var/www/clients/client1/web1/web/catalog/model/catalog/product.php:184
5 (0.130)
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.095)
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
7 (0.103)
SELECT *
FROM `oc_mxt_setting`
WHERE store_id = '3' AND name = 'lichidare_stoc'
/var/www/clients/client1/web1/web/catalog/model/catalog/category.php:38