Pentru o livrare cat mai rapida va recomandam sa alegeti produse cu stoc in Magazin fizic si in Depozit Online. Produsele cu Stoc furnizor au termen de livrare mai mare si pot intarzia comanda dvs.
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 90 zile

Retur simplu in 90 zile.

Vezi mai multe detalii

Filtreaza

Briceag Umarex Walther Ctk1, Lama=78mm

Briceag Umarex Walther Ctk1, Lama=78mm

vu.5.1095
Livrare imediată!

97,10Lei

Briceag Marttiini Oy Mef8 Folding, Lama 8.5cm
Exclusiv online!

Briceag Marttiini Oy Mef8 Folding, Lama 8.5cm

r.m.970210
Livrare 24-48 ore

217,03Lei

Briceag Blaser Ultimate Carbon, Lama 7.7cm
Exclusiv online!

Briceag Blaser Ultimate Carbon, Lama 7.7cm

a8.bl.80414849
Livrare 24-48 ore

649,70Lei

Briceag Blaser Classic Brown, Lama 7.8cm + Husa Piele
Exclusiv online!

Briceag Blaser Classic Brown, Lama 7.8cm + Husa Piele

a8.bl.80414850
Livrare 24-48 ore

416,18Lei

Browning Briceag Tom Skinner Lama=91 Mm -20%

Browning Briceag Tom Skinner Lama=91 Mm

a8.bo.3220182
Stoc epuizat

202,11Lei(-20%) 160,91Lei

Cutit Pliabil Delphin Retro, Lama 7cm -47%

Cutit Pliabil Delphin Retro, Lama 7cm

950139001
Stoc epuizat

64,00Lei(-47%) 33,95Lei

Briceag Kershaw Brandywine, 3 Lame -41%

Briceag Kershaw Brandywine, 3 Lame

ks4382
Stoc epuizat

184,94Lei(-41%) 108,90Lei

Briceag Kershaw Natrix Copper Xl, Lama 9.4cm -41%

Briceag Kershaw Natrix Copper Xl, Lama 9.4cm

ks7008cu
Stoc epuizat

683,18Lei(-41%) 405,35Lei

Briceag Victorinox Electrician Alox, Argintiu, 9.30cm

Briceag Victorinox Electrician Alox, Argintiu, 9.30cm

0.8120.26
Stoc epuizat

230,70Lei

Briceag Victorinox Classic Precious Alox, Infinite Grey

Briceag Victorinox Classic Precious Alox, Infinite Grey

0.6221.4031g
Stoc epuizat

230,70Lei

Briceag Victorinox Classic Colors Transparent, Tuscan Sun - 0.6223.t81g

Briceag Victorinox Classic Colors Transparent, Tuscan Sun - 0.6223.t81g

0.6223.t81g
Stoc epuizat

123,93Lei

Briceag Victorinox Classic Colors Transparent, Cupcake Dream - 0.6223.t5g

Briceag Victorinox Classic Colors Transparent, Cupcake Dream - 0.6223.t5g

0.6223.t5g
Stoc epuizat

123,93Lei

Briceag Victorinox Classic Colors Transparent, Chocolate Fudge - 0.6223.t55g

Briceag Victorinox Classic Colors Transparent, Chocolate Fudge - 0.6223.t55g

0.6223.t55g
Stoc epuizat

123,93Lei

Briceag Victorinox Classic Alox, Sweet Berry

Briceag Victorinox Classic Alox, Sweet Berry

0.6221.201g
Stoc epuizat

176,81Lei

Briceag Victorinox Classic Alox, Minty Mint

Briceag Victorinox Classic Alox, Minty Mint

0.6221.221g
Stoc epuizat

176,81Lei

Briceag Victorinox Classic Alox, Cotton Candy

Briceag Victorinox Classic Alox, Cotton Candy

0.6221.252g
Stoc epuizat

176,81Lei

Briceag Multifunctional Victorinox, Nail Clip 580, 6.5cm, Edelweiss

Briceag Multifunctional Victorinox, Nail Clip 580, 6.5cm, Edelweiss

0.6463.840
Stoc epuizat

209,34Lei

Briceag Multifunctional Victorinox Workchamp Xl, Rosu, 11.10cm

Briceag Multifunctional Victorinox Workchamp Xl, Rosu, 11.10cm

0.8564.xl
Stoc epuizat

950,60Lei

Briceag Multifunctional Victorinox Equestrian, Rosu, 11.10cm

Briceag Multifunctional Victorinox Equestrian, Rosu, 11.10cm

0.8583
Stoc epuizat

261,20Lei

Briceag Cutit Pliabil Victorinox, Swissclassic Paring Knife, Lama Zimtata 11cm, Galben

Briceag Cutit Pliabil Victorinox, Swissclassic Paring Knife, Lama Zimtata 11cm, Galben

6.7836.f8b
Stoc epuizat

88,34Lei

Afişare 181 - 200 din 273 (14 pagini)

