Savage Gear

Savage Gear

Sortare după:

Hanorac SAVAGE GEAR Tec Foam Zip, Dark Grey Melange, Marimea XL

Hanorac SAVAGE GEAR Tec Foam Zip, Dark Grey Melange, Marimea XL

svs76588

Livrare 7-14 zile

314,18Lei

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

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

1601844

Livrare 7-14 zile

571,43Lei

SPINNERBAIT SAVAGE GEAR DA BUSH 14CM 21G SINKING SEXY SHAD

SPINNERBAIT SAVAGE GEAR DA BUSH 14CM 21G SINKING SEXY SHAD

sg.72606

Livrare 24-48 ore

42,54Lei(-47%) 22,63Lei

Lanseta Savage Gear SG2 Light Game 1.98m 5-18g 2SEG

Lanseta Savage Gear SG2 Light Game 1.98m 5-18g 2SEG

o.sg.72147

Livrare 24-48 ore

312,53Lei(-8%) 287,01Lei

SHAD SAVAGE GEAR BLEAK PADDLE TAIL WHITE SILVER 8CM 4G 4BUC/PLIC

SHAD SAVAGE GEAR BLEAK PADDLE TAIL WHITE SILVER 8CM 4G 4BUC/PLIC

f1.sg.61829

Livrare imediată!

19,46Lei(-24%) 14,85Lei

CUTIE SAVAGE GEAR PT.NALUCI TIP 5D 27.5X18X4.5CM

CUTIE SAVAGE GEAR PT.NALUCI TIP 5D 27.5X18X4.5CM

svs76777

Livrare imediată!

43,71Lei

SHAD SAVAGE GEAR MINNOW 10CM 20G SINKING BLUE PEARL SILVER 2 plus 1

SHAD SAVAGE GEAR MINNOW 10CM 20G SINKING BLUE PEARL SILVER 2 plus 1

f1.sg.72429

Livrare imediată!

32,69Lei(-23%) 25,30Lei

SHAD SAVAGE GEAR 3D HYBRID PIKE SLOW SINK BLUE SILVER 17CM 47G 1+2COZI/PLIC

SHAD SAVAGE GEAR 3D HYBRID PIKE SLOW SINK BLUE SILVER 17CM 47G 1+2COZI/PLIC

f1.sg.76804

Livrare 24-48 ore

88,21Lei(-58%) 36,88Lei

Pilker SAVAGE GEAR Seeker ISP Sinking, White Pearl, 10cm, 28g, 1buc/pac

Pilker SAVAGE GEAR Seeker ISP Sinking, White Pearl, 10cm, 28g, 1buc/pac

svs55357

Livrare 7-14 zile

31,50Lei

Fir Fluorocarbon SAVAGE GEAR Super Hard, Clear, 25.70kg, 0.77mm, 50m

Fir Fluorocarbon SAVAGE GEAR Super Hard, Clear, 25.70kg, 0.77mm, 50m

svs74494

Livrare 7-14 zile

173,86Lei

Sapca Savage Gear Catch One Size Olive Green Melange

Sapca Savage Gear Catch One Size Olive Green Melange

svs76691

Livrare imediată!

76,24Lei

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

Lanseta Spinning SAVAGE GEAR Orange LTD Medium Game 2.51m, 15-45g, 2seg

Lanseta Spinning SAVAGE GEAR Orange LTD Medium Game 2.51m, 15-45g, 2seg

o.sg.1609548

Livrare 24-48 ore

481,33Lei

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

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

1624946

Livrare 7-14 zile

53,87Lei

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

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

1625366

Livrare 7-14 zile

62,01Lei

Lanseta Spinning Savage Gear 2seg. SG4 Drop Shot Specialist, 2,23m/2-12g

Lanseta Spinning Savage Gear 2seg. SG4 Drop Shot Specialist, 2,23m/2-12g

svs72227

Livrare imediată!

437,21Lei

Vartej cu Rulment Savage Gear Ball Bearing M, 8buc/pac

Vartej cu Rulment Savage Gear Ball Bearing M, 8buc/pac

svs54916

Livrare imediată!

29,48Lei

Manusi SAVAGE GEAR Aqua Guard Glove XL, Black

Manusi SAVAGE GEAR Aqua Guard Glove XL, Black

svs51645

Livrare 7-14 zile

128,10Lei

FIR METALIC SAVAGE GEAR CARBON49 060MM/16KG/10M

FIR METALIC SAVAGE GEAR CARBON49 060MM/16KG/10M

a.sg.54896

Livrare 24-48 ore

79,38Lei

SET NALUCI SAVAGE CANNIBAL S 20BUC

SET NALUCI SAVAGE CANNIBAL S 20BUC

f1.sg.57614

Livrare 24-48 ore

54,90Lei

Afişare 1301 - 1320 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: 139.007 ms [By time] [By id] [By file]

1 (0.112)

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

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

2 (0.098)

SELECT `trigger`, `action`
FROM oc_event

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

3 (0.115)

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

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

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

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

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

7 (0.128)

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