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


CUTIT, MARTTIINI, WOOD, GROUSE, GIFT, BOX, LAMA=110, MM, r.m.549019w, Instrumente pentru Taiat, Instrumente pentru Taiat Marttiini, Marttiini
CUTIT MARTTIINI LYNX 132 LAMA=110MM
Exclusiv online!

CUTIT MARTTIINI LYNX 132 LAMA=110MM

r.m.132010
Livrare 24-48 ore

309,55Lei

CUTIT, MARTTIINI, KIERINKI, LAMA=110, MM, r.m.126010, Instrumente pentru Taiat, Instrumente pentru Taiat Marttiini, Marttiini
Exclusiv online!

CUTIT, MARTTIINI, KIERINKI, LAMA=110, MM, r.m.126010, Instrumente pentru Taiat, Instrumente pentru Taiat Marttiini, Marttiini

r.m.126010
Livrare 24-48 ore

546,36Lei

TOC ARROW INT. PIELE PENTRU BRICEAG
Exclusiv online!

TOC ARROW INT. PIELE PENTRU BRICEAG

ve.14.04
Livrare 24-48 ore

29,33Lei

CUTIT, MARTTIINI, LAPP, 230, LAMA, 110, MM, r.m.230010, Instrumente pentru Taiat, Instrumente pentru Taiat Marttiini, Marttiini
Exclusiv online!

CUTIT, MARTTIINI, LAPP, 230, LAMA, 110, MM, r.m.230010, Instrumente pentru Taiat, Instrumente pentru Taiat Marttiini, Marttiini

r.m.230010
Livrare 24-48 ore

336,65Lei

BRICEAG VERNEY-CARRON KING CAMO LAMA=120 MM
Exclusiv online!

BRICEAG VERNEY-CARRON KING CAMO LAMA=120 MM

a8.lvc.phac023
Livrare 24-48 ore

85,62Lei

BRICEAG VERNEY-CARRON KAISER CAMO LAMA 105MM
Exclusiv online!

BRICEAG VERNEY-CARRON KAISER CAMO LAMA 105MM

a8.lvc.phac022
Livrare 24-48 ore

77,36Lei

Cutit Browning Ignite Fixed Black Orange Lama 110mm

Cutit Browning Ignite Fixed Black Orange Lama 110mm

a8.bo.3220334
Livrare imediată!

180,01Lei

Briceag Walther Blue Wood Knife 7 Lama 104m
Exclusiv online!

Briceag Walther Blue Wood Knife 7 Lama 104m

vu.5.0854
Livrare 24-48 ore

238,30Lei

Cutit Vanatoare Browning Bjorn Maner Maslin Lama 11cm
Exclusiv online!

Cutit Vanatoare Browning Bjorn Maner Maslin Lama 11cm

a8.bo.3220416
Livrare 24-48 ore

337,51Lei

Cutit Browning Prohunter Rubber Black Lama 10cm

Cutit Browning Prohunter Rubber Black Lama 10cm

a8.bo.3220414
Livrare imediată!

191,26Lei

Briceag Walther RK2 Pro Lama 90mm
Exclusiv online!

Briceag Walther RK2 Pro Lama 90mm

vu.5.2012
Livrare 24-48 ore

215,68Lei

Cutit Umarex Multifunctional Walther FTK Lama 110mm -32%
Exclusiv online!

Cutit Umarex Multifunctional Walther FTK Lama 110mm

vu.5.0605
Livrare 24-48 ore

242,72Lei(-32%) 164,03Lei

Cutit Delphin SPLITER -44%

Cutit Delphin SPLITER

101001592
Stoc epuizat

48,00Lei(-44%) 27,00Lei

Briceag Bushmen Lucky, Lama 8.5cm

Briceag Bushmen Lucky, Lama 8.5cm

5902194520225
Stoc epuizat

75,01Lei

Cutit Kershaw pentru Filetat, Lama 15.9cm

Cutit Kershaw pentru Filetat, Lama 15.9cm

ks1258x
Stoc epuizat

180,00Lei

Briceag Bushmen Koliber, Lama 5cm

Briceag Bushmen Koliber, Lama 5cm

5902194520102
Stoc epuizat

35,00Lei

Briceag Bushmen Koliber, Lama 5cm

Briceag Bushmen Koliber, Lama 5cm

5902194520119
Stoc epuizat

35,00Lei

Cutit pentru Filetat Kershaw, Lama 17.8cm

Cutit pentru Filetat Kershaw, Lama 17.8cm

ks1257x
Stoc epuizat

110,00Lei

Cutit pentru Filetat Kershaw, Lama 19.1cm

Cutit pentru Filetat Kershaw, Lama 19.1cm

ks1247x
Stoc epuizat

130,00Lei