Descoperă gama noastră de bricege, ideale pentru camping, drumeții, pescuit și activități outdoor.
Alege un briceag multifuncțional, perfect pentru tăiere, ajustare și alte sarcini esențiale.
Modelele pliabile și compacte sunt ușor de transportat și depozitat în siguranță.
Bricegele tactice și de supraviețuire sunt fabricate din materiale rezistente pentru utilizare intensivă.
Lamele ascuțite din inox oferă precizie și durabilitate îndelungată.
Bricegele cu deschidere rapidă și sistem de blocare asigură siguranță maximă în utilizare.
Potrivite pentru pescari, vânători și aventurieri, aceste bricege sunt indispensabile în trusele de echipament.
Modelele cu design ergonomic oferă o prindere sigură și confortabilă.
Toate produsele sunt testate pentru fiabilitate și performanță în condiții extreme.
Alege un briceag de calitate și fii pregătit pentru orice provocare în aer liber!

Queries: 17, Total time: 13.240 ms [By time] [By id] [By file]
1 (0.095)
SELECT data
FROM `oc_session`
WHERE session_id = 'c17d8bae7cdd0f58ea46e4291a'
/var/www/clients/client1/web1/web/system/library/session/db.php:24
2 (0.082)
SELECT `trigger`, `action`
FROM oc_event
/var/www/clients/client1/web1/web/index.php:453
3 (0.105)
SELECT *
FROM oc_url_alias
WHERE keyword = 'camping'
/var/www/clients/client1/web1/web/catalog/controller/common/seo_url.php:48
4 (0.110)
SELECT *
FROM oc_url_alias
WHERE keyword = 'instrumente-pentru-taiat'
/var/www/clients/client1/web1/web/catalog/controller/common/seo_url.php:48
5 (0.094)
SELECT *
FROM oc_url_alias
WHERE keyword = 'bricege'
/var/www/clients/client1/web1/web/catalog/controller/common/seo_url.php:48
6 (0.425)
SELECT *
FROM oc_category c
LEFT JOIN oc_category_description cd ON (c.category_id = cd.category_id)
LEFT JOIN oc_category_to_store c2s ON (c.category_id = c2s.category_id)
WHERE c.parent_id = '802' AND cd.language_id = '2' AND c2s.store_id = '0' AND c.status = '1'
ORDER BY c.sort_order, LCASE(cd.name)
/var/www/clients/client1/web1/web/catalog/model/catalog/category.php:46
7 (6.734)
CREATE TEMPORARY TABLE oc_bf_tmp_product (PRIMARY KEY (`product_id`)) ENGINE=InnoDB 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_to_category` AS p2c ON (p.product_id = p2c.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 = '0' AND p2c.category_id = '802' 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:857
8 (0.172)
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:1593
9 (2.097)
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 DESC LIMIT 180, 20
/var/www/clients/client1/web1/web/catalog/model/catalog/product.php:184
10 (0.971)
SELECT a.attribute_group_id AS group_id, av.attribute_id AS attr_id, av.attribute_value_id AS val_id, ad.name AS attr_name, av.sort_order AS val_sort, av.value
FROM `oc_bf_product_attribute_value` AS af
INNER JOIN `oc_bf_tmp_product` AS p ON (af.product_id = p.product_id)
INNER JOIN `oc_bf_attribute_value` AS av ON (af.attribute_value_id = av.attribute_value_id)
INNER JOIN `oc_attribute` AS a ON (a.attribute_id = av.attribute_id)
INNER JOIN `oc_attribute_description` AS ad ON (ad.attribute_id = a.attribute_id)
WHERE ad.language_id = '2' AND av.language_id = '2' AND match_filters = 1 GROUP BY av.attribute_value_id
ORDER BY a.sort_order, ad.name, av.sort_order, CAST(av.value AS UNSIGNED), av.value
/var/www/clients/client1/web1/web/catalog/model/module/brainyfilter.php:1286
11 (0.336)
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:1393
12 (0.074)
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:1415
13 (0.142)
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:1180
14 (1.437)
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:1094
15 (0.148)
SELECT *
FROM `oc_pb_bundles`
WHERE `products` != '' AND `status`= '1' AND type = '1' AND `date_available` <= NOW() AND `customer_type` = 0 AND `categories_show` LIKE '%"802"%' LIMIT 0, 1000
/var/www/clients/client1/web1/web/catalog/model/module/productbundles.php:106
16 (0.133)
SELECT *
FROM `oc_pb_bundles`
WHERE `products` != '' AND `status`= '1' AND type = '0' AND `date_available` <= NOW() AND `customer_type` = 0 AND `categories_show` LIKE '%"802"%' LIMIT 0, 1000
/var/www/clients/client1/web1/web/catalog/model/module/product_recomandate.php:106
17 (0.085)
SELECT *
FROM `oc_mxt_setting`
WHERE store_id = '0' AND name = 'lichidare_stoc'
/var/www/clients/client1/web1/web/catalog/model/catalog/category.php:37