Savage Gear


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

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

sg.69870
Livrare 24-48 ore

50,78Lei

Lingurita Rotativa Savage Gear Spinner Sticklebait, Sinking, Dirty Silver Red, Nr.4, 9.1g

Lingurita Rotativa Savage Gear Spinner Sticklebait, Sinking, Dirty Silver Red, Nr.4, 9.1g

sg.82244
Livrare 24-48 ore

30,49Lei

Shad Savage Gear Craft Bleak, Holo Baitfish, 8.5cm, 4.2g, 5buc/pac

Shad Savage Gear Craft Bleak, Holo Baitfish, 8.5cm, 4.2g, 5buc/pac

f1.sg.1609115
Livrare 24-48 ore

31,36Lei

Vobler Savage Gear Fat Vibers XL, Sinking, Bream, 58g, 10cm, 1buc/pac

Vobler Savage Gear Fat Vibers XL, Sinking, Bream, 58g, 10cm, 1buc/pac

1608966
Livrare 7-14 zile

64,00Lei

Vobler SAVAGE GEAR Gravity Twitch SR, Roach, 14.5cm, 50g -19%

Vobler SAVAGE GEAR Gravity Twitch SR, Roach, 14.5cm, 50g

sg.76795
Livrare 24-48 ore

61,67Lei(-19%) 50,23Lei

Shad SAVAGE GEAR 3D Herring Shad, Artic Char, 28cm, 150g, 1buc/pac

Shad SAVAGE GEAR 3D Herring Shad, Artic Char, 28cm, 150g, 1buc/pac

1624966
Livrare 7-14 zile

56,00Lei

Shad SAVAGE GEAR 3D Whitefish Shad Lure, Bleak, 12cm, 14g, 3buc/pac

Shad SAVAGE GEAR 3D Whitefish Shad Lure, Bleak, 12cm, 14g, 3buc/pac

1632015
Livrare 7-14 zile

28,00Lei

Vobler SAVAGE GEAR Wander Jerk Minnow Floating, Lemonback, 13.3g, 12.2cm, 1buc/pac

Vobler SAVAGE GEAR Wander Jerk Minnow Floating, Lemonback, 13.3g, 12.2cm, 1buc/pac

1623182
Livrare 7-14 zile

60,00Lei

Vobler SAVAGE GEAR 3D Smash Tail Floating, Black Gost, 12g, 8cm, 1buc/pac

Vobler SAVAGE GEAR 3D Smash Tail Floating, Black Gost, 12g, 8cm, 1buc/pac

svs76788
Livrare 7-14 zile

43,99Lei

Swimbait SAVAGE GEAR 4D Trout Rattleshad, Green Silver, 35g, 12.5cm, 1buc/pac

Swimbait SAVAGE GEAR 4D Trout Rattleshad, Green Silver, 35g, 12.5cm, 1buc/pac

svs73999
Livrare 7-14 zile

40,00Lei

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

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

svs77443
Livrare 7-14 zile

60,00Lei

Lanseta SAVAGE GEAR SGS6 Tenya Game MH, 25-95g, 2.51m, 2seg

Lanseta SAVAGE GEAR SGS6 Tenya Game MH, 25-95g, 2.51m, 2seg

svs78225
Livrare 7-14 zile

1.105,00Lei

Lanseta SAVAGE GEAR SG4 M Game MH, 2.51m, 15-45g, 2seg

Lanseta SAVAGE GEAR SG4 M Game MH, 2.51m, 15-45g, 2seg

svs75765
Livrare imediată!

489,99Lei

Lanseta SAVAGE GEAR Revenge SG6 Medium Game Baitcast, 10-30g, 2.21m, 2buc

Lanseta SAVAGE GEAR Revenge SG6 Medium Game Baitcast, 10-30g, 2.21m, 2buc

1601805
Livrare 7-14 zile

868,00Lei

Spinnertail SAVAGE GEAR Fat Tail, White Silver, 6.5cm, 16g

Spinnertail SAVAGE GEAR Fat Tail, White Silver, 6.5cm, 16g

svs71763
Livrare imediată!

34,00Lei

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

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

svs72620
Livrare 7-14 zile

68,00Lei

Vobler Savage Gear Gravity Twitch SR Ayu Chrome 9.5cm 15g

Vobler Savage Gear Gravity Twitch SR Ayu Chrome 9.5cm 15g

sg.71663
Livrare 24-48 ore

38,33Lei

Lingurtia Rotativa SAVAGE GEAR Sticklebait Spinner 3, Cooper Red, 9.1g, 1buc/pac

Lingurtia Rotativa SAVAGE GEAR Sticklebait Spinner 3, Cooper Red, 9.1g, 1buc/pac

svs82246
Livrare imediată!

28,00Lei

LINGURITA ROTATIVA SAVAGE ROTEX NR.1 GOLD 3.5G

LINGURITA ROTATIVA SAVAGE ROTEX NR.1 GOLD 3.5G

f.sg.42115
Livrare imediată!

15,55Lei

Lingurtia Rotativa SAVAGE GEAR Grub Spinners, Silver Red Yellow, Nr.0, 2.2g, 1buc/pac

Lingurtia Rotativa SAVAGE GEAR Grub Spinners, Silver Red Yellow, Nr.0, 2.2g, 1buc/pac

svs82454
Livrare imediată!

21,00Lei

Afişare 1 - 20 din 2140 (107 pagini)
Queries: 7, Total time: 105.269 ms [By time] [By id] [By file]
1 (0.095)
SELECT data
FROM `oc_session`
WHERE session_id = '11e4c88b27e60b6976f07c8bb2'
/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.099)
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.128)
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 = '3'
/var/www/clients/client1/web1/web/catalog/model/catalog/manufacturer.php:4
5 (41.219)
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 = '85'
/var/www/clients/client1/web1/web/catalog/model/catalog/product.php:1699
6 (63.501)
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 = '85' GROUP BY p.product_id
ORDER BY p.sort_order ASC LIMIT 0,20
/var/www/clients/client1/web1/web/catalog/model/catalog/product.php:440
7 (0.122)
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