Savage Gear

Savage Gear

Sortare după:

Chatterbait SAVAGE GEAR Crazy Swim Jig, Black N Red, 10cm, 8.5g, 1buc/pac

Chatterbait SAVAGE GEAR Crazy Swim Jig, Black N Red, 10cm, 8.5g, 1buc/pac

svs76735

Livrare imediată!

37,61Lei

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

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

svs74411

Livrare imediată!

32,36Lei

Grub Savage Gear, Green Pumpkin, 6.5cm, 2.0g, 8buc/pac

Grub Savage Gear, Green Pumpkin, 6.5cm, 2.0g, 8buc/pac

svs74317

Livrare 7-14 zile

32,36Lei

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

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

1624948

Livrare 7-14 zile

53,87Lei

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

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

svs74415

Livrare 7-14 zile

33,54Lei

MANUSI SAVAGE GEAR PRO TEC CU DEGETE TAIATE MARIME M

MANUSI SAVAGE GEAR PRO TEC CU DEGETE TAIATE MARIME M

a8.sg.43848

Livrare 24-48 ore

81,78Lei(-17%) 67,52Lei

FIR SAVAGE SOFT FLUOROCARBON 074MM/28.7KG/20M

FIR SAVAGE SOFT FLUOROCARBON 074MM/28.7KG/20M

svs54856

Livrare 7-14 zile

105,73Lei

Inele Despicate SAVAGE GEAR Stainless SR Forged SS, 14mm, 73kg, 20buc/pac

Inele Despicate SAVAGE GEAR Stainless SR Forged SS, 14mm, 73kg, 20buc/pac

svs72140

Livrare 7-14 zile

19,30Lei

SHAD SAVAGE LB CANNIBAL 8CM/5G/PIKE/1BUC/PL

SHAD SAVAGE LB CANNIBAL 8CM/5G/PIKE/1BUC/PL

f1.sg.58988-bucxxx

Livrare imediată!

4,76Lei

Inele Despicate SAVAGE GEAR Broken Rings Splitring, 7mm, 47kg, 10buc/pac

Inele Despicate SAVAGE GEAR Broken Rings Splitring, 7mm, 47kg, 10buc/pac

svs73955

Livrare 7-14 zile

21,34Lei

Fir Monofilament Savage Gear Regenerator 0.70mm 26kg 30m

Fir Monofilament Savage Gear Regenerator 0.70mm 26kg 30m

svs54841

Livrare imediată!

30,49Lei

Shad SAVAGE GEAR XX Shad Savage 4D Herring, Perch, 16cm, 28g, 2buc/pac

Shad SAVAGE GEAR XX Shad Savage 4D Herring, Perch, 16cm, 28g, 2buc/pac

f1.sg.57461

Livrare imediată!

32,75Lei(-26%) 24,32Lei

STRUNA SAVAGE TITANIUM7 TRACE 30CM 060MM/23KG 2BUC/PL

STRUNA SAVAGE TITANIUM7 TRACE 30CM 060MM/23KG 2BUC/PL

svs61771

Livrare imediată!

49,82Lei

SHAD SAVAGE 4D LINE THRU PULSETAIL TROUT 16CM/51G RAINBOW

SHAD SAVAGE 4D LINE THRU PULSETAIL TROUT 16CM/51G RAINBOW

svs61975

Livrare imediată!

78,27Lei

SHAD SAVAGE LB CANNIBAL 12.5CM/PERCH 3BUC/PLIC

SHAD SAVAGE LB CANNIBAL 12.5CM/PERCH 3BUC/PLIC

f1.sg.69972

Livrare imediată!

15,84Lei

CLESTE SAVAGE GEAR MP CUT CRIMP S 22.5CM

CLESTE SAVAGE GEAR MP CUT CRIMP S 22.5CM

svs71892

Livrare imediată!

70,14Lei

Spinnerbait Savage Gear Da Bush Fluo Orange 14cm 21g

Spinnerbait Savage Gear Da Bush Fluo Orange 14cm 21g

sg.71755

Livrare 24-48 ore

41,79Lei(-47%) 22,24Lei

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

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

f1.sg.71810

Livrare imediată!

25,42Lei(-55%) 11,34Lei

Cap De Jig SAVAGE GEAR Corkscrew, 6g, 3buc/pac

Cap De Jig SAVAGE GEAR Corkscrew, 6g, 3buc/pac

svs74144

Livrare imediată!

15,25Lei

SAPCA SAVAGE SPORTS MESH ONE SIZE BLACK INK

SAPCA SAVAGE SPORTS MESH ONE SIZE BLACK INK

svs73710

Livrare 7-14 zile

76,24Lei

Afişare 2001 - 2020 din 2134 (107 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: 112.157 ms [By time] [By id] [By file]

1 (0.093)

SELECT data
FROM `oc_session`
WHERE session_id = '34a25ac27a43f0d7725e867089'

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

2 (0.068)

SELECT `trigger`, `action`
FROM oc_event

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

3 (0.086)

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

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

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

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

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

7 (0.113)

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