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 - vu.2.5878

Produse ce potrivesc criteriilor de căutare


MORMISTE JAXON WOLFRAM PA05 C 1.5G
Exclusiv online!

MORMISTE JAXON WOLFRAM PA05 C 1.5G

mw-pa050c
Livrare 48-72 ore

140,00Lei

PLUTA CULISANTA JAXON BFF STICK BULB 4 4.00GR
Exclusiv online!

PLUTA CULISANTA JAXON BFF STICK BULB 4 4.00GR

bx25003840
Livrare 48-72 ore

5,50Lei

ROTATIVA JAXON HOLO REFLEX SWING 3K 11GR

ROTATIVA JAXON HOLO REFLEX SWING 3K 11GR

bo-hxf3k
Livrare imediată!

9,00Lei

JIG JAXON SUMATO SILVER 2-4GR 5/PLIC

JIG JAXON SUMATO SILVER 2-4GR 5/PLIC

gj-su0204n
Livrare imediată!

12,00Lei

PLUMBI PICATURA JAXON INLINE 6GR

PLUMBI PICATURA JAXON INLINE 6GR

cc-af6g
Livrare imediată!

7,00Lei

VOBLER JAXON HS CARABUS F LT 3CM 1.5GR
Exclusiv online!

VOBLER JAXON HS CARABUS F LT 3CM 1.5GR

vj-sh03flt
Livrare 48-72 ore

35,00Lei

CARLIGE JAXON SUMATO KAIZU NR 4 10/PLIC
Exclusiv online!

CARLIGE JAXON SUMATO KAIZU NR 4 10/PLIC

hy-hsa04
Livrare 48-72 ore

4,00Lei

INEL JAXON CULISANT NR 8 4.5MM
Exclusiv online!

INEL JAXON CULISANT NR 8 4.5MM

ok-11845
Livrare 48-72 ore

21,00Lei

LINGURA JAXON TURBO CAST 3G 41GR
Exclusiv online!

LINGURA JAXON TURBO CAST 3G 41GR

bw-hf3g
Livrare 48-72 ore

19,00Lei

OCHELARI JAXON POLARIZANTI X44 SM GRI

OCHELARI JAXON POLARIZANTI X44 SM GRI

ak-okx44sm
Livrare imediată!

52,00Lei

ROTATIVA JAXON REDER 3 OR 7GR
Exclusiv online!

ROTATIVA JAXON REDER 3 OR 7GR

bl-pre3or
Livrare 48-72 ore

24,00Lei

VARF JAXON FEEDER GLASS 3.8mm 50cm Strong
Exclusiv online!

VARF JAXON FEEDER GLASS 3.8mm 50cm Strong

ak-sws380c
Livrare 48-72 ore

25,00Lei

CARLIGE JAXON LEGATE SUMATO KEIRYU NR 6 0,20 MM

CARLIGE JAXON LEGATE SUMATO KEIRYU NR 6 0,20 MM

hy-sia06
Livrare imediată!

8,00Lei

Fir Monofilament Jaxon INTENSA PREMIUM 0.08mm 25m
Exclusiv online!

Fir Monofilament Jaxon INTENSA PREMIUM 0.08mm 25m

zj-inp008c
Livrare 48-72 ore

7,00Lei

HUSA JAXON LANSETE X-TEAM SPINNING 135CM
Exclusiv online!

HUSA JAXON LANSETE X-TEAM SPINNING 135CM

uj-xag135
Livrare 48-72 ore

115,00Lei

JIG TANAMI JAXON BLACK NICHEL 3/0-4GR
Exclusiv online!

JIG TANAMI JAXON BLACK NICHEL 3/0-4GR

ho-gb3/004
Livrare 48-72 ore

28,00Lei

JIG TANAMI JAXON BLACK NICKEL 3/0-20GR
Exclusiv online!

JIG TANAMI JAXON BLACK NICKEL 3/0-20GR

ho-gb3/020
Livrare 48-72 ore

46,01Lei

LINGURA JAXON HR VECTRA 1D 12GR
Exclusiv online!

LINGURA JAXON HR VECTRA 1D 12GR

bw-hfx1d
Livrare 48-72 ore

7,00Lei

MOMITOR JAXON METHOD FEEDER C1 80GR
Exclusiv online!

MOMITOR JAXON METHOD FEEDER C1 80GR

af-c180
Livrare 48-72 ore

35,00Lei

PORTOFEL JAXON LEADERS 25CM
Exclusiv online!

PORTOFEL JAXON LEADERS 25CM

ak-dr910
Livrare 48-72 ore

58,00Lei

Afişare 3901 - 3920 din 6621 (332 pagini)
Queries: 6, Total time: 172.894 ms [By time] [By id] [By file]
1 (0.118)
SELECT data
FROM `oc_session`
WHERE session_id = 'a4189406a7bf7e798573f2f77d'
/var/www/clients/client1/web1/web/system/library/session/db.php:23
2 (0.123)
SELECT `trigger`, `action`
FROM oc_event
/var/www/clients/client1/web1/web/index.php:428
3 (0.128)
SELECT *
FROM oc_url_alias
WHERE keyword = 'search'
/var/www/clients/client1/web1/web/catalog/controller/common/seo_url.php:48
4 (148.467)
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('+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
5 (23.891)
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 3900, 20
/var/www/clients/client1/web1/web/catalog/model/catalog/product.php:184
6 (0.167)
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