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 - GOVERNOR

Produse ce potrivesc criteriilor de căutare


PELETE JAXON METHOD FEEDER READY FISH MIX 2mm 500g

PELETE JAXON METHOD FEEDER READY FISH MIX 2mm 500g

fm-pr10
Stoc epuizat

29,00Lei

SUPORT JAXON METHOD FEEDER 48CM

SUPORT JAXON METHOD FEEDER 48CM

pz-stf003
Stoc epuizat

66,00Lei

ROTATIVA JAXON REDER 0 OR 1.5GR

ROTATIVA JAXON REDER 0 OR 1.5GR

bl-pre0or
Stoc epuizat

19,50Lei

VOBLER JAXON ATRACT FS XXT-G D 8CM 11GR 0.6-2.8M

VOBLER JAXON ATRACT FS XXT-G D 8CM 11GR 0.6-2.8M

vr-tg080d
Stoc epuizat

23,00Lei

JIG JAXON SUMATO BLACK 8/0 15GR

JIG JAXON SUMATO BLACK 8/0 15GR

gj-sb8/015b
Stoc epuizat

17,01Lei

VOBLER JAXON HORN F U 7CM-7GR -30%

VOBLER JAXON HORN F U 7CM-7GR

vj-h07fu
Stoc epuizat

30,00Lei(-30%) 21,00Lei

LINGURITA OSCILANTA JAXON HR ATLAS 1G, 10GR

LINGURITA OSCILANTA JAXON HR ATLAS 1G, 10GR

bw-hnx1g
Stoc epuizat

7,00Lei

VOBLER FIGHTER SDR O 5CM-6GR -30%

VOBLER FIGHTER SDR O 5CM-6GR

vj-fa5sdro
Stoc epuizat

23,00Lei(-30%) 16,10Lei

VOBLER JAXON ATRACT ATRIS F C 6.5CM 8GR

VOBLER JAXON ATRACT ATRIS F C 6.5CM 8GR

vr-xhf065c
Stoc epuizat

13,99Lei

LINGURA JAXON KARAS SCOT 2R 18GR

LINGURA JAXON KARAS SCOT 2R 18GR

bw-jkb2r
Stoc epuizat

20,00Lei

LINGURA JAXON TURBO CAST 15GR 1G

LINGURA JAXON TURBO CAST 15GR 1G

bw-hf1g
Stoc epuizat

13,99Lei

LINGURA JAXON UKLA F 3D 28GR -30%

LINGURA JAXON UKLA F 3D 28GR

bw-juf3d
Stoc epuizat

13,99Lei(-30%) 9,81Lei

VOBLER JAXON ATRACT FS XXT-G F 8CM 11GR 0.6-2.8M

VOBLER JAXON ATRACT FS XXT-G F 8CM 11GR 0.6-2.8M

vr-tg080f
Stoc epuizat

23,00Lei

GRUB JAXON INTENSA INT 4CM H

GRUB JAXON INTENSA INT 4CM H

tg-int038h
Stoc epuizat

12,00Lei

LINGURA JAXON HR VECTRA 1F 12GR

LINGURA JAXON HR VECTRA 1F 12GR

bw-hfx1f
Stoc epuizat

7,00Lei

LINGURA JAXON UKLA F 3A 28GR -30%

LINGURA JAXON UKLA F 3A 28GR

bw-juf3a
Stoc epuizat

13,99Lei(-30%) 9,81Lei

VOBLER JAXON ATRACT ATRIS F B 6.5CM 8GR

VOBLER JAXON ATRACT ATRIS F B 6.5CM 8GR

vr-xhf065b
Stoc epuizat

13,99Lei

LINGURA JAXON KARAS NATURAL 3NUL 24GR

LINGURA JAXON KARAS NATURAL 3NUL 24GR

bw-jka3nul
Stoc epuizat

17,01Lei

CARLIGE JAXON SUMATO YAMAME NR 5 NEGRU

CARLIGE JAXON SUMATO YAMAME NR 5 NEGRU

hy-hpb05
Stoc epuizat

4,00Lei

LINGURA JAXON KARAS SCOT 3F 24GR

LINGURA JAXON KARAS SCOT 3F 24GR

bw-jkb3f
Stoc epuizat

21,00Lei

Afişare 6381 - 6400 din 6616 (331 pagini)
Queries: 6, Total time: 157.729 ms [By time] [By id] [By file]
1 (0.118)
SELECT data
FROM `oc_session`
WHERE session_id = '72377410d27543445beee8bad3'
/var/www/clients/client1/web1/web/system/library/session/db.php:24
2 (0.073)
SELECT `trigger`, `action`
FROM oc_event
/var/www/clients/client1/web1/web/index.php:428
3 (0.078)
SELECT *
FROM oc_url_alias
WHERE keyword = 'search'
/var/www/clients/client1/web1/web/catalog/controller/common/seo_url.php:48
4 (132.767)
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 (24.544)
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 6380, 20
/var/www/clients/client1/web1/web/catalog/model/catalog/product.php:184
6 (0.149)
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