Afişare 561 - 580 din 1086 (55 pagini)
Queries: 16, Total time: 229.034 ms [By time] [By id] [By file]
1 (0.134)
SELECT data
FROM `oc_session`
WHERE session_id = '4501bb938250c68e122bee3205'
/var/www/clients/client1/web1/web/system/library/session/db.php:23
2 (0.125)
SELECT *
FROM oc_platforma_promovari LIMIT 1
/var/www/clients/client1/web1/web/index.php:128
3 (0.289)
SELECT tr1.tax_class_id, tr2.tax_rate_id, tr2.name, tr2.rate, tr2.type, tr1.priority
FROM oc_tax_rule tr1
LEFT JOIN oc_tax_rate tr2 ON (tr1.tax_rate_id = tr2.tax_rate_id)
INNER JOIN oc_tax_rate_to_customer_group tr2cg ON (tr2.tax_rate_id = tr2cg.tax_rate_id)
LEFT JOIN oc_zone_to_geo_zone z2gz ON (tr2.geo_zone_id = z2gz.geo_zone_id)
LEFT JOIN oc_geo_zone gz ON (tr2.geo_zone_id = gz.geo_zone_id)
WHERE tr1.based = 'shipping' AND tr2cg.customer_group_id = '1' AND z2gz.country_id = '175' AND (z2gz.zone_id = '0' OR z2gz.zone_id = '2688')
ORDER BY tr1.priority ASC
/var/www/clients/client1/web1/web/system/library/tax.php:32
4 (0.251)
SELECT tr1.tax_class_id, tr2.tax_rate_id, tr2.name, tr2.rate, tr2.type, tr1.priority
FROM oc_tax_rule tr1
LEFT JOIN oc_tax_rate tr2 ON (tr1.tax_rate_id = tr2.tax_rate_id)
INNER JOIN oc_tax_rate_to_customer_group tr2cg ON (tr2.tax_rate_id = tr2cg.tax_rate_id)
LEFT JOIN oc_zone_to_geo_zone z2gz ON (tr2.geo_zone_id = z2gz.geo_zone_id)
LEFT JOIN oc_geo_zone gz ON (tr2.geo_zone_id = gz.geo_zone_id)
WHERE tr1.based = 'store' AND tr2cg.customer_group_id = '1' AND z2gz.country_id = '175' AND (z2gz.zone_id = '0' OR z2gz.zone_id = '2688')
ORDER BY tr1.priority ASC
/var/www/clients/client1/web1/web/system/library/tax.php:60
5 (0.102)
SELECT `trigger`, `action`
FROM oc_event
/var/www/clients/client1/web1/web/index.php:422
6 (0.059)
DROP TEMPORARY TABLE IF EXISTS oc_bf_tmp_product
/var/www/clients/client1/web1/web/catalog/model/module/brainyfilter.php:692
7 (217.573)
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` GROUP BY tax_class_id) AS tx ON (p.tax_class_id = tx.tax_class_id)
WHERE p2s.store_id = '3' AND (pd.tag LIKE "%cutit%") 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:693
8 (0.168)
SELECT COUNT(1) AS total
FROM ( SELECT p.*
FROM `oc_bf_tmp_product` AS p
WHERE match_filters = 1) AS t
/var/www/clients/client1/web1/web/catalog/model/catalog/product.php:1547
9 (4.189)
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 560, 20
/var/www/clients/client1/web1/web/catalog/model/catalog/product.php:181
10 (0.853)
SELECT DISTINCT m.manufacturer_id AS id, CONCAT(UCASE(LEFT(m.name, 1)), LCASE(SUBSTRING(m.name, 2))) AS name
FROM `oc_manufacturer` AS m
INNER JOIN `oc_bf_tmp_product` AS p ON (m.manufacturer_id = p.manufacturer_id)
WHERE match_filters = 1
ORDER BY m.sort_order, m.name
/var/www/clients/client1/web1/web/catalog/model/module/brainyfilter.php:1204
11 (0.090)
SELECT stock_status_id AS id, name
FROM `oc_stock_status`
WHERE language_id = '2'
/var/www/clients/client1/web1/web/catalog/model/module/brainyfilter.php:1223
12 (0.228)
SELECT MIN(actual_price) AS min, MAX(actual_price) AS max
FROM `oc_bf_tmp_product` AS p
WHERE match_filters = 1
/var/www/clients/client1/web1/web/catalog/model/module/brainyfilter.php:978
13 (4.718)
SELECT COUNT(1) AS val, filter_group, filter_id
FROM `oc_bf_tmp_product` AS p
INNER JOIN `oc_bf_filter` AS f ON (p.product_id = f.product_id)
WHERE match_filters = 1 AND f.language_id = '2' GROUP BY filter_group, filter_id
/var/www/clients/client1/web1/web/catalog/model/module/brainyfilter.php:900
14 (0.087)
SELECT *
FROM oc_platforma_promovari
/var/www/clients/client1/web1/web/catalog/model/common/platforma.php:4
15 (0.082)
SELECT *
FROM oc_platforma_promovari
/var/www/clients/client1/web1/web/catalog/model/common/platforma.php:4
16 (0.086)
SELECT *
FROM `oc_mxt_setting`
WHERE store_id = '3' AND name = 'lichidare_stoc'
/var/www/clients/client1/web1/web/catalog/model/catalog/category.php:32