Savage Gear

Savage Gear

Sortare după:

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

HUSA SAVAGE GEAR 1 LANSETA 150CM

HUSA SAVAGE GEAR 1 LANSETA 150CM

svs74151

Livrare 7-14 zile

179,96Lei

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.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, White Pearl, 8.7cm, 16g, 1buc/pac

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

svs55347

Livrare imediată!

29,48Lei

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

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

f1.sg.76846

Livrare 24-48 ore

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

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

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

svs69795

Livrare 7-14 zile

47,77Lei

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

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

1625368

Livrare 7-14 zile

62,01Lei

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

AGRAFE SAVAGE GEAR NEEDLE EGG SNAPS XS 16KG/20BUC

AGRAFE SAVAGE GEAR NEEDLE EGG SNAPS XS 16KG/20BUC

svs54918

Livrare imediată!

11,17Lei

JIG SAVAGE CORK SCREW HEADS 5G, 3BUC/PAC

JIG SAVAGE CORK SCREW HEADS 5G, 3BUC/PAC

f2.sg.50356

Livrare imediată!

10,03Lei(-17%) 8,28Lei

MINCIOG TELESCOPIC SAVAGE GEAR RUBBERIZED NET, 50X65CM/95-150CM

MINCIOG TELESCOPIC SAVAGE GEAR RUBBERIZED NET, 50X65CM/95-150CM

a2.sg.57576

Livrare 24-48 ore

290,93Lei

JACHETA SAVAGE HEATLITE THERMO MARIMEA M

JACHETA SAVAGE HEATLITE THERMO MARIMEA M

svs59125

Livrare 7-14 zile

500,25Lei

Broasca Savage Gear 3D Walk Frog, Culoare 62036, 7cm, 20g

Broasca Savage Gear 3D Walk Frog, Culoare 62036, 7cm, 20g

f1.sg.62036

Livrare 24-48 ore

46,28Lei(-37%) 29,23Lei

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

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

f1.sg.61843

Livrare imediată!

17,67Lei

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 VIB BLADE 4.5CM/8.5G PEARL WHITE

CICADA SAVAGE GEAR VIB BLADE 4.5CM/8.5G PEARL WHITE

svs71440

Livrare 7-14 zile

36,84Lei

Cleste Savage Gear Pro L 20Cm

Cleste Savage Gear Pro L 20Cm

a.sg.71888

Livrare 24-48 ore

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

Shad Savage Gear Craft Cannibal Paddletail 12.5cm 20g 3buc/plic Firetiger

Shad Savage Gear Craft Cannibal Paddletail 12.5cm 20g 3buc/plic Firetiger

svs71825

Livrare 7-14 zile

26,23Lei(-24%) 19,95Lei

Afişare 2001 - 2020 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: 113.068 ms [By time] [By id] [By file]

1 (0.107)

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

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

2 (0.100)

SELECT `trigger`, `action`
FROM oc_event

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

3 (0.131)

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

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

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

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

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

7 (0.143)

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