Savage Gear

Savage Gear

Sortare după:

Vobler Savage Gear 3D Smash Tail, Rudd, 10cm, 17g

Vobler Savage Gear 3D Smash Tail, Rudd, 10cm, 17g

sg.61994

Livrare 24-48 ore

47,01Lei

Shad Savage Gear LB Cannibal, Firetiger, 8cm, 5g, 4buc/plic

Shad Savage Gear LB Cannibal, Firetiger, 8cm, 5g, 4buc/plic

svs61846-bucxxx4

Livrare imediată!

18,82Lei

Shad SAVAGE GEAR 4D Line Thru Pulsetail Trout, Fire Trout, 15cm, 35g

Shad SAVAGE GEAR 4D Line Thru Pulsetail Trout, Fire Trout, 15cm, 35g

svs63750

Livrare imediată!

57,93Lei

CICADA SAVAGE GEAR VIB BLADE 4.5CM/8.5G OLIVE STRIPES

CICADA SAVAGE GEAR VIB BLADE 4.5CM/8.5G OLIVE STRIPES

sg.71442

Livrare 24-48 ore

36,24Lei

Foarfeca Savage Gear Magic Folding 11cm

Foarfeca Savage Gear Magic Folding 11cm

svs71894

Livrare imediată!

39,64Lei

Savage Gear Craft Cannibal Paddletail Clear Water Mix 8.5cm 7g 4buc/plic

Savage Gear Craft Cannibal Paddletail Clear Water Mix 8.5cm 7g 4buc/plic

f1.sg.71829

Livrare 24-48 ore

32,67Lei(-36%) 20,95Lei

Fir Fluorocarbon Savage Gear Soft Seabass 0.35mm 30m 6.72kg

Fir Fluorocarbon Savage Gear Soft Seabass 0.35mm 30m 6.72kg

a.sg.74487

Livrare 24-48 ore

38,18Lei

Cizme Piept SAVAGE GEAR Sg8 Zip Chest Sf W, Marime XXLS 45-47

Cizme Piept SAVAGE GEAR Sg8 Zip Chest Sf W, Marime XXLS 45-47

1608943

Livrare 7-14 zile

1.887,18Lei

Pilker SAVAGE GEAR Swimsquid Inchiku, Blue Pink Glow, 10.3cm, 180g, 1buc/pac

Pilker SAVAGE GEAR Swimsquid Inchiku, Blue Pink Glow, 10.3cm, 180g, 1buc/pac

svs77316

Livrare 7-14 zile

86,41Lei

Pilker SAVAGE GEAR Surf Seeker S, Blue Chrome, 11cm, 40g, 1buc/pac

Pilker SAVAGE GEAR Surf Seeker S, Blue Chrome, 11cm, 40g, 1buc/pac

svs71790

Livrare 7-14 zile

39,64Lei

LANSETA SAVAGE GEAR SG2 MEDIUM GAME 2.51M 12-35G 2SEG

LANSETA SAVAGE GEAR SG2 MEDIUM GAME 2.51M 12-35G 2SEG

o.sg.72157

Livrare 24-48 ore

423,15Lei(-54%) 194,62Lei

NALUCA SAVAGE GEAR HARD 3D EEL BLUE SILVER 17CM 50G 2+1BUC/PLIC

NALUCA SAVAGE GEAR HARD 3D EEL BLUE SILVER 17CM 50G 2+1BUC/PLIC

f1.sg.74132

Livrare 24-48 ore

60,23Lei(-58%) 25,49Lei

GEANTA SAVAGE GEAR SPECIALIST LURE 30X40X20CM INCL.6 CUTII

GEANTA SAVAGE GEAR SPECIALIST LURE 30X40X20CM INCL.6 CUTII

svs74235

Livrare 7-14 zile

353,83Lei

SHAD SAVAGE GEAR 3D RIVER ROACH 10CM 10G GOLD.AMBUL. 4BUC/PLIC

SHAD SAVAGE GEAR 3D RIVER ROACH 10CM 10G GOLD.AMBUL. 4BUC/PLIC

svs74290

Livrare 7-14 zile

41,36Lei

Pilker SAVAGE GEAR 3D Slim Jig Minnow Fast Sinking, FS GLOW Y, 12.5cm, 60g, 1buc/pac

Pilker SAVAGE GEAR 3D Slim Jig Minnow Fast Sinking, FS GLOW Y, 12.5cm, 60g, 1buc/pac

svs78210

Livrare 7-14 zile

51,84Lei

SPINNER SAVAGE GEAR 3D STICKLEBAIT TAILSPIN 7.3CM 13G SINKING BLACK RED

SPINNER SAVAGE GEAR 3D STICKLEBAIT TAILSPIN 7.3CM 13G SINKING BLACK RED

sg.76815

Livrare 24-48 ore

39,37Lei(-36%) 25,01Lei

Pilker SAVAGE GEAR Sardine Slider XS, UV Mirror Ayu, 13cm, 60g, 1buc/pac

Pilker SAVAGE GEAR Sardine Slider XS, UV Mirror Ayu, 13cm, 60g, 1buc/pac

svs78174

Livrare 7-14 zile

57,93Lei

Pilker SAVAGE GEAR Super Cast EGI ND3.0, Pink Chaos, 17g, 10.5cm, 1buc/pac

Pilker SAVAGE GEAR Super Cast EGI ND3.0, Pink Chaos, 17g, 10.5cm, 1buc/pac

svs78067

Livrare 7-14 zile

62,01Lei

Pilker SAVAGE GEAR 3D Line Thru Sandeel Sinking, BS UV, 25g, 11cm, 1buc/pac

Pilker SAVAGE GEAR 3D Line Thru Sandeel Sinking, BS UV, 25g, 11cm, 1buc/pac

svs63837

Livrare imediată!

45,74Lei

Kit Spinning Shad + Jig + Cutie Savage Gear Cannibal, Mixed Colors, 8cm/10cm, Model L, 36buc accesorii/cutie

Kit Spinning Shad + Jig + Cutie Savage Gear Cannibal, Mixed Colors, 8cm/10cm, Model L, 36buc accesorii/cutie

f1.sg.82338

Livrare 24-48 ore

106,78Lei

Afişare 1521 - 1540 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: 116.340 ms [By time] [By id] [By file]

1 (0.157)

SELECT data
FROM `oc_session`
WHERE session_id = '58bcbd676119704619d585a1ce'

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

2 (0.093)

SELECT `trigger`, `action`
FROM oc_event

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

3 (0.150)

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

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

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

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

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

7 (0.155)

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