Savage Gear

Savage Gear

Sortare după:

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

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

svs71867

Livrare 7-14 zile

78,27Lei

Shad Savage Gear Craft Cannibal Paddletail 6.5cm 4g 4buc/plic Green Silver

Shad Savage Gear Craft Cannibal Paddletail 6.5cm 4g 4buc/plic Green Silver

svs71797

Livrare imediată!

30,00Lei

Broasca SAVAGE GEAR 3D Pop Frog, Brown, 7cm, 20g, 1buc/pac

Broasca SAVAGE GEAR 3D Pop Frog, Brown, 7cm, 20g, 1buc/pac

svs62030

Livrare imediată!

45,74Lei

SHAD SAVAGE GEAR DYING MINNOW 10CM 5.5G ROACH 5 buc/plic

SHAD SAVAGE GEAR DYING MINNOW 10CM 5.5G ROACH 5 buc/plic

svs71939

Livrare 7-14 zile

37,30Lei

BLUZA SAVAGE GEAR MARINE UV LONG SLEEVE TEE SEA BLUE MARIME XXL

BLUZA SAVAGE GEAR MARINE UV LONG SLEEVE TEE SEA BLUE MARIME XXL

svs73668

Livrare 7-14 zile

173,86Lei

Minciog Telescopic SAVAGE GEAR Full Frame Rubber Mesh Landing Net, 65x70x99/165cm

Minciog Telescopic SAVAGE GEAR Full Frame Rubber Mesh Landing Net, 65x70x99/165cm

svs71106

Livrare imediată!

299,93Lei

Cizme Piept SAVAGE GEAR Sg8 Chest Sf L, Marime 42-44

Cizme Piept SAVAGE GEAR Sg8 Chest Sf L, Marime 42-44

1608952

Livrare 7-14 zile

1.756,01Lei

NALUCA SAVAGE GEAR 3D CRAYFISH RATTLING 6.7CM 2.9G MOTOR OIL

NALUCA SAVAGE GEAR 3D CRAYFISH RATTLING 6.7CM 2.9G MOTOR OIL

f1.sg.72598

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

HUSA SAVAGE GEAR 1 LANSETA 140CM

HUSA SAVAGE GEAR 1 LANSETA 140CM

svs74150

Livrare 7-14 zile

171,82Lei

Fir fluorocarbon Savage Gear Super Hard Fluorocarbon 0.55mm 14.90kg 50m

Fir fluorocarbon Savage Gear Super Hard Fluorocarbon 0.55mm 14.90kg 50m

a.sg.74491

Livrare 24-48 ore

98,70Lei(-48%) 51,18Lei

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

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

svs76773

Livrare imediată!

39,64Lei

CUTIE SAVAGE GEAR PT.NALUCI TIP 1B SMOKE 13,8X7,7X3,1CM

CUTIE SAVAGE GEAR PT.NALUCI TIP 1B SMOKE 13,8X7,7X3,1CM

svs76768

Livrare imediată!

18,30Lei

Pilker SAVAGE GEAR Seeker ISP Sinking, Black Pearl, 8.7cm, 16g, 1buc/pac

Pilker SAVAGE GEAR Seeker ISP Sinking, Black Pearl, 8.7cm, 16g, 1buc/pac

svs55346

Livrare 7-14 zile

29,48Lei

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

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

f1.sg.76841

Livrare 24-48 ore

28,44Lei(-56%) 12,57Lei

BLUZA SAVAGE GEAR SIGNATURE LOGO LONG SLEEVE BLACK CAVIAR MAR.L

svs73910

Livrare 7-14 zile

101,66Lei

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

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

svs69791

Livrare 7-14 zile

47,77Lei

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

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

1625358

Livrare 7-14 zile

49,82Lei

Jig SAVAGE GEAR Ned Jig Head Fishing Hook, Matt Black, 7g, Nr.2/0, 3buc/pac

Jig SAVAGE GEAR Ned Jig Head Fishing Hook, Matt Black, 7g, Nr.2/0, 3buc/pac

svs74416

Livrare 7-14 zile

33,54Lei

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

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

svs54867

Livrare imediată!

29,48Lei

Afişare 2081 - 2100 din 2153 (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: 105.688 ms [By time] [By id] [By file]

1 (0.132)

SELECT data
FROM `oc_session`
WHERE session_id = '2a29195126f2e18a045c17c51a'

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

2 (0.069)

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.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 = '3'

/var/www/clients/client1/web1/web/catalog/model/catalog/manufacturer.php:4

5 (41.304)

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 = '3' AND p.manufacturer_id = '85'

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

6 (63.788)

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 = '3' AND p.manufacturer_id = '85' GROUP BY p.product_id
ORDER BY p.sort_order ASC LIMIT 2080,20

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

7 (0.132)

SELECT *
FROM `oc_mxt_setting`
WHERE store_id = '3' AND name = 'lichidare_stoc'

/var/www/clients/client1/web1/web/catalog/model/catalog/category.php:37