Savage Gear


Spinnertail SAVAGE GEAR Fat Tail, Dirty Roach, 6.5cm, 16g

Spinnertail SAVAGE GEAR Fat Tail, Dirty Roach, 6.5cm, 16g

sg.77063
Livrare imediată!

33,63Lei

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

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

1610727
Livrare 7-14 zile

49,82Lei

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

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

1632017
Livrare 7-14 zile

29,48Lei

Swimbait Savage Gear Conger EEL, Skyback Candy, 120g, 19cm, 1buc/pac

Swimbait Savage Gear Conger EEL, Skyback Candy, 120g, 19cm, 1buc/pac

1623232
Livrare 7-14 zile

57,93Lei

Creatura SAVAGE GEAR 3D Crayfish Rattling, Motor Oil UV, 6.7cm, 2.9g, 8buc/pac

Creatura SAVAGE GEAR 3D Crayfish Rattling, Motor Oil UV, 6.7cm, 2.9g, 8buc/pac

svs72598
Livrare 7-14 zile

41,67Lei

Montura Somn SAVAGE GEAR Bloody Assist Hook SJ Double, Nr.2/0, 2buc/pac

Montura Somn SAVAGE GEAR Bloody Assist Hook SJ Double, Nr.2/0, 2buc/pac

svs78147
Livrare 7-14 zile

29,48Lei

Lanseta SAVAGE GEAR Fury SG6 Shad And Metal, 50-200g, 2.41m, 2seg

Lanseta SAVAGE GEAR Fury SG6 Shad And Metal, 50-200g, 2.41m, 2seg

1601792
Livrare 7-14 zile

1.044,24Lei

Montura Somn SAVAGE GEAR Bloody Assist Hook J Double Asymmetric, Nr.2/0, 2buc/pac

Montura Somn SAVAGE GEAR Bloody Assist Hook J Double Asymmetric, Nr.2/0, 2buc/pac

svs78144
Livrare 7-14 zile

29,48Lei

Lanseta SAVAGE GEAR Revenge SG6 Vertical MH, 1.98m, 18-42g, 2seg

Lanseta SAVAGE GEAR Revenge SG6 Vertical MH, 1.98m, 18-42g, 2seg

1601722
Livrare 7-14 zile

883,59Lei

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

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

svs72616
Livrare 7-14 zile

70,14Lei

Lingurtia Rotativa SAVAGE GEAR Sticklebait Spinner 2, Minnow Gold, 7.3g, 1buc/pac

Lingurtia Rotativa SAVAGE GEAR Sticklebait Spinner 2, Minnow Gold, 7.3g, 1buc/pac

svs82242
Livrare 7-14 zile

27,44Lei

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

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

svs82453
Livrare imediată!

22,35Lei

Vobler SAVAGE GEAR Gravity Twitch Suspending MR Floating, Blue Chrome, 9.5cm, 15g, 1buc/pac

Vobler SAVAGE GEAR Gravity Twitch Suspending MR Floating, Blue Chrome, 9.5cm, 15g, 1buc/pac

svs74127
Livrare 7-14 zile

41,67Lei

Vobler Savage Gear Fat Vibes Red Crayfish 6.6cm 22g

Vobler Savage Gear Fat Vibes Red Crayfish 6.6cm 22g

svs71676
Livrare 7-14 zile

45,74Lei

Vobler Articulat SAVAGE GEAR 4Play V2 Swim & Jerk, Roach, 35g, 16.5cm, 1buc/pac

Vobler Articulat SAVAGE GEAR 4Play V2 Swim & Jerk, Roach, 35g, 16.5cm, 1buc/pac

svs61738
Livrare 7-14 zile

78,27Lei

Vobler SAVAGE GEAR Gravity Crank MR Floating, Red Crayfish, 19g, 7.3cm, 1buc/pac

Vobler SAVAGE GEAR Gravity Crank MR Floating, Red Crayfish, 19g, 7.3cm, 1buc/pac

svs71689
Livrare 7-14 zile

37,61Lei

Struna Titan SAVAGE GEAR Single Strand Titanium Jerkbait, 30cm, 0.60mm, 25kg, 2buc/pac

Struna Titan SAVAGE GEAR Single Strand Titanium Jerkbait, 30cm, 0.60mm, 25kg, 2buc/pac

svs54875
Livrare 7-14 zile

25,40Lei

SHAD SAVAGE GEAR CRAFT 7.2CM 2.6G BLUE PEARL 5BUC/PLIC -56%

SHAD SAVAGE GEAR CRAFT 7.2CM 2.6G BLUE PEARL 5BUC/PLIC

svs72406
Livrare 7-14 zile

34,90Lei(-56%) 15,19Lei

Swimbait SAVAGE GEAR 4D Shad, Firetiger, 65g, 20cm, 1buc/pac

Swimbait SAVAGE GEAR 4D Shad, Firetiger, 65g, 20cm, 1buc/pac

svs61787
Livrare imediată!

70,14Lei

Naluca SAVAGE GEAR Swim Squid RTF Sinking, Pink Glow, 200g, 25cm, 1buc/pac

Naluca SAVAGE GEAR Swim Squid RTF Sinking, Pink Glow, 200g, 25cm, 1buc/pac

svs78167
Livrare 7-14 zile

78,27Lei

Afişare 801 - 820 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: 175.619 ms [By time] [By id] [By file]
1 (0.165)
SELECT data
FROM `oc_session`
WHERE session_id = 'fe3a21f30c7b7f63a7ac5a66d3'
/var/www/clients/client1/web1/web/system/library/session/db.php:24
2 (0.136)
SELECT `trigger`, `action`
FROM oc_event
/var/www/clients/client1/web1/web/index.php:453
3 (0.149)
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.120)
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 (66.777)
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 (108.127)
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 800,20
/var/www/clients/client1/web1/web/catalog/model/catalog/product.php:440
7 (0.145)
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