Savage Gear


Spinnertail SAVAGE GEAR Fat Tail, Blue Silver Pink, 5.5cm, 9g

Spinnertail SAVAGE GEAR Fat Tail, Blue Silver Pink, 5.5cm, 9g

svs71762
Livrare imediată!

33,54Lei

Vobler SAVAGE GEAR Gravity Twitch Suspending MR Floating, Perch, 8.3cm, 10g, 1buc/pac

Vobler SAVAGE GEAR Gravity Twitch Suspending MR Floating, Perch, 8.3cm, 10g, 1buc/pac

svs74123
Livrare 7-14 zile

37,61Lei

Vobler Savage Gear Gravity Twitch SR Firetiger 9.5cm 15g

Vobler Savage Gear Gravity Twitch SR Firetiger 9.5cm 15g

sg.71660
Livrare 24-48 ore

39,33Lei

Vobler Articulat SAVAGE GEAR 4Play V2 Lip Lure Floating, Rudd, 32g, 16.5cm, 1buc/pac

Vobler Articulat SAVAGE GEAR 4Play V2 Lip Lure Floating, Rudd, 32g, 16.5cm, 1buc/pac

svs61746
Livrare 7-14 zile

78,27Lei

LINGURITA Rotativa Savage Gear Caviar Firetiger 9.5g Nr.3

LINGURITA Rotativa Savage Gear Caviar Firetiger 9.5g Nr.3

f.sg.40966
Livrare imediată!

25,11Lei

Vobler SAVAGE GEAR Deviator Swim SS Glider, Roach, 14cm, 70g, 1buc/pac

Vobler SAVAGE GEAR Deviator Swim SS Glider, Roach, 14cm, 70g, 1buc/pac

svs69879
Livrare 7-14 zile

74,21Lei

Jacheta SAVAGE GEAR Reflection Hybrid Jacket S, Black-Gray -41%

Jacheta SAVAGE GEAR Reflection Hybrid Jacket S, Black-Gray

svs76559
Livrare 7-14 zile

499,95Lei(-41%) 294,41Lei

Lanseta SAVAGE GEAR SG4 Medium Game Baitcast M, 10-30g, 2.13m, 2seg

Lanseta SAVAGE GEAR SG4 Medium Game Baitcast M, 10-30g, 2.13m, 2seg

svs72204
Livrare 7-14 zile

478,91Lei

HANORAC SAVAGE GEAR COSMO BLACK INK MARIME S

HANORAC SAVAGE GEAR COSMO BLACK INK MARIME S

svs73697
Livrare 7-14 zile

219,62Lei

Protectie ancora Savage Gear Treble Hook Protectors XLarge

Protectie ancora Savage Gear Treble Hook Protectors XLarge

svs72329
Livrare imediată!

23,37Lei

Vobler SAVAGE GEAR Surf Walker Lure 2.0 Floating, Mirror Sardine, 9.5g, 12.5cm, 1buc/pac

Vobler SAVAGE GEAR Surf Walker Lure 2.0 Floating, Mirror Sardine, 9.5g, 12.5cm, 1buc/pac

svs78111
Livrare 7-14 zile

43,71Lei

MANUSI SAVAGE GEAR SOFTSHELL WINTER BLACK MAR.XL

MANUSI SAVAGE GEAR SOFTSHELL WINTER BLACK MAR.XL

svs76607
Livrare 7-14 zile

133,18Lei

Lanseta Telescopica DAM XT1 Rod, 3.25lbs, 3.90m, 6seg

Lanseta Telescopica DAM XT1 Rod, 3.25lbs, 3.90m, 6seg

svs70892
Livrare 7-14 zile

341,63Lei

VOBLER SAVAGE GEAR GRAVITY TWITCH 8,3CM/10G SUSPENDING BTS -16%

VOBLER SAVAGE GEAR GRAVITY TWITCH 8,3CM/10G SUSPENDING BTS

sg.74111
Livrare 24-48 ore

44,98Lei(-16%) 37,59Lei

Shad SAVAGE GEAR Collapser, Fluoro Perch, 27g, 18cm, 2buc/pac

Shad SAVAGE GEAR Collapser, Fluoro Perch, 27g, 18cm, 2buc/pac

1623208
Livrare 7-14 zile

41,67Lei

BANDANA BUFF SAVAGE MARINE UV ONE SIZE SEA BLUE

BANDANA BUFF SAVAGE MARINE UV ONE SIZE SEA BLUE

svs73675
Livrare 7-14 zile

48,79Lei

Vobler SAVAGE GEAR Gravity Twitch DR Suspending, Sp Red Tiger, 11.5cm, 28g, 1buc/pac

Vobler SAVAGE GEAR Gravity Twitch DR Suspending, Sp Red Tiger, 11.5cm, 28g, 1buc/pac

1610640
Livrare 7-14 zile

45,74Lei

Swimbait SAVAGE GEAR Real EEL, Chameleon Eel, 40cm, 147g, 1buc/pac

Swimbait SAVAGE GEAR Real EEL, Chameleon Eel, 40cm, 147g, 1buc/pac

1631034
Livrare 7-14 zile

57,93Lei

Lanseta SAVAGE GEAR Revenge SG8 Finesse, 2.43m, 4-18g, 2buc

Lanseta SAVAGE GEAR Revenge SG8 Finesse, 2.43m, 4-18g, 2buc

1601819
Livrare 7-14 zile

1.324,88Lei

SHAD SAVAGE GEAR NED MINNOW 7.5CM 4.5G SMALLMOUTH 5BUC/PLIC

SHAD SAVAGE GEAR NED MINNOW 7.5CM 4.5G SMALLMOUTH 5BUC/PLIC

svs77432
Livrare 7-14 zile

31,21Lei

Afişare 221 - 240 din 2134 (107 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: 103.396 ms [By time] [By id] [By file]
1 (0.156)
SELECT data
FROM `oc_session`
WHERE session_id = '1b509b99c8a03b2aa43cb00ee5'
/var/www/clients/client1/web1/web/system/library/session/db.php:24
2 (0.091)
SELECT `trigger`, `action`
FROM oc_event
/var/www/clients/client1/web1/web/index.php:453
3 (0.115)
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.132)
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 (41.754)
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 (61.015)
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 220,20
/var/www/clients/client1/web1/web/catalog/model/catalog/product.php:440
7 (0.133)
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