Savage Gear

Savage Gear

Sortare după:

SPINNERBAIT SAVAGE GEAR DA BUSH 14CM 21G SINKING BLUE SILVER

SPINNERBAIT SAVAGE GEAR DA BUSH 14CM 21G SINKING BLUE SILVER

svs72605

Livrare 7-14 zile

42,54Lei(-57%) 18,30Lei

LANSETA SAVAGE GEAR SG2 MICRO GAME 1.83M 0-2G 2seg

LANSETA SAVAGE GEAR SG2 MICRO GAME 1.83M 0-2G 2seg

o.sg.72142

Livrare 24-48 ore

310,43Lei(-18%) 253,51Lei

Fir fluorocarbon Savage Gear Super Hard Fluorocarbon 0.77mm 25.70kg 45m

Fir fluorocarbon Savage Gear Super Hard Fluorocarbon 0.77mm 25.70kg 45m

a.sg.74494

Livrare 24-48 ore

162,33Lei(-49%) 83,53Lei

CUTIE SAVAGE GEAR PT.NALUCI TIP 5B 27.5X18X4.5CM

CUTIE SAVAGE GEAR PT.NALUCI TIP 5B 27.5X18X4.5CM

svs76776

Livrare imediată!

43,71Lei

KIT SAVAGE GEAR NALUCI ACC GRAVITY STICK 30 19BUC

KIT SAVAGE GEAR NALUCI ACC GRAVITY STICK 30 19BUC

svs71865

Livrare imediată!

190,13Lei

Pilker SAVAGE GEAR Seeker ISP Sinking, Green Siver, 10cm, 28g, 1buc/pac

Pilker SAVAGE GEAR Seeker ISP Sinking, Green Siver, 10cm, 28g, 1buc/pac

svs55353

Livrare 7-14 zile

31,50Lei

NALUCA SAVAGE GEAR SKIRT FLIRT JIG 6.5CM/10G SINKING WHITE PEARL

NALUCA SAVAGE GEAR SKIRT FLIRT JIG 6.5CM/10G SINKING WHITE PEARL

f1.sg.76853

Livrare 24-48 ore

30,84Lei(-56%) 13,55Lei

Fir Fluorocarbon SAVAGE GEAR Super Hard, Clear, 18.90kg, 0.60mm, 50m

Fir Fluorocarbon SAVAGE GEAR Super Hard, Clear, 18.90kg, 0.60mm, 50m

svs74492

Livrare 7-14 zile

133,18Lei

Chatterbait SAVAGE GEAR Crazy Swim Jig, White Silver, 10cm, 8.5g, 1buc/pac

Chatterbait SAVAGE GEAR Crazy Swim Jig, White Silver, 10cm, 8.5g, 1buc/pac

svs76733

Livrare imediată!

37,61Lei

Lanseta Spinning SAVAGE GEAR Orange LTD Medium Game 2.21m, 15-45g, 2seg

Lanseta Spinning SAVAGE GEAR Orange LTD Medium Game 2.21m, 15-45g, 2seg

o.sg.1609545

Livrare 24-48 ore

481,33Lei

Swimbait SAVAGE GEAR 3D Perch RTF Lure, Blue Perch, 17.5cm, 96g

Swimbait SAVAGE GEAR 3D Perch RTF Lure, Blue Perch, 17.5cm, 96g

1624949

Livrare 7-14 zile

53,87Lei

Swimbait SAVAGE GEAR 3D Roach RTF Lure, Hugo, 18cm, 104g

Swimbait SAVAGE GEAR 3D Roach RTF Lure, Hugo, 18cm, 104g

1625371

Livrare 7-14 zile

62,01Lei

Protecite Lansete SAVAGE GEAR Neoprene Rod Tip/Butt Protector

Protecite Lansete SAVAGE GEAR Neoprene Rod Tip/Butt Protector

1622901

Livrare 7-14 zile

66,08Lei

AGRAFE SAVAGE GEAR NEEDLE EGG SNAPS S 24KG/20BUC

AGRAFE SAVAGE GEAR NEEDLE EGG SNAPS S 24KG/20BUC

svs54919

Livrare imediată!

11,17Lei

MINCIOG SAVAGE TELE FOLDING 65X50CM

MINCIOG SAVAGE TELE FOLDING 65X50CM

svs50803

Livrare imediată!

222,99Lei

Montura Savage Gear Carbon Ancora Nr. 1/20 Cm

Montura Savage Gear Carbon Ancora Nr. 1/20 Cm

a.sg.57403

Livrare 24-48 ore

30,67Lei(-56%) 13,48Lei

SALOPETA SAVAGE HEATLITE THERMO B AND B MARIMEA XXL

SALOPETA SAVAGE HEATLITE THERMO B AND B MARIMEA XXL

svs59132

Livrare imediată!

387,39Lei

Pantofi Savage Sport Gear Sneakers MAR. 44

Pantofi Savage Sport Gear Sneakers MAR. 44

a8.sg.62318

Livrare 24-48 ore

361,75Lei(-47%) 190,66Lei

Shad Savage Gear LB Cannibal, Perch, 12.5cm, 20g, 3buc/plic

Shad Savage Gear LB Cannibal, Perch, 12.5cm, 20g, 3buc/plic

svs61857-bucxxx3

Livrare imediată!

23,82Lei

SHAD SAVAGE LB CANNIBAL 10CM/9G/DIRTY ROACH 4BUC/PLIC

SHAD SAVAGE LB CANNIBAL 10CM/9G/DIRTY ROACH 4BUC/PLIC

f1.sg.63802

Livrare 24-48 ore

23,23Lei(-10%) 20,81Lei

Afişare 1561 - 1580 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: 219.096 ms [By time] [By id] [By file]

1 (0.122)

SELECT data
FROM `oc_session`
WHERE session_id = '4e07325753f62920788ec152fa'

/var/www/clients/client1/web1/web/system/library/session/db.php:24

2 (0.150)

SELECT `trigger`, `action`
FROM oc_event

/var/www/clients/client1/web1/web/index.php:453

3 (0.133)

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.134)

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 (85.808)

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 (120.909)

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 1560,20

/var/www/clients/client1/web1/web/catalog/model/catalog/product.php:440

7 (11.840)

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