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


Rig Crap Orange No.26 Helicopter Grip 85gr

Rig Crap Orange No.26 Helicopter Grip 85gr

120241mf26185
Stoc epuizat

21,87Lei

Clonc Konger K-Lonk No.3, 38cm

Clonc Konger K-Lonk No.3, 38cm

42306960000180
Stoc epuizat

52,38Lei

Rig Crap Orange No.26 Helicopter Grip 85gr

Rig Crap Orange No.26 Helicopter Grip 85gr

120241mf26085
Stoc epuizat

21,87Lei

Carlige Legate Browning No.16 10 cm 0.22 mm Feeder Leader Method Push Stop
Carlige Legate Browning No.12 10 cm 0.22 mm Feeder Leader Method Push Stop
Ancora Zebco Topic Treble Hook Nickel No.6/0 2buc/pac -56%

Ancora Zebco Topic Treble Hook Nickel No.6/0 2buc/pac

707220011
Stoc epuizat

11,61Lei(-56%) 5,11Lei

Ancora Black Cat No.3/0 Curved Point Treble Hook DG Coating

Ancora Black Cat No.3/0 Curved Point Treble Hook DG Coating

4550300
Stoc epuizat

54,01Lei

Vartej DAM Effzett Diamond Rolling Swivels No.6 21kg

Vartej DAM Effzett Diamond Rolling Swivels No.6 21kg

40956387
Stoc epuizat

8,47Lei

Carlige Legate Zebco No.8 70 cm 0.20 mm Trophy Perch -32%

Carlige Legate Zebco No.8 70 cm 0.20 mm Trophy Perch

7174389008
Stoc epuizat

7,50Lei(-32%) 5,11Lei

Carlig Black Cat No.7/0 Ghost Rig Hook DG Coating

Carlig Black Cat No.7/0 Ghost Rig Hook DG Coating

1210224557700
Stoc epuizat

50,09Lei

Vartej DAM Effzett Diamond Rolling Swivels No.8 17kg

Vartej DAM Effzett Diamond Rolling Swivels No.8 17kg

40956386
Stoc epuizat

8,47Lei

Carlig Owner CF-3 No.7/0

Carlig Owner CF-3 No.7/0

12100256966-70
Stoc epuizat

33,03Lei

Vartej Zebco No.18 10mm Arched Swivel

Vartej Zebco No.18 10mm Arched Swivel

4176102018
Stoc epuizat

5,41Lei

Ancora Black Cat No.1/0 Treble Hook DG Coating

Ancora Black Cat No.1/0 Treble Hook DG Coating

4551100
Stoc epuizat

44,78Lei

Carlig Black Cat No.6/0 Rigging Hook DG Coating

Carlig Black Cat No.6/0 Rigging Hook DG Coating

4552600
Stoc epuizat

40,28Lei

Carlige Montate Zebco No.1/0 Z-Sea Shore Rig No.3

Carlige Montate Zebco No.1/0 Z-Sea Shore Rig No.3

4299042
Stoc epuizat

13,28Lei

Carlige Legate Browning No.13 100cm 0.16mm Sphere Beast

Carlige Legate Browning No.13 100cm 0.16mm Sphere Beast

4796013
Stoc epuizat

26,78Lei

Carlige Legate Browning No.8 100cm 0.20mm Sphere Beast

Carlige Legate Browning No.8 100cm 0.20mm Sphere Beast

1211154796008
Stoc epuizat

21,16Lei

Carlige Fanatik FX-31 No.10 Worm 8buc/plic

Carlige Fanatik FX-31 No.10 Worm 8buc/plic

120713ff3110
Stoc epuizat

5,50Lei

Carlige Legate Browning No.16 100cm 0.14mm Sphere Beast

Carlige Legate Browning No.16 100cm 0.14mm Sphere Beast

4796016
Stoc epuizat

26,78Lei

Afişare 681 - 700 din 760 (38 pagini)
Queries: 10, Total time: 682.035 ms [By time] [By id] [By file]
1 (0.107)
SELECT data
FROM `oc_session`
WHERE session_id = '956385a35c565f03529c3adce7'
/var/www/clients/client1/web1/web/system/library/session/db.php:23
2 (0.112)
SELECT `trigger`, `action`
FROM oc_event
/var/www/clients/client1/web1/web/index.php:428
3 (0.093)
SELECT *
FROM oc_url_alias
WHERE keyword = 'search'
/var/www/clients/client1/web1/web/catalog/controller/common/seo_url.php:48
4 (678.112)
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 (pd.tag LIKE "%no.%") 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 (3.159)
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 680, 20
/var/www/clients/client1/web1/web/catalog/model/catalog/product.php:184
6 (0.103)
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.081)
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.081)
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
9 (0.076)
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
10 (0.111)
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