Savage Gear

Savage Gear

Sortare după:

HUSA SAVAGE GEAR 1 LANSETA 120CM

HUSA SAVAGE GEAR 1 LANSETA 120CM

svs74149

Livrare 7-14 zile

159,62Lei

Fir fluorocarbon Savage Gear Soft Fluorocarbon EGI 0.29mm 6.03kg 25m

Fir fluorocarbon Savage Gear Soft Fluorocarbon EGI 0.29mm 6.03kg 25m

svs74482

Livrare imediată!

35,57Lei

CUTIE SAVAGE GEAR PT.NALUCI TIP 2B 16.1X9.1X3.1CM

CUTIE SAVAGE GEAR PT.NALUCI TIP 2B 16.1X9.1X3.1CM

svs76770

Livrare imediată!

22,35Lei

CUTIE SAVAGE GEAR PT.NALUCI TIP 4B SMOKE 27,5X18X5CM

CUTIE SAVAGE GEAR PT.NALUCI TIP 4B SMOKE 27,5X18X5CM

svs74224

Livrare 7-14 zile

51,84Lei

Pilker SAVAGE GEAR Seeker ISP Sinking, Green Siver, 8.7cm, 16g, 1buc/pac

Pilker SAVAGE GEAR Seeker ISP Sinking, Green Siver, 8.7cm, 16g, 1buc/pac

svs55343

Livrare 7-14 zile

29,48Lei

NALUCA SAVAGE GEAR SKIRT FLIRT JIG 6.5CM/7.5G SINKING BLACK RED

NALUCA SAVAGE GEAR SKIRT FLIRT JIG 6.5CM/7.5G SINKING BLACK RED

f1.sg.76848

Livrare 24-48 ore

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

Shad SAVAGE GEAR Soft Lure Monster Slug, Lemon Tiger, 50g, 25cm, 2buc/pac

Shad SAVAGE GEAR Soft Lure Monster Slug, Lemon Tiger, 50g, 25cm, 2buc/pac

svs69796

Livrare 7-14 zile

47,77Lei

Jig Savage Gear Rac Nr.1, 5g, 3buc/pac

Jig Savage Gear Rac Nr.1, 5g, 3buc/pac

svs74411

Livrare imediată!

32,36Lei

Pantofi SAVAGE GEAR Cool Step, Indian Blue, Marime 42

Pantofi SAVAGE GEAR Cool Step, Indian Blue, Marime 42

1611197

Livrare 7-14 zile

196,23Lei

Swimbait SAVAGE GEAR 3D Roach RTF Lure, Bream, 15cm, 60g

Swimbait SAVAGE GEAR 3D Roach RTF Lure, Bream, 15cm, 60g

1625362

Livrare 7-14 zile

49,82Lei

LANSETA SAVAGE 2BUC PREDATOR 2,58M/3-16G

LANSETA SAVAGE 2BUC PREDATOR 2,58M/3-16G

o.sg.50167

Livrare imediată!

642,96Lei(-22%) 503,89Lei

NALUCA SAVAGE 3D HOLLOW DUCKLING 10CM/40G 02

NALUCA SAVAGE 3D HOLLOW DUCKLING 10CM/40G 02

f1.sg.57612

Livrare 24-48 ore

49,27Lei(-37%) 31,05Lei

Hanorac SAVAGE GEAR Twin Shirt Jacket Check M, Orange Grey

Hanorac SAVAGE GEAR Twin Shirt Jacket Check M, Orange Grey

1611173

Livrare imediată!

291,82Lei

OCHELARI POLARIZATI SAVAGE GEAR SLIM SHADES AMBER

OCHELARI POLARIZATI SAVAGE GEAR SLIM SHADES AMBER

a8.sg.57571

Livrare imediată!

116,31Lei

JACHETA SAVAGE HEATLITE THERMO MARIMEA L

JACHETA SAVAGE HEATLITE THERMO MARIMEA L

svs59126

Livrare 7-14 zile

500,25Lei

Vobler Savage Gear 3D Goby Crank, Culoare 62163, 4cm, 3.5g

Vobler Savage Gear 3D Goby Crank, Culoare 62163, 4cm, 3.5g

sg.62163

Livrare imediată!

42,06Lei(-26%) 30,93Lei

Shad Savage Gear LB Cannibal, Golden Ambulance, 6.8cm, 3g, 4buc/plic

Shad Savage Gear LB Cannibal, Golden Ambulance, 6.8cm, 3g, 4buc/plic

svs61842-bucxxx4

Livrare imediată!

14,71Lei

SHAD SAVAGE LB 4D HERRING 11CM/9G/GOLDEN AMBULANCE 4BUC/PLIC

SHAD SAVAGE LB 4D HERRING 11CM/9G/GOLDEN AMBULANCE 4BUC/PLIC

f1.sg.63683

Livrare 24-48 ore

36,98Lei(-44%) 20,74Lei

CICADA SAVAGE GEAR SWITCH BLADE MINNOW 6CM/18G OLIVE SMOLT

CICADA SAVAGE GEAR SWITCH BLADE MINNOW 6CM/18G OLIVE SMOLT

sg.63747

Livrare 24-48 ore

34,34Lei(-46%) 18,46Lei

Cleste Savage Gear Pro L 20Cm

Cleste Savage Gear Pro L 20Cm

a.sg.71888

Livrare 24-48 ore

264,55Lei(-50%) 133,28Lei

Afişare 1961 - 1980 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: 131.785 ms [By time] [By id] [By file]

1 (0.076)

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

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

2 (0.104)

SELECT `trigger`, `action`
FROM oc_event

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

3 (0.128)

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

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

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

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

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

7 (0.143)

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