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 - vu.2.5878

Produse ce potrivesc criteriilor de căutare


Tub Wireck Antirasucitor Feeder cu Agrafa 12cm

Tub Wireck Antirasucitor Feeder cu Agrafa 12cm

403320030
Stoc epuizat

2,65Lei

Agrafa Super Usoara STONFO 572, Nr.1, 10kg, 10buc/pac

Agrafa Super Usoara STONFO 572, Nr.1, 10kg, 10buc/pac

8028651015220
Stoc epuizat

13,99Lei

Tub Wireck Antirasucitor Feeder cu Agrafa 18cm

Tub Wireck Antirasucitor Feeder cu Agrafa 18cm

403320032
Stoc epuizat

2,55Lei

AGRAFA MUSTAD DUO LOCK NR.0/26KG/10BUC

AGRAFA MUSTAD DUO LOCK NR.0/26KG/10BUC

a7.ma028bn.0
Stoc epuizat

6,33Lei

Tub Wireck Antirasucitor Feeder cu Agrafa 20cm

Tub Wireck Antirasucitor Feeder cu Agrafa 20cm

403320033
Stoc epuizat

2,55Lei

Vartejuri cu agrafa rapida Select Baits Quick Change Swivels nr.8

Vartejuri cu agrafa rapida Select Baits Quick Change Swivels nr.8

sel-217986
Stoc epuizat

12,00Lei

Agrafa Sert XT Insurance Dubla Nr 2 30kg

Agrafa Sert XT Insurance Dubla Nr 2 30kg

412013004
Stoc epuizat

7,02Lei

Agrafa DAM Effzett Egg Snap S 20kg

Agrafa DAM Effzett Egg Snap S 20kg

40956378
Stoc epuizat

9,37Lei

AGRAFA RAPIDA PROLOGIC SPEED LINK LM, 15BUC/PLIC

AGRAFA RAPIDA PROLOGIC SPEED LINK LM, 15BUC/PLIC

a7.pro.49924
Stoc epuizat

22,50Lei

AGRAFA DECOY ROUND SNAP NR 1

AGRAFA DECOY ROUND SNAP NR 1

4989540810422
Stoc epuizat

13,99Lei

VARTEJ BARREL JAXON CU AGRAFA POWER NR 18 -31%

VARTEJ BARREL JAXON CU AGRAFA POWER NR 18

aj-ka10518c
Stoc epuizat

5,50Lei(-31%) 3,80Lei

VARTEJ BARREL JAXON CU AGRAFA POWER NR 16 -31%

VARTEJ BARREL JAXON CU AGRAFA POWER NR 16

aj-ka10516c
Stoc epuizat

5,50Lei(-31%) 3,80Lei

Vartej Spro Butoias Cu Agrafa Interlock Nr 10 10 Buc 14 Kg

Vartej Spro Butoias Cu Agrafa Interlock Nr 10 10 Buc 14 Kg

004551-00110-00000
Stoc epuizat

7,29Lei

VARTEJ ROLLING CU AGRAFA INTERLOCK CARP ZOOM nr.14

VARTEJ ROLLING CU AGRAFA INTERLOCK CARP ZOOM nr.14

cz5135
Stoc epuizat

5,00Lei

Agrafa Rapida NR 0 MAVER

Agrafa Rapida NR 0 MAVER

1495000
Stoc epuizat

9,50Lei

AGRAFA SPRO SECURE MATT BLACK NR 4 7 BUC 55 KG

AGRAFA SPRO SECURE MATT BLACK NR 4 7 BUC 55 KG

004620-00603-00000
Stoc epuizat

9,50Lei

Agrafa Rapida NR 1 MAVER

Agrafa Rapida NR 1 MAVER

1495001
Stoc epuizat

9,50Lei

Agrafa Rapida NR 3 MAVER

Agrafa Rapida NR 3 MAVER

1495003
Stoc epuizat

9,50Lei

Agrafa Rapida NR 2 MAVER

Agrafa Rapida NR 2 MAVER

1495002
Stoc epuizat

9,50Lei

MICRO AGRAFA SAVAGE 4KG 20BUC

MICRO AGRAFA SAVAGE 4KG 20BUC

a7.sg.54917
Stoc epuizat

8,48Lei

Afişare 1021 - 1040 din 1145 (58 pagini)
Queries: 8, Total time: 28.811 ms [By time] [By id] [By file]
1 (0.131)
SELECT data
FROM `oc_session`
WHERE session_id = '6b3c2fa9999b16dcdd7d969a6f'
/var/www/clients/client1/web1/web/system/library/session/db.php:23
2 (0.110)
SELECT `trigger`, `action`
FROM oc_event
/var/www/clients/client1/web1/web/index.php:428
3 (0.132)
SELECT *
FROM oc_url_alias
WHERE keyword = 'search'
/var/www/clients/client1/web1/web/catalog/controller/common/seo_url.php:48
4 (23.283)
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('+agrafa' 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 (4.762)
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 1020, 20
/var/www/clients/client1/web1/web/catalog/model/catalog/product.php:184
6 (0.138)
SELECT *
FROM oc_stock_status
WHERE furnizor LIKE '%"PRODUSE INACTIVE"%' AND language_id = '2'
/var/www/clients/client1/web1/web/catalog/model/catalog/product.php:130
7 (0.124)
SELECT *
FROM oc_stock_status
WHERE furnizor LIKE '%"PRODUSE INACTIVE"%' AND language_id = '2'
/var/www/clients/client1/web1/web/catalog/model/catalog/product.php:130
8 (0.131)
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