Savage Gear


Lanseta SAVAGE GEAR Alpha SG8 Swimbait Baitcast, 36-130g, 2.29m, 2seg

Lanseta SAVAGE GEAR Alpha SG8 Swimbait Baitcast, 36-130g, 2.29m, 2seg

1601706
Livrare 7-14 zile

1.244,55Lei

Lingurita Rotativa SAVAGE GEAR Rotex Spinner, Fluo Orange Silver, Nr.1, 3.5g, 1buc/pac

Lingurita Rotativa SAVAGE GEAR Rotex Spinner, Fluo Orange Silver, Nr.1, 3.5g, 1buc/pac

svs42116
Livrare 7-14 zile

16,25Lei

SHAD SAVAGE GEAR GOBSTER 7.5CM 5G CHART PUMPKIN 5BUC/PLIC -55%

SHAD SAVAGE GEAR GOBSTER 7.5CM 5G CHART PUMPKIN 5BUC/PLIC

f1.sg.76938
Livrare 24-48 ore

22,05Lei(-55%) 9,97Lei

Hanorac Savage Gear Junior Logo Black Ink 14-16 ani -28%

Hanorac Savage Gear Junior Logo Black Ink 14-16 ani

a8.sg.76682
Livrare imediată!

189,34Lei(-28%) 135,77Lei

Shad Savage Gear Cannibal, Motor Oil UV, 6.8cm, 3g, 5buc/pac -14%

Shad Savage Gear Cannibal, Motor Oil UV, 6.8cm, 3g, 5buc/pac

svs77129
Livrare imediată!

15,68Lei(-14%) 13,54Lei

Vobler SAVAGE GEAR Barra Jerk, 19cm, 25g, Pennywise, 1buc/pac

Vobler SAVAGE GEAR Barra Jerk, 19cm, 25g, Pennywise, 1buc/pac

1608980
Livrare 7-14 zile

74,21Lei

Shad Savage Gear Fat Minnow T-Tail, Smelt, 13cm, 20g, 5buc/pac -57%

Shad Savage Gear Fat Minnow T-Tail, Smelt, 13cm, 20g, 5buc/pac

svs77000
Livrare 7-14 zile

51,90Lei(-57%) 22,11Lei

Naluca SAVAGE GEAR Ned Dragon Tail Slug, 7,2cm, 3g, Clear Motoroil, 5buc/pac

Naluca SAVAGE GEAR Ned Dragon Tail Slug, 7,2cm, 3g, Clear Motoroil, 5buc/pac

1609039
Livrare 7-14 zile

37,61Lei

Vobler Savage Gear Deviator Swim, Slow Sinking, Roach, 10.5cm, 35g

Vobler Savage Gear Deviator Swim, Slow Sinking, Roach, 10.5cm, 35g

svs69867
Livrare imediată!

53,87Lei

Shad SAVAGE GEAR Craft Bleak, 8.5cm, 4.2g, Motoroil UV, 45buc/pac

Shad SAVAGE GEAR Craft Bleak, 8.5cm, 4.2g, Motoroil UV, 45buc/pac

1609073
Livrare 7-14 zile

205,39Lei

Vobler SAVAGE GEAR Gravity Twitch SR, Pike, 11.5cm, 25g -17%

Vobler SAVAGE GEAR Gravity Twitch SR, Pike, 11.5cm, 25g

sg.76793
Livrare 24-48 ore

52,88Lei(-17%) 44,01Lei

Shad SAVAGE GEAR 3D Herring Shad, Green Silver, 25cm, 102g, 1buc/pac

Shad SAVAGE GEAR 3D Herring Shad, Green Silver, 25cm, 102g, 1buc/pac

1610725
Livrare 7-14 zile

49,82Lei

Shad SAVAGE GEAR 3D Whitefish Shad Lure, Dirty Silver, 15cm, 27g, 2buc/pac

Shad SAVAGE GEAR 3D Whitefish Shad Lure, Dirty Silver, 15cm, 27g, 2buc/pac

1632099
Livrare 7-14 zile

41,67Lei

Swimbait Savage Gear Conger EEL, Conger, 200g, 23cm, 1buc/pac

Swimbait Savage Gear Conger EEL, Conger, 200g, 23cm, 1buc/pac

1623241
Livrare 7-14 zile

78,27Lei

Swimbait SAVAGE GEAR 3D Burbot FS, Golden AMB, 75g, 25cm, 1buc/pac

Swimbait SAVAGE GEAR 3D Burbot FS, Golden AMB, 75g, 25cm, 1buc/pac

svs53826
Livrare 7-14 zile

99,63Lei

Vobler SAVAGE GEAR Prop Walker Wobbler, Golden Shiner, 21g, 10cm, 1buc/pac

Vobler SAVAGE GEAR Prop Walker Wobbler, Golden Shiner, 21g, 10cm, 1buc/pac

svs77445
Livrare 7-14 zile

62,01Lei

Lanseta SAVAGE GEAR SG4 Game UL, 3-10g, 2.21m, 2seg

Lanseta SAVAGE GEAR SG4 Game UL, 3-10g, 2.21m, 2seg

svs72192
Livrare 7-14 zile

457,55Lei

Lanseta SAVAGE GEAR Revenge SG6 Medium Game, 12-35g, 2.43m, 2seg

Lanseta SAVAGE GEAR Revenge SG6 Medium Game, 12-35g, 2.43m, 2seg

1601806
Livrare 7-14 zile

924,26Lei

Spinnerbait SAVAGE GEAR DA Bush, Blue Silver, 42g, 18cm, 1buc/pac

Spinnerbait SAVAGE GEAR DA Bush, Blue Silver, 42g, 18cm, 1buc/pac

svs72617
Livrare 7-14 zile

70,14Lei

Lingurtia Rotativa SAVAGE GEAR Rotex Spinner, Nr.5, Firetiger, 14g, 1buc/pac

Lingurtia Rotativa SAVAGE GEAR Rotex Spinner, Nr.5, Firetiger, 14g, 1buc/pac

svs42138
Livrare imediată!

20,32Lei

Afişare 201 - 220 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: 136.380 ms [By time] [By id] [By file]
1 (0.111)
SELECT data
FROM `oc_session`
WHERE session_id = '1b509b99c8a03b2aa43cb00ee5'
/var/www/clients/client1/web1/web/system/library/session/db.php:24
2 (0.102)
SELECT `trigger`, `action`
FROM oc_event
/var/www/clients/client1/web1/web/index.php:453
3 (0.137)
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.151)
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 (73.965)
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.763)
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 200,20
/var/www/clients/client1/web1/web/catalog/model/catalog/product.php:440
7 (0.152)
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