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 14 zile

Retur simplu in 14 zile.

Vezi mai multe detalii

Filtreaza

Brat Juvelnic Jaxon Pro Match 19cm
Exclusiv online!

Brat Juvelnic Jaxon Pro Match 19cm

ak-kze021
Livrare 48-72 ore

60,00Lei

Adaptor Carp Expert Scaun Vario

Adaptor Carp Expert Scaun Vario

77041248
Livrare imediată!

23,50Lei

Brat Juvelnic Carp Expert Pentru Fixare Modular Sau Scaun 20cm

Brat Juvelnic Carp Expert Pentru Fixare Modular Sau Scaun 20cm

77041244
Livrare imediată!

23,50Lei

Brat Carp Expert Curbat Suport Juvelnic 25cm
Exclusiv online!

Brat Carp Expert Curbat Suport Juvelnic 25cm

77041245
Livrare 24-48 ore

27,50Lei

Suport Mivardi Scurt Pentru Juvelnic Straight Holder Short 25-36mm

Suport Mivardi Scurt Pentru Juvelnic Straight Holder Short 25-36mm

m-sbashs2
Livrare imediată!

35,00Lei

Suport Pentru Juvelnic Shakespeare Skp Keepnet Adaptor 13cm -36%

Suport Pentru Juvelnic Shakespeare Skp Keepnet Adaptor 13cm

1552886
Livrare imediată!

34,95Lei(-36%) 22,40Lei

Suport Preston Offbox 36 Snaplock Tool Bar
Exclusiv online!

Suport Preston Offbox 36 Snaplock Tool Bar

p0110001
Livrare 7-14 zile

373,46Lei

Suport Preston Offbox 36 Mini Tool Bar

Suport Preston Offbox 36 Mini Tool Bar

p0110051
Livrare imediată!

184,46Lei

Suport Juvelnice Matrix Tool Bar Pro
Exclusiv online!

Suport Juvelnice Matrix Tool Bar Pro

gba063
Livrare 7-14 zile

427,46Lei

Brat Juveliv Trabucco Gnt X-connect Cross Keepnet Arm
Exclusiv online!

Brat Juveliv Trabucco Gnt X-connect Cross Keepnet Arm

116-26-060
Livrare 48-72 ore

85,00Lei

Adaptor Suport Juvelnic Benzar Triple Holder Adapter
Exclusiv online!

Adaptor Suport Juvelnic Benzar Triple Holder Adapter

75045452
Livrare 24-48 ore

275,00Lei

Suport Juvelnic Rive D36 Clip One Ring

Suport Juvelnic Rive D36 Clip One Ring

90810104020
Livrare imediată!

92,55Lei

Brate Xl Pentru Suport Juvelnice Matrix Tool Bar Pro
Exclusiv online!

Brate Xl Pentru Suport Juvelnice Matrix Tool Bar Pro

gba065
Livrare 7-14 zile

107,96Lei

Suport Juvelnic Maver Long, Black -20%

Suport Juvelnic Maver Long, Black

1890002
Livrare imediată!

39,00Lei(-20%) 31,20Lei

Brat Suport Juvelnic Nufish Nfx12 -36%

Brat Suport Juvelnic Nufish Nfx12

nfx12
Stoc epuizat

95,00Lei(-36%) 60,93Lei

Brat Juvelnic Trabucco Xps Clamp 36 Easy Switch -17%

Brat Juvelnic Trabucco Xps Clamp 36 Easy Switch

086-19-110
Stoc epuizat

49,00Lei(-17%) 40,46Lei

Suport Juvelnic Nytro Connect-it X36 Keepnet Arm Short

Suport Juvelnic Nytro Connect-it X36 Keepnet Arm Short

21000032
Stoc epuizat

65,78Lei

Suport Juvelnic Matrix Mini Tool Bar Pro, Pentru Scaun Modular

Suport Juvelnic Matrix Mini Tool Bar Pro, Pentru Scaun Modular

gba064
Stoc epuizat

215,96Lei

Brat Suport Juvelnic Trabucco Qr 3x

Brat Suport Juvelnic Trabucco Qr 3x

116-11-110
Stoc epuizat

270,00Lei

Afişare 21 - 39 din 39 (2 pagini)

Optimizează-ți echipamentul cu brate suport juvelnic pentru scaune de feeder, special concepute pentru o fixare stabilă și sigură.
Alege brat lateral juvelnic feeder compatibil cu scaune station sau modulare.
Utilizează brate telescopice sau extensibile pentru juvelnic, ușor de reglat și montat.
Perfecte pentru susținerea juvelnicelor rectangulare sau circulare în timpul partidelor de pescuit.
Bratele suport feeder juvelnic sunt prevăzute cu sistem de prindere rapidă și filet universal.
Realizate din materiale rezistente, oferă durabilitate și confort în utilizare.
Accesoriile feeder pentru juvelnic sunt ideale pentru pescuit de competiție sau recreativ.
Fixează ușor juvelnicul în poziția dorită cu ajutorul bratelor modulare sau rotative.
Compatibile cu majoritatea scaunelor feeder de pe piață.
Alege brat suport juvelnic feeder profesional pentru eficiență maximă la malul apei!

Queries: 15, Total time: 4.462 ms [By time] [By id] [By file]
1 (0.136)
SELECT data
FROM `oc_session`
WHERE session_id = 'd5edec7bb6539b6407f4b8d98c'
/var/www/clients/client1/web1/web/system/library/session/db.php:24
2 (0.130)
SELECT `trigger`, `action`
FROM oc_event
/var/www/clients/client1/web1/web/index.php:453
3 (0.121)
SELECT *
FROM oc_url_alias
WHERE keyword = 'brate-suport-juvelnic'
/var/www/clients/client1/web1/web/catalog/controller/common/seo_url.php:48
4 (0.502)
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 = '617' AND cd.language_id = '2' AND c2s.store_id = '2' AND c.status = '1'
ORDER BY c.sort_order, LCASE(cd.name)
/var/www/clients/client1/web1/web/catalog/model/catalog/category.php:46
5 (1.206)
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`) AS tx ON (p.tax_class_id = tx.tax_class_id)
WHERE p2s.store_id = '2' AND p2c.category_id = '617' 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
6 (0.087)
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
7 (0.350)
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 20, 20
/var/www/clients/client1/web1/web/catalog/model/catalog/product.php:184
8 (0.653)
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
9 (0.215)
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
10 (0.114)
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
11 (0.105)
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
12 (0.409)
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
13 (0.167)
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 '%"617"%' LIMIT 0, 1000
/var/www/clients/client1/web1/web/catalog/model/module/productbundles.php:106
14 (0.157)
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 '%"617"%' LIMIT 0, 1000
/var/www/clients/client1/web1/web/catalog/model/module/product_recomandate.php:106
15 (0.110)
SELECT *
FROM `oc_mxt_setting`
WHERE store_id = '2' AND name = 'lichidare_stoc'
/var/www/clients/client1/web1/web/catalog/model/catalog/category.php:37