Savage Gear

Savage Gear

Sortare după:

Naluca SAVAGE GEAR 3D Suicide Duck, Ugly Duckling, 10.5cm, 28g, 1buc/pac

Naluca SAVAGE GEAR 3D Suicide Duck, Ugly Duckling, 10.5cm, 28g, 1buc/pac

svs71866

Livrare 7-14 zile

70,14Lei

Shad Savage Gear Craft Cannibal Paddletail 8.5cm 7g 4buc/plic Roach

Shad Savage Gear Craft Cannibal Paddletail 8.5cm 7g 4buc/plic Roach

svs71803

Livrare 7-14 zile

25,42Lei(-35%) 16,50Lei

Broasca SAVAGE GEAR Hop Popper Frog, Gill, 5.5cm, 15g, 1buc/pac

Broasca SAVAGE GEAR Hop Popper Frog, Gill, 5.5cm, 15g, 1buc/pac

svs77441

Livrare 7-14 zile

45,74Lei

Lanseta Savage Gear SG2 Shore Game 274cm 10-30g 2seg

Lanseta Savage Gear SG2 Shore Game 274cm 10-30g 2seg

o.sg.72175

Livrare 24-48 ore

404,30Lei(-29%) 288,78Lei

Agrafe SAVAGE GEAR CrossLock Egg Snap L, 10buc/pac

Agrafe SAVAGE GEAR CrossLock Egg Snap L, 10buc/pac

svs61782

Livrare 7-14 zile

17,27Lei

Ghete SAVAGE GEAR Sg8 Wading Boot Cleat Cleat, Nr.47

Ghete SAVAGE GEAR Sg8 Wading Boot Cleat Cleat, Nr.47

1601847

Livrare 7-14 zile

571,43Lei

NALUCA SAVAGE GEAR 3D CRAYFISH RATTLING 6.7CM 2.9G PURPLE HAZE GHOST

NALUCA SAVAGE GEAR 3D CRAYFISH RATTLING 6.7CM 2.9G PURPLE HAZE GHOST

f1.sg.72599

Livrare 24-48 ore

32,43Lei(-26%) 24,09Lei

Jig Savage Gear Minnow WL Jighead Tail Neutral 5/0 10g 10cm 3buc

Jig Savage Gear Minnow WL Jighead Tail Neutral 5/0 10g 10cm 3buc

f2.sg.72453

Livrare 24-48 ore

42,83Lei(-26%) 31,48Lei

MULINETA SAVAGE GEAR SGS6 6000

MULINETA SAVAGE GEAR SGS6 6000

o.sg.74755

Livrare 24-48 ore

534,19Lei(-39%) 326,91Lei

Fir fluorocarbon Savage Gear Super Hard Fluorocarbon 0.60mm 18.90kg 50m

Fir fluorocarbon Savage Gear Super Hard Fluorocarbon 0.60mm 18.90kg 50m

a.sg.74492

Livrare 24-48 ore

114,48Lei(-38%) 70,85Lei

CUTIE SAVAGE GEAR PT.NALUCI TIP 4B 21.4X11.8X4.5CM

CUTIE SAVAGE GEAR PT.NALUCI TIP 4B 21.4X11.8X4.5CM

svs76774

Livrare imediată!

39,64Lei

CUTIE SAVAGE GEAR PT.ACCESORII SMOKE 23X11X3,5CM 2PCS

CUTIE SAVAGE GEAR PT.ACCESORII SMOKE 23X11X3,5CM 2PCS

svs74233

Livrare imediată!

59,97Lei

Pilker SAVAGE GEAR Seeker ISP Sinking, Red Black, 10cm, 28g, 1buc/pac

Pilker SAVAGE GEAR Seeker ISP Sinking, Red Black, 10cm, 28g, 1buc/pac

svs55355

Livrare 7-14 zile

31,50Lei

NALUCA SAVAGE GEAR SKIRT FLIRT JIG 6.5CM/10G SINKING GREEN PUMPKIN

NALUCA SAVAGE GEAR SKIRT FLIRT JIG 6.5CM/10G SINKING GREEN PUMPKIN

f1.sg.76850

Livrare imediată!

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

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

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

svs69790

Livrare 7-14 zile

39,64Lei

Lanseta SAVAGE GEAR Defiance SG4 Inshore Spin 2.13m, 6-32g, 2seg

Lanseta SAVAGE GEAR Defiance SG4 Inshore Spin 2.13m, 6-32g, 2seg

o.sg.1601741

Livrare 24-48 ore

580,41Lei

Swimbait SAVAGE GEAR 3D Perch RTF Lure, Ghost Silver, 12.5cm, 37g

Swimbait SAVAGE GEAR 3D Perch RTF Lure, Ghost Silver, 12.5cm, 37g

1624943

Livrare 7-14 zile

41,67Lei

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

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

1625369

Livrare 7-14 zile

62,01Lei

Jig SAVAGE GEAR Ball Jighead Bulk, Nr.4/0, 25g, 25buc/pac

Jig SAVAGE GEAR Ball Jighead Bulk, Nr.4/0, 25g, 25buc/pac

1622899

Livrare 7-14 zile

144,37Lei

SAVAGE GEAR STRUNA CARBON49 TRACE 30CM 048MM/11KG

SAVAGE GEAR STRUNA CARBON49 TRACE 30CM 048MM/11KG

svs54867

Livrare imediată!

29,48Lei

Afişare 1501 - 1520 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: 126.632 ms [By time] [By id] [By file]

1 (0.095)

SELECT data
FROM `oc_session`
WHERE session_id = 'cd495752c03c7b6b25c0a60e0d'

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

2 (0.099)

SELECT `trigger`, `action`
FROM oc_event

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

3 (0.121)

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

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

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

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

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

7 (0.164)

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