Varivas

Varivas

Sortare după:

MANUSI VARIVAS STRETCH FIT 3 LL RED

MANUSI VARIVAS STRETCH FIT 3 LL RED

vag22rell

Livrare 48-72 ore

242,90Lei

Fir Monofilament Varivas Hard Top Fluorocarbon Leader 30m 0.370mm 10.3kg

Fir Monofilament Varivas Hard Top Fluorocarbon Leader 30m 0.370mm 10.3kg

v2825050

Livrare 48-72 ore

82,24Lei

Carlige Varivas Offset Master Monster Class Nr.1

Carlige Varivas Offset Master Monster Class Nr.1

v7042001

Livrare 48-72 ore

19,20Lei

Fir Fluorocarbon Varivas Shockleader Super Trout Area VSP, 0.148mm, 4lbs, 30m

Fir Fluorocarbon Varivas Shockleader Super Trout Area VSP, 0.148mm, 4lbs, 30m

v45703008

Livrare 48-72 ore

76,15Lei

Breloc Varivas Floating Vaac-62, Black, 1buc/pac

Breloc Varivas Floating Vaac-62, Black, 1buc/pac

v125835

Livrare 48-72 ore

77,16Lei

Inaintas Varivas Fly Tapered Leader Standard ST 3x12FT, 0.205mm-0.51mm, 10.95m, 3buc/pac

Inaintas Varivas Fly Tapered Leader Standard ST 3x12FT, 0.205mm-0.51mm, 10.95m, 3buc/pac

v117311

Livrare 48-72 ore

13,10Lei

FIR MONOFILAMENT VARIVAS TROUT SHOCKLEADER FLUOROCARBON 30M 0.235MM 8LB

FIR MONOFILAMENT VARIVAS TROUT SHOCKLEADER FLUOROCARBON 30M 0.235MM 8LB

v35908

Livrare 48-72 ore

61,92Lei

CARLIGE VARIVAS FLY 2200 2X-3X FINE NR 20 MICRO BARB

CARLIGE VARIVAS FLY 2200 2X-3X FINE NR 20 MICRO BARB

vc220020

Livrare 48-72 ore

26,32Lei

CARLIGE VARIVAS FLY KELL STREAMER 2510WB NR 4 F/BARB

CARLIGE VARIVAS FLY KELL STREAMER 2510WB NR 4 F/BARB

vcwb251004

Livrare 48-72 ore

30,40Lei

FIR VARIVAS TROUT AREA MASTER SUPER ESTER 140m 0.09mm 1.4lb NEO ORANGE

FIR VARIVAS TROUT AREA MASTER SUPER ESTER 140m 0.09mm 1.4lb NEO ORANGE

v5114003

Livrare 48-72 ore

54,79Lei

Fir textil Varivas Avani Eging Suspend PE 4X Marking Tropical Pink 17.5lb/160m

Fir textil Varivas Avani Eging Suspend PE 4X Marking Tropical Pink 17.5lb/160m

v16416010

Livrare 48-72 ore

170,71Lei

Carlige Varivas Offset Master Light Class NS Black Nr.2

Carlige Varivas Offset Master Light Class NS Black Nr.2

v7040002

Livrare 48-72 ore

19,20Lei

Fir Fluorocarbon Varivas Light Game Shock Leader 30m, 0.185mm, 5lb

Fir Fluorocarbon Varivas Light Game Shock Leader 30m, 0.185mm, 5lb

v2833012

Livrare 48-72 ore

61,92Lei

Fir Fluorocarbon Varivas Super Trout Area VSP, 0.90mm, 1.5lbs, 100m

Fir Fluorocarbon Varivas Super Trout Area VSP, 0.90mm, 1.5lbs, 100m

v6110003

Livrare 48-72 ore

163,59Lei

Inaintas Varivas Fly Tapered Leader Standard 6x7.5FT, 0.128mm-0.48mm, 22.8m, 7buc/pac

Inaintas Varivas Fly Tapered Leader Standard 6x7.5FT, 0.128mm-0.48mm, 22.8m, 7buc/pac

v117212

Livrare 48-72 ore

13,10Lei

FIR MONOFILAMENT VARIVAS DEAD OR ALIVE BROWN 150M 0.285MM 12LB

FIR MONOFILAMENT VARIVAS DEAD OR ALIVE BROWN 150M 0.285MM 12LB

v3715012

Livrare 48-72 ore

45,00Lei(-25%) 33,94Lei

CARLIGE VARIVAS FLY 2110 4X FINE NR 18 MICRO BARB

CARLIGE VARIVAS FLY 2110 4X FINE NR 18 MICRO BARB

vc211018

Livrare 48-72 ore

26,32Lei

CARLIGE VARIVAS FLY 2410V 2X FINE DEEP WIDE WET NR 4 MICRO BARB

CARLIGE VARIVAS FLY 2410V 2X FINE DEEP WIDE WET NR 4 MICRO BARB

vcv241004

Livrare 48-72 ore

31,40Lei

FIR MONOFILAMENT VARIVAS SUPER TROUT ADVANCE NYLON 100m 0.148mm 4lb

FIR MONOFILAMENT VARIVAS SUPER TROUT ADVANCE NYLON 100m 0.148mm 4lb

v2610004

Livrare imediată!

49,82Lei

FIR MONOFILAMENT VARIVAS DEAD OR ALIVE FLUOROCARBON 100M 0.405MM 20LB

FIR MONOFILAMENT VARIVAS DEAD OR ALIVE FLUOROCARBON 100M 0.405MM 20LB

v3810020

Livrare 48-72 ore

150,37Lei

Afişare 281 - 300 din 484 (25 pagini)

💬

WhatsApp Chat

👋 Salut! Cu ce vă pot ajuta?

Pot răspunde la întrebări despre:
✅ Comenzi și status livrare
✅ Informatii produse
✅ Recomandari produse(beta)
✅ Compatibilitate intre produse(beta)

Queries: 7, Total time: 63.314 ms [By time] [By id] [By file]

1 (0.096)

SELECT data
FROM `oc_session`
WHERE session_id = 'bbcd5531b146c98bc57fa4f930'

/var/www/clients/client1/web1/web/system/library/session/db.php:24

2 (0.080)

SELECT `trigger`, `action`
FROM oc_event

/var/www/clients/client1/web1/web/index.php:453

3 (0.160)

SELECT *
FROM oc_url_alias
WHERE keyword = 'Varivas'

/var/www/clients/client1/web1/web/catalog/controller/common/seo_url.php:48

4 (0.135)

SELECT *
FROM oc_manufacturer m
LEFT JOIN oc_manufacturer_to_store m2s ON (m.manufacturer_id = m2s.manufacturer_id)
WHERE m.manufacturer_id = '50' AND m2s.store_id = '0'

/var/www/clients/client1/web1/web/catalog/model/catalog/manufacturer.php:4

5 (29.184)

SELECT COUNT(1) AS total
FROM oc_product p
LEFT JOIN oc_product_description pd ON (p.product_id = pd.product_id)
LEFT JOIN oc_product_to_store p2s ON (p.product_id = p2s.product_id)
WHERE pd.language_id = '2' AND p.status = '1' AND p.quantity > '0' AND p.price > '0' AND p2s.store_id = '0' AND p.manufacturer_id = '50'

/var/www/clients/client1/web1/web/catalog/model/catalog/product.php:1699

6 (33.523)

SELECT p.product_id, (SELECT AVG(rating) AS total
FROM oc_review r1
WHERE r1.product_id = p.product_id AND r1.status = '1' GROUP BY r1.product_id) AS rating, (SELECT price
FROM oc_product_discount pd2
WHERE pd2.product_id = p.product_id AND pd2.customer_group_id = '1' AND pd2.quantity = '1' AND ((pd2.date_start = '0000-00-00' OR pd2.date_start < NOW()) AND (pd2.date_end = '0000-00-00' OR pd2.date_end > NOW()))
ORDER BY pd2.priority ASC, pd2.price ASC LIMIT 1) AS discount, ps.price AS special, p.viewed, p.price
FROM oc_product p
LEFT JOIN (SELECT pss.price, pss.product_id
FROM oc_product_special pss GROUP BY pss.product_id) ps ON (ps.product_id = p.product_id)
LEFT JOIN oc_product_description pd ON (p.product_id = pd.product_id)
LEFT JOIN oc_product_to_store p2s ON (p.product_id = p2s.product_id)
WHERE pd.language_id = '2' AND p.status = '1' AND p.quantity > '0' AND p.price > '0' AND p2s.store_id = '0' AND p.manufacturer_id = '50' GROUP BY p.product_id
ORDER BY p.sort_order ASC LIMIT 280,20

/var/www/clients/client1/web1/web/catalog/model/catalog/product.php:440

7 (0.136)

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