Savage Gear


Shad SAVAGE GEAR Craft Bleak, 10cm, 6.8g, Chartreuse Pumpkin, 40buc/pac

Shad SAVAGE GEAR Craft Bleak, 10cm, 6.8g, Chartreuse Pumpkin, 40buc/pac

1609086
Livrare 7-14 zile

224,70Lei

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

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

1608968
Livrare 7-14 zile

66,08Lei

Shad SAVAGE GEAR 3D Herring Shad, Herring, 17.5cm, 35g, 2buc/pac

Shad SAVAGE GEAR 3D Herring Shad, Herring, 17.5cm, 35g, 2buc/pac

1610700
Livrare 7-14 zile

49,82Lei

Swimbait Savage Gear Conger EEL, Bubblegum, 90g, 17cm, 1buc/pac

Swimbait Savage Gear Conger EEL, Bubblegum, 90g, 17cm, 1buc/pac

1623227
Livrare 7-14 zile

49,82Lei

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

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

svs76787
Livrare imediată!

45,74Lei

Swimbait SAVAGE GEAR 4D Herring Big Shad, Mackerel Php, 300g, 25cm, 1+2buc/pac

Swimbait SAVAGE GEAR 4D Herring Big Shad, Mackerel Php, 300g, 25cm, 1+2buc/pac

svs61959
Livrare imediată!

115,91Lei

Creatura SAVAGE GEAR Salamander Floating, WMR, 7.5cm, 3g, 5buc/pac

Creatura SAVAGE GEAR Salamander Floating, WMR, 7.5cm, 3g, 5buc/pac

svs77422
Livrare 7-14 zile

33,54Lei

Tricou SAVAGE GEAR Cannibal Blue, Marime S

Tricou SAVAGE GEAR Cannibal Blue, Marime S

svs71582
Livrare imediată!

146,40Lei

Lanseta SAVAGE GEAR SG4 M Game Travel, 2.15m, 10-40g, 4seg

Lanseta SAVAGE GEAR SG4 M Game Travel, 2.15m, 10-40g, 4seg

svs72206
Livrare 7-14 zile

499,25Lei

Lanseta SAVAGE GEAR SGS6 Shore Jigging MH, 30-100g, 3.05m, 2seg

Lanseta SAVAGE GEAR SGS6 Shore Jigging MH, 30-100g, 3.05m, 2seg

svs74936
Livrare 7-14 zile

1.244,55Lei

Vobler SAVAGE GEAR 3D Sticklebait Pencil Sinking, AYU GS, 7g, 5.5cm, 1buc/pac

Vobler SAVAGE GEAR 3D Sticklebait Pencil Sinking, AYU GS, 7g, 5.5cm, 1buc/pac

svs74020
Livrare 7-14 zile

49,82Lei

Lingurtia Rotativa SAVAGE GEAR Grub Spinners, Silver Red Lime, Nr.2, 5.8g, 1buc/pac

Lingurtia Rotativa SAVAGE GEAR Grub Spinners, Silver Red Lime, Nr.2, 5.8g, 1buc/pac

svs82468
Livrare 7-14 zile

26,41Lei

Spinnertail SAVAGE GEAR Fat Tail, Perch, 5.5cm, 9g

Spinnertail SAVAGE GEAR Fat Tail, Perch, 5.5cm, 9g

svs71761
Livrare imediată!

33,54Lei

Vobler SAVAGE GEAR Freestyler V2 Slow Sinking, Dirty Roach, 11cm, 28g, 1buc/pac

Vobler SAVAGE GEAR Freestyler V2 Slow Sinking, Dirty Roach, 11cm, 28g, 1buc/pac

svs77076
Livrare 7-14 zile

53,87Lei

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

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

svs71659
Livrare 7-14 zile

41,67Lei

Spinnertail SAVAGE GEAR Fat Tail NL, Blue Silver, 6.5cm, 12.5g, 1buc/pac

Spinnertail SAVAGE GEAR Fat Tail NL, Blue Silver, 6.5cm, 12.5g, 1buc/pac

svs77053
Livrare 7-14 zile

35,57Lei

LINGURITA Rotativa Savage Gear Caviar Fluo Orange Silver 9.5g Nr.3

LINGURITA Rotativa Savage Gear Caviar Fluo Orange Silver 9.5g Nr.3

f.sg.40965
Livrare imediată!

24,71Lei

Spinnertail SAVAGE GEAR Sticklebait Tail Spin Sinking, Firetiger, 6.5cm, 9g, 1buc/pac

Spinnertail SAVAGE GEAR Sticklebait Tail Spin Sinking, Firetiger, 6.5cm, 9g, 1buc/pac

svs76809
Livrare 7-14 zile

41,67Lei

Stinger SAVAGE GEAR Carbon 49 Spinning Rig, Nr.2, 7.5cm, 3buc/pac

Stinger SAVAGE GEAR Carbon 49 Spinning Rig, Nr.2, 7.5cm, 3buc/pac

svs54880
Livrare 7-14 zile

25,40Lei

Shad Savage Gear Craft Bleak, Lemon Glow Firetail, 7.0cm, 2.5g, 5buc/pac

Shad Savage Gear Craft Bleak, Lemon Glow Firetail, 7.0cm, 2.5g, 5buc/pac

1609107
Livrare imediată!

26,41Lei

Afişare 441 - 460 din 2161 (109 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: 149.062 ms [By time] [By id] [By file]
1 (0.137)
SELECT data
FROM `oc_session`
WHERE session_id = 'e09c8d3bfcac5e47612b88b12a'
/var/www/clients/client1/web1/web/system/library/session/db.php:24
2 (0.092)
SELECT `trigger`, `action`
FROM oc_event
/var/www/clients/client1/web1/web/index.php:453
3 (0.113)
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.114)
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 (68.615)
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 (79.826)
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 440,20
/var/www/clients/client1/web1/web/catalog/model/catalog/product.php:440
7 (0.165)
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