Nevis


Plumb cu Vartej NEVIS, 20g

Plumb cu Vartej NEVIS, 20g

7351-020
Livrare imediată!

5,17Lei

Cizme Nevis Thermo Alaszka Pro EVA, Marimea 43

Cizme Nevis Thermo Alaszka Pro EVA, Marimea 43

8620-043
Livrare 48-72 ore

148,44Lei

Juvelnic Nevis Fast Dry, 6mm, 50x1.50m

Juvelnic Nevis Fast Dry, 6mm, 50x1.50m

4278-150
Livrare 48-72 ore

55,91Lei

Plumb NEVIS Powercat Pentru Somn, 200g, 1buc/pac

Plumb NEVIS Powercat Pentru Somn, 200g, 1buc/pac

7352-200
Livrare 48-72 ore

23,37Lei

Shad Nevis Impulse 6.3cm 9721-623

Shad Nevis Impulse 6.3cm 9721-623

9721-623
Livrare imediată!

8,12Lei

Mulineta Nevis River Carp Feeder 6000

Mulineta Nevis River Carp Feeder 6000

2516-460
Livrare imediată!

216,57Lei

Fir Multifilament Nevis Nitro Spin 100m 0.12mm 9.90kg

Fir Multifilament Nevis Nitro Spin 100m 0.12mm 9.90kg

3235-012
Livrare 48-72 ore

22,35Lei

Momitor Feeder Method Carp 40Gr Nevis

Momitor Feeder Method Carp 40Gr Nevis

8100-340
Livrare imediată!

9,95Lei

Jig Nevis Nr.2/0, 5g, 4buc/pac

Jig Nevis Nr.2/0, 5g, 4buc/pac

4932-200-005
Livrare 48-72 ore

8,93Lei

Jig Nevis Nr.6/0, 7g, 3buc/pac

Jig Nevis Nr.6/0, 7g, 3buc/pac

4932-600-007
Livrare 48-72 ore

9,64Lei

Tub Cauciuc Zeck Treble Hook Tube 50cm, 5mm

Tub Cauciuc Zeck Treble Hook Tube 50cm, 5mm

41505120050
Livrare imediată!

16,34Lei

Carlige Legate Nevis Classic Feeder, Nr.8, 0.20mm, 40cm, 10buc/pac

Carlige Legate Nevis Classic Feeder, Nr.8, 0.20mm, 40cm, 10buc/pac

5708-008
Livrare 48-72 ore

9,53Lei

Fir Monofilament NEVIS Winner, Clear, 200m, 0.70mm, 35.80kg

Fir Monofilament NEVIS Winner, Clear, 200m, 0.70mm, 35.80kg

3206-270
Livrare 48-72 ore

23,89Lei

Lanseta NEVIS River Boat Feeder 2.70m, XXH 100-300g, 2+2seg

Lanseta NEVIS River Boat Feeder 2.70m, XXH 100-300g, 2+2seg

1287-270
Livrare 48-72 ore

305,03Lei

Carlige NEVIS Zander Strong, Nr.2/0, 5buc/pac

Carlige NEVIS Zander Strong, Nr.2/0, 5buc/pac

5620-200
Livrare 48-72 ore

6,90Lei

Fir Multifilament Nevis impletit Secure Braided 100m 0.25mm

Fir Multifilament Nevis impletit Secure Braided 100m 0.25mm

3225-025
Livrare imediată!

27,44Lei

Lanseta Nevis Motive Carp Nevis 3.90m 3.5lb 3seg

Lanseta Nevis Motive Carp Nevis 3.90m 3.5lb 3seg

1428-390
Livrare imediată!

224,70Lei

Lanseta Nevis Vanity Carp Feeder XXH 3.90m 80-220g

Lanseta Nevis Vanity Carp Feeder XXH 3.90m 80-220g

1843-390
Livrare 48-72 ore

374,17Lei

Monofilament Nevis Sensor Fluo 600m 0.30mm

Monofilament Nevis Sensor Fluo 600m 0.30mm

3201-630
Livrare 48-72 ore

40,66Lei

Monofilament Nevis Winner 200m 0.30mm

Monofilament Nevis Winner 200m 0.30mm

3206-230
Livrare imediată!

10,66Lei

Afişare 201 - 220 din 998 (50 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: 80.926 ms [By time] [By id] [By file]
1 (0.090)
SELECT data
FROM `oc_session`
WHERE session_id = '47ab31a95c7ebb8561df0575bd'
/var/www/clients/client1/web1/web/system/library/session/db.php:24
2 (0.118)
SELECT `trigger`, `action`
FROM oc_event
/var/www/clients/client1/web1/web/index.php:453
3 (0.091)
SELECT *
FROM oc_url_alias
WHERE keyword = 'nevis.html'
/var/www/clients/client1/web1/web/catalog/controller/common/seo_url.php:48
4 (0.137)
SELECT *
FROM oc_manufacturer m
LEFT JOIN oc_manufacturer_to_store m2s ON (m.manufacturer_id = m2s.manufacturer_id)
WHERE m.manufacturer_id = '423' AND m2s.store_id = '3'
/var/www/clients/client1/web1/web/catalog/model/catalog/manufacturer.php:4
5 (35.959)
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 = '3' AND p.manufacturer_id = '423'
/var/www/clients/client1/web1/web/catalog/model/catalog/product.php:1699
6 (44.419)
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 = '3' AND p.manufacturer_id = '423' GROUP BY p.product_id
ORDER BY p.sort_order ASC LIMIT 200,20
/var/www/clients/client1/web1/web/catalog/model/catalog/product.php:440
7 (0.112)
SELECT *
FROM `oc_mxt_setting`
WHERE store_id = '3' AND name = 'lichidare_stoc'
/var/www/clients/client1/web1/web/catalog/model/catalog/category.php:37