Varivas

Varivas

Sortare după:

Fir Monofilament Varivas Hard Top Fluorocarbon Leader 50m 0.235mm 4.5kg

Fir Monofilament Varivas Hard Top Fluorocarbon Leader 50m 0.235mm 4.5kg

v2825020

Livrare 48-72 ore

82,24Lei

Fir Monofilament Varivas Sea Bass Shock Leader Fluorocarbon 30m 0.470mm 30lb

Fir Monofilament Varivas Sea Bass Shock Leader Fluorocarbon 30m 0.470mm 30lb

v8203030

Livrare 48-72 ore

98,51Lei

Carlige Varivas Offset Master Monster Class Nr.4/0

Carlige Varivas Offset Master Monster Class Nr.4/0

v70424/0

Livrare 48-72 ore

19,20Lei

Fir Textil Varivas Avani Eging Max Power PE X9, White Marking, 23lbs, 1mm, 150m

Fir Textil Varivas Avani Eging Max Power PE X9, White Marking, 23lbs, 1mm, 150m

v129321

Livrare 48-72 ore

265,27Lei

INAINTAS MONOFILAMENT VARIVAS FLY LAKE RETRIEVE FLUORO 14FT/4.27m 3X

INAINTAS MONOFILAMENT VARIVAS FLY LAKE RETRIEVE FLUORO 14FT/4.27m 3X

v357143x

Livrare 48-72 ore

33,44Lei

CARLIGE VARIVAS FLY 2200BL 2X-3X FINE NR 16 F/BARB

CARLIGE VARIVAS FLY 2200BL 2X-3X FINE NR 16 F/BARB

vcbl220016

Livrare 48-72 ore

26,32Lei

CARLIGE VARIVAS FLY 2600V FINE NR 2/0 V-CUT

CARLIGE VARIVAS FLY 2600V FINE NR 2/0 V-CUT

vcv26002/0

Livrare 48-72 ore

38,51Lei

CARLIGE VARIVAS OFFSET NOGALES NEKORING LIGHT NR.2

CARLIGE VARIVAS OFFSET NOGALES NEKORING LIGHT NR.2

vc91hml02

Livrare imediată!

15,25Lei

BANDA Varivas ROLE FIR A 33.5cmx23cm Light Green/Red

BANDA Varivas ROLE FIR A 33.5cmx23cm Light Green/Red

vaac33b

Livrare 48-72 ore

47,67Lei

Fir Monofilament Varivas Big Trout Shockleader Fluorocarbon Vsp 30m 0.310mm 16lb

Fir Monofilament Varivas Big Trout Shockleader Fluorocarbon Vsp 30m 0.310mm 16lb

v45603035

Livrare 48-72 ore

82,24Lei

Carlige Varivas Offset Master Heavy Class Nr.2/0

Carlige Varivas Offset Master Heavy Class Nr.2/0

v70412/0

Livrare 48-72 ore

19,20Lei

Fir Fluorocarbon Varivas Shockleader Super Trout Area VSP, 0.104mm, 2lbs, 30m

Fir Fluorocarbon Varivas Shockleader Super Trout Area VSP, 0.104mm, 2lbs, 30m

v45703004

Livrare 48-72 ore

76,15Lei

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

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

v125811

Livrare 48-72 ore

77,16Lei

Inaintas Varivas Fly Tapered Leader Standard 4x7.5FT, 0.165mm-0.51mm, 9.12m, 7buc/pac

Inaintas Varivas Fly Tapered Leader Standard 4x7.5FT, 0.165mm-0.51mm, 9.12m, 7buc/pac

v117199

Livrare 48-72 ore

13,10Lei

FIR MONOFILAMENT VARIVAS SUPER TROUT AREA MASTER SVG 150M 0.117MM 3LB

FIR MONOFILAMENT VARIVAS SUPER TROUT AREA MASTER SVG 150M 0.117MM 3LB

v26315003

Livrare 48-72 ore

63,94Lei

CARLIGE VARIVAS FLY 2120WB 1X-2X FINE NR 20 F/BARB

CARLIGE VARIVAS FLY 2120WB 1X-2X FINE NR 20 F/BARB

vcwb212020

Livrare 48-72 ore

26,32Lei

CARLIGE VARIVAS FLY 2500V 3X FINE NR 10 V-CUT

CARLIGE VARIVAS FLY 2500V 3X FINE NR 10 V-CUT

vcv250010

Livrare 48-72 ore

27,35Lei

FIR MONOFILAMENT VARIVAS SUPER TROUT SIGHT EDITION 100m, 0.205mm, 6lb

FIR MONOFILAMENT VARIVAS SUPER TROUT SIGHT EDITION 100m, 0.205mm, 6lb

v26410015

Livrare 48-72 ore

47,67Lei

Fir Monofilament Varivas Kurodai Special Vep Flash Green 100m 0,285 MM

Fir Monofilament Varivas Kurodai Special Vep Flash Green 100m 0,285 MM

v21415030

Livrare 48-72 ore

31,40Lei

FIR VARIVAS SUPER TROUT ADVANCE DOUBLE CROSS PE 8X 100m 9.6lb 0.13mm HI-VIS Orange

FIR VARIVAS SUPER TROUT ADVANCE DOUBLE CROSS PE 8X 100m 9.6lb 0.13mm HI-VIS Orange

v41410006

Livrare 48-72 ore

210,36Lei

Afişare 301 - 320 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.396 ms [By time] [By id] [By file]

1 (0.189)

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

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

2 (0.105)

SELECT `trigger`, `action`
FROM oc_event

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

3 (0.101)

SELECT *
FROM oc_url_alias
WHERE keyword = 'Varivas'

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

4 (0.116)

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 (28.746)

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.997)

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 300,20

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

7 (0.142)

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