Savage Gear

Savage Gear

Sortare după:

Lingurtia Rotativa SAVAGE GEAR Sticklebait Spinner 2, Cooper Red, 7.3g, 1buc/pac

Lingurtia Rotativa SAVAGE GEAR Sticklebait Spinner 2, Cooper Red, 7.3g, 1buc/pac

svs82240

Livrare 7-14 zile

27,44Lei

Lingurtia Rotativa SAVAGE GEAR Grub Spinners, Black Red Black, Nr.1, 3.8g, 1buc/pac

Lingurtia Rotativa SAVAGE GEAR Grub Spinners, Black Red Black, Nr.1, 3.8g, 1buc/pac

svs82464

Livrare imediată!

24,39Lei

Spinnertail SAVAGE GEAR Fat Tail, Blue Silver Pink, 8cm, 24g

Spinnertail SAVAGE GEAR Fat Tail, Blue Silver Pink, 8cm, 24g

svs71772

Livrare imediată!

37,61Lei

Vobler Savage Gear Fat Vibers XL, Sinking, Bream, 90g, 12.5cm, 1buc/pac

Vobler Savage Gear Fat Vibers XL, Sinking, Bream, 90g, 12.5cm, 1buc/pac

1608972

Livrare 7-14 zile

78,27Lei

Vobler Savage Gear Fat Vibes Blue Chrome 6.6cm 22g

Vobler Savage Gear Fat Vibes Blue Chrome 6.6cm 22g

svs71671

Livrare imediată!

43,20Lei

Spinnertail SAVAGE GEAR Fat Tail, Lemon BF, 5.5cm, 9g, 1buc/pac

Spinnertail SAVAGE GEAR Fat Tail, Lemon BF, 5.5cm, 9g, 1buc/pac

svs77059

Livrare 7-14 zile

33,54Lei

LINGURITA ROTATIVA SAVAGE ROTEX NR.2 FIRETIGER 5.5G

LINGURITA ROTATIVA SAVAGE ROTEX NR.2 FIRETIGER 5.5G

svs42122

Livrare imediată!

17,86Lei

Swimbait SAVAGE GEAR Sandeel V2 Sinking, Pink Pearl Silver, 46g, 15.5cm, 1+2buc/pac

Swimbait SAVAGE GEAR Sandeel V2 Sinking, Pink Pearl Silver, 46g, 15.5cm, 1+2buc/pac

svs72505

Livrare 7-14 zile

43,71Lei

Fir Fluorocarbon SAVAGE GEAR Semi Soft Sea Bass Clear, 6.72kg, 0.35mm, 30m

Fir Fluorocarbon SAVAGE GEAR Semi Soft Sea Bass Clear, 6.72kg, 0.35mm, 30m

svs74487

Livrare 7-14 zile

39,64Lei

PANTALON SAVAGE GEAR CIVIC JOGGERS GREY MELANGE MARIME M

PANTALON SAVAGE GEAR CIVIC JOGGERS GREY MELANGE MARIME M

a8.sg.73703

Livrare 24-48 ore

179,46Lei(-38%) 110,49Lei

Geanta SAVAGE GEAR WPMP Lure Bag M 2.6L, Black-Orange, 33x10x8cm

Geanta SAVAGE GEAR WPMP Lure Bag M 2.6L, Black-Orange, 33x10x8cm

svs74156

Livrare 7-14 zile

74,21Lei

Leader SAVAGE GEAR Teaser Trace M, 0.80mm, 22kg, 50cm, 2buc/pac

Leader SAVAGE GEAR Teaser Trace M, 0.80mm, 22kg, 50cm, 2buc/pac

1611091

Livrare 7-14 zile

33,54Lei

VOBLER SAVAGE GEAR 3D STICKLEBAIT TWITCH 6.5CM 9.4G FIRETIGER

VOBLER SAVAGE GEAR 3D STICKLEBAIT TWITCH 6.5CM 9.4G FIRETIGER

sg.72324

Livrare 24-48 ore

46,00Lei(-28%) 33,21Lei

Vobler SAVAGE GEAR Surf Walker Lure 2.0 Sinking, Snow Lemon, 26.5g, 15.5cm, 1buc/pac

Vobler SAVAGE GEAR Surf Walker Lure 2.0 Sinking, Snow Lemon, 26.5g, 15.5cm, 1buc/pac

svs78132

Livrare 7-14 zile

47,77Lei

Shad SAVAGE GEAR CRAFT 7,2CM/2,6G ROACH 4BUC/PL

Shad SAVAGE GEAR CRAFT 7,2CM/2,6G ROACH 4BUC/PL

svs74077

Livrare 7-14 zile

29,00Lei(-36%) 18,69Lei

Hanorac FOX Collection LW Zip Hoody Tan Ltd Brown, Marimea XXL

Hanorac FOX Collection LW Zip Hoody Tan Ltd Brown, Marimea XXL

ccl314

Livrare 7-14 zile

184,90Lei

Vobler SAVAGE GEAR Gravity Twitch DR Suspending, Sp Goldmine, 9.5cm, 16.5g, 1buc/pac

Vobler SAVAGE GEAR Gravity Twitch DR Suspending, Sp Goldmine, 9.5cm, 16.5g, 1buc/pac

1610637

Livrare 7-14 zile

41,67Lei

Swimbait SAVAGE GEAR Deviator Tail SS, DRT Roach Glt, 16.5cm 48g, 1+2buc/pac

Swimbait SAVAGE GEAR Deviator Tail SS, DRT Roach Glt, 16.5cm 48g, 1+2buc/pac

1625311

Livrare 7-14 zile

82,34Lei

Lanseta SAVAGE GEAR Revenge SG8 Light Game, 2.23m, 3-18g, 2buc

Lanseta SAVAGE GEAR Revenge SG8 Light Game, 2.23m, 3-18g, 2buc

1601826

Livrare 7-14 zile

1.285,23Lei

Lingurita Rotativa SAGAVE GEAR Caviar, Fluo Orange Silver, Nr.4, 18g, 1buc/pac

Lingurita Rotativa SAGAVE GEAR Caviar, Fluo Orange Silver, Nr.4, 18g, 1buc/pac

svs43626

Livrare 7-14 zile

30,00Lei(-56%) 13,20Lei

Afişare 1001 - 1020 din 2160 (108 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: 106.731 ms [By time] [By id] [By file]

1 (0.092)

SELECT data
FROM `oc_session`
WHERE session_id = '778689ec4cad3209b6d5dd7260'

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

2 (0.074)

SELECT `trigger`, `action`
FROM oc_event

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

3 (0.096)

SELECT *
FROM oc_url_alias
WHERE keyword = 'savage-gear.html'

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

4 (0.093)

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

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

5 (45.963)

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 = '2' AND p.manufacturer_id = '85'

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

6 (60.283)

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 = '2' AND p.manufacturer_id = '85' GROUP BY p.product_id
ORDER BY p.sort_order ASC LIMIT 1000,20

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

7 (0.130)

SELECT *
FROM `oc_mxt_setting`
WHERE store_id = '2' AND name = 'lichidare_stoc'

/var/www/clients/client1/web1/web/catalog/model/catalog/category.php:37