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


ANCORA JAXON CU ZIRCON NR 10 C

ANCORA JAXON CU ZIRCON NR 10 C

mp-hk10c
Stoc epuizat

4,50Lei

BUZ BAR JAXON 3 POSTURI TELE 40-60CM

BUZ BAR JAXON 3 POSTURI TELE 40-60CM

pz-prb40
Stoc epuizat

105,01Lei

MULINETA JAXON PIANO VM 200

MULINETA JAXON PIANO VM 200

kj-pvm200
Stoc epuizat

80,00Lei

LANSETA JAXON IMPRESS GTX SPIN 2.70M/2SEG 15-40GR -30%

LANSETA JAXON IMPRESS GTX SPIN 2.70M/2SEG 15-40GR

wj-imx27040
Stoc epuizat

511,00Lei(-30%) 357,00Lei

AVERTIZOR JAXON XTR CARP LIBRA 5B ALBASTRU

AVERTIZOR JAXON XTR CARP LIBRA 5B ALBASTRU

aj-sya105b
Stoc epuizat

99,00Lei

LINGURA JAXON GHEATA 90MM

LINGURA JAXON GHEATA 90MM

ak-ica003
Stoc epuizat

20,00Lei

MULINETA JAXON TOP CARP FRT 300 3RUL

MULINETA JAXON TOP CARP FRT 300 3RUL

kj-tcb300
Stoc epuizat

135,01Lei

MULINETA JAXON PIANO VM 500

MULINETA JAXON PIANO VM 500

kj-pvm500
Stoc epuizat

89,00Lei

HUSA JAXON LANSETE 2 COMPARTIMENTE 125CM

HUSA JAXON LANSETE 2 COMPARTIMENTE 125CM

um-pob125
Stoc epuizat

199,00Lei

UMBRELA PVC CU PARASOLAR JAXON 125C 250CM

UMBRELA PVC CU PARASOLAR JAXON 125C 250CM

ak-plx125c
Stoc epuizat

423,00Lei

JUVELNIC JAXON MEDIUM 6MM 40x200CM

JUVELNIC JAXON MEDIUM 6MM 40x200CM

ps-jlb2006
Stoc epuizat

80,00Lei

CRACAN JAXON BAT VARF CUI V TELE 65-105CM

CRACAN JAXON BAT VARF CUI V TELE 65-105CM

al-65105b
Stoc epuizat

37,00Lei

LINGURA JAXON ALAN 4C 35GR

LINGURA JAXON ALAN 4C 35GR

bw-hw4c
Stoc epuizat

10,50Lei

CUTIE PLUMBI COLMIC ALICE SOFT 30gr Nr.11 0.028gr

CUTIE PLUMBI COLMIC ALICE SOFT 30gr Nr.11 0.028gr

pobb111
Stoc epuizat

12,99Lei

INEL CULISANT JAXON NR 4 2.4MM

INEL CULISANT JAXON NR 4 2.4MM

ok-11424
Stoc epuizat

21,00Lei

ANCORA JAXON SUMATO BRONZ BR NR 8

ANCORA JAXON SUMATO BRONZ BR NR 8

hy-ka08br
Stoc epuizat

15,01Lei

FIR JAXON CROCODILE CARP 600m 0.27mm

FIR JAXON CROCODILE CARP 600m 0.27mm

zj-crc027d
Stoc epuizat

40,00Lei

SET LADA JAXON CU RUCSAC

SET LADA JAXON CU RUCSAC

rh-178
Stoc epuizat

420,00Lei

Fir Textil Jaxon Sumato Catfish 1000m, 0.36mm, 41kg

Fir Textil Jaxon Sumato Catfish 1000m, 0.36mm, 41kg

zj-rac036x
Stoc epuizat

536,00Lei

CUTIT JAXON FILETAT 30CM

CUTIT JAXON FILETAT 30CM

aj-ns04a
Stoc epuizat

30,00Lei

Afişare 2241 - 2260 din 6621 (332 pagini)
Queries: 5, Total time: 188.098 ms [By time] [By id] [By file]
1 (0.075)
SELECT data
FROM `oc_session`
WHERE session_id = '7cd9c89f79a85ea0db053dacad'
/var/www/clients/client1/web1/web/system/library/session/db.php:23
2 (0.126)
SELECT `trigger`, `action`
FROM oc_event
/var/www/clients/client1/web1/web/index.php:428
3 (159.834)
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 (27.933)
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 2240, 20
/var/www/clients/client1/web1/web/catalog/model/catalog/product.php:184
5 (0.130)
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