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


FIR MONOFILAMENT GAMAKATSU G-LINE COMPETITION 018MM/3,40KG/100M

FIR MONOFILAMENT GAMAKATSU G-LINE COMPETITION 018MM/3,40KG/100M

gk.5076.018
Stoc epuizat

28,26Lei

FIR MONOFILAMENT CARBOTEX 027MM/9,95KG/100M

FIR MONOFILAMENT CARBOTEX 027MM/9,95KG/100M

e.4800.027
Stoc epuizat

13,11Lei

FIR MONOFILAMENT MAVER SMART ELITE FLUOROCARBON 100M 0.125MM

FIR MONOFILAMENT MAVER SMART ELITE FLUOROCARBON 100M 0.125MM

725125
Stoc epuizat

28,00Lei

FIR MONOFILAMENT GAMAKATSU G-LINE COMPETITION 010MM/1,30KG/100M

FIR MONOFILAMENT GAMAKATSU G-LINE COMPETITION 010MM/1,30KG/100M

gk.5076.010
Stoc epuizat

25,92Lei

Fir ASSO Ultra Soft Copper 0.18mm

Fir ASSO Ultra Soft Copper 0.18mm

604080011
Stoc epuizat

19,93Lei

Fir Carp Expert Carbon 0.32mm 300m

Fir Carp Expert Carbon 0.32mm 300m

30101032
Stoc epuizat

20,00Lei

FIR COLMIC MIMETIX 0.158MM 50M

FIR COLMIC MIMETIX 0.158MM 50M

nymi158
Stoc epuizat

30,00Lei

FIR MONOFILAMENT MAVER SMART DUAL BAND 600M 0.25MM

FIR MONOFILAMENT MAVER SMART DUAL BAND 600M 0.25MM

626025
Stoc epuizat

63,00Lei

FIR MAGIC TEAM MASTER RIG LINE 50M 0.20MM 4.8KG

FIR MAGIC TEAM MASTER RIG LINE 50M 0.20MM 4.8KG

9064
Stoc epuizat

5,70Lei

Fir Fluorocarbon Colmic Seaguar Secol PowerF 0.185mm 50m

Fir Fluorocarbon Colmic Seaguar Secol PowerF 0.185mm 50m

nysc185
Stoc epuizat

103,99Lei

Fir Browning Cenex Low Stretch Mono 0.16mm 150m

Fir Browning Cenex Low Stretch Mono 0.16mm 150m

6152231016
Stoc epuizat

38,12Lei

Fir Energo Team Excalibur Carp Fluoro Carbon Coated 200m 0.14mm

Fir Energo Team Excalibur Carp Fluoro Carbon Coated 200m 0.14mm

34055014
Stoc epuizat

16,01Lei

FIR MAGIC TEAM MASTER RIG LINE 50M 0.18MM 4.2KG

FIR MAGIC TEAM MASTER RIG LINE 50M 0.18MM 4.2KG

9063
Stoc epuizat

5,70Lei

FIR MONOFILAMENT MAVER SMART SLR 50M 0.10MM

FIR MONOFILAMENT MAVER SMART SLR 50M 0.10MM

621010
Stoc epuizat

32,00Lei

FIR MONOFILAMENT GAMAKATSU G-LINE NEO 024MM/5,3KG/150M

FIR MONOFILAMENT GAMAKATSU G-LINE NEO 024MM/5,3KG/150M

gk.5137.024
Stoc epuizat

39,60Lei

Fir Fluorocarbon Colmic Seaguar Secol PowerF 0.165mm 50m

Fir Fluorocarbon Colmic Seaguar Secol PowerF 0.165mm 50m

nysc165
Stoc epuizat

103,99Lei

Fir ASSO Ultra Low Stretch Smoke 0.26mm 150m

Fir ASSO Ultra Low Stretch Smoke 0.26mm 150m

607080017
Stoc epuizat

34,55Lei

Fir Fluorocarbon Colmic Seaguar Secol PowerF 0.205mm 50m

Fir Fluorocarbon Colmic Seaguar Secol PowerF 0.205mm 50m

nysc205
Stoc epuizat

103,99Lei

Fir Browning Cenex Low Stretch Mono 0.14mm 150m

Fir Browning Cenex Low Stretch Mono 0.14mm 150m

6152231014
Stoc epuizat

37,03Lei

Fir Fluorocarbon Colmic Seaguar Secol PowerF 0.148mm 50m

Fir Fluorocarbon Colmic Seaguar Secol PowerF 0.148mm 50m

nysc148
Stoc epuizat

103,99Lei

Afişare 1301 - 1320 din 1426 (72 pagini)
Queries: 6, Total time: 49.745 ms [By time] [By id] [By file]
1 (0.143)
SELECT data
FROM `oc_session`
WHERE session_id = '762c2e8cff9085222871e88413'
/var/www/clients/client1/web1/web/system/library/session/db.php:23
2 (0.115)
SELECT `trigger`, `action`
FROM oc_event
/var/www/clients/client1/web1/web/index.php:428
3 (0.125)
SELECT *
FROM oc_url_alias
WHERE keyword = 'search'
/var/www/clients/client1/web1/web/catalog/controller/common/seo_url.php:48
4 (43.611)
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('+fire +varga +bolo' 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 (5.616)
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 1300, 20
/var/www/clients/client1/web1/web/catalog/model/catalog/product.php:184
6 (0.135)
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