Savage Gear


VOBLER SAVAGE GEAR GRAVITY TWITCH SUSPENDING MR PERCH 8.3CM 10G -40%

VOBLER SAVAGE GEAR GRAVITY TWITCH SUSPENDING MR PERCH 8.3CM 10G

sg.74123
Livrare 24-48 ore

43,28Lei(-40%) 25,97Lei

Pilker SAVAGE GEAR Seeker ISP Sinking, Green Siver, 8.7cm, 16g, 1buc/pac

Pilker SAVAGE GEAR Seeker ISP Sinking, Green Siver, 8.7cm, 16g, 1buc/pac

svs55343
Livrare 7-14 zile

28,00Lei

NALUCA SAVAGE GEAR HARD 3D EEL BLUE SILVER 17CM 50G 2+1BUC/PLIC -40%

NALUCA SAVAGE GEAR HARD 3D EEL BLUE SILVER 17CM 50G 2+1BUC/PLIC

f1.sg.74132
Livrare 24-48 ore

60,23Lei(-40%) 36,14Lei

Chatterbait SAVAGE GEAR Crazy Blade Jig Head, Nr.3/0, 7g, 3buc/pac

Chatterbait SAVAGE GEAR Crazy Blade Jig Head, Nr.3/0, 7g, 3buc/pac

svs74017
Livrare 7-14 zile

36,00Lei

CUTIE SAVAGE NR.6B PT.NALUCI 35,5X23X9,2CM

CUTIE SAVAGE NR.6B PT.NALUCI 35,5X23X9,2CM

svs74226
Livrare imediată!

78,00Lei

SHAD SAVAGE GEAR 3D RIVER ROACH 10CM 10G DIRTY ROACH 4BUC/PLIC

SHAD SAVAGE GEAR 3D RIVER ROACH 10CM 10G DIRTY ROACH 4BUC/PLIC

f1.sg.74289
Livrare 24-48 ore

36,44Lei

NALUCA SAVAGE GEAR SKIRT FLIRT JIG 6.5CM/10G SINKING WHITE PEARL -60%

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

f1.sg.76853
Livrare 24-48 ore

30,84Lei(-60%) 12,34Lei

Lanseta Spinning SAVAGE GEAR Orange LTD Ultra Light 1.98m, 3-10g, 2seg

Lanseta Spinning SAVAGE GEAR Orange LTD Ultra Light 1.98m, 3-10g, 2seg

o.sg.1609539
Livrare 24-48 ore

400,27Lei

Swimbait SAVAGE GEAR 3D Perch RTF Lure, Ghost Silver, 20cm, 137g

Swimbait SAVAGE GEAR 3D Perch RTF Lure, Ghost Silver, 20cm, 137g

1634388
Livrare 7-14 zile

60,00Lei

SPINNERBAIT SAVAGE DA BUSH FIRETIGER, NR.3, 32G -40%

SPINNERBAIT SAVAGE DA BUSH FIRETIGER, NR.3, 32G

sg.44870
Livrare imediată!

54,56Lei(-40%) 32,73Lei

STRUNA SAVAGE TITANIUM7 TRACE 35CM 040MM 15KG 2BUC PLIC

STRUNA SAVAGE TITANIUM7 TRACE 35CM 040MM 15KG 2BUC PLIC

svs54876
Livrare imediată!

60,00Lei

OCHELARI POLARIZATI SAVAGE GEAR SLIM SHADES AMBER

OCHELARI POLARIZATI SAVAGE GEAR SLIM SHADES AMBER

a8.sg.57571
Livrare imediată!

113,40Lei

PANTALONI SAVAGE GREY MARIMEA S -30%

PANTALONI SAVAGE GREY MARIMEA S

a8.sg.59114
Livrare imediată!

384,77Lei(-30%) 269,34Lei

JIG SAVAGE BALL JIG HEAD TOURNAMENT NR 4/0 5G 25BUC

JIG SAVAGE BALL JIG HEAD TOURNAMENT NR 4/0 5G 25BUC

f2.sg.61921
Livrare 24-48 ore

51,18Lei

Shad Savage Gear LB Cannibal, White Black, 10cm, 9g, 4buc/plic

Shad Savage Gear LB Cannibal, White Black, 10cm, 9g, 4buc/plic

f1.sg.61854
Livrare imediată!

21,16Lei

SHAD SAVAGE LB CANNIBAL 8CM/5G/DIRY ROACH 4BUC/PLIC -20%

SHAD SAVAGE LB CANNIBAL 8CM/5G/DIRY ROACH 4BUC/PLIC

f1.sg.63800
Livrare imediată!

19,23Lei(-20%) 15,37Lei

CICADA SAVAGE GREAR SWITCH BLADE MINNOW 5CM/11G PEARL WHITE -20%

CICADA SAVAGE GREAR SWITCH BLADE MINNOW 5CM/11G PEARL WHITE

sg.63740
Livrare 24-48 ore

33,09Lei(-20%) 26,47Lei

MONTURA SAVAGE PUNCH 15G 3BUC/PLIC -40%

MONTURA SAVAGE PUNCH 15G 3BUC/PLIC

a.sg.63821
Livrare 24-48 ore

22,68Lei(-40%) 13,61Lei

LANSETA SAVAGE GEAR SPINNING 2SEG SG2 LIGHT GAME 2.21M, 3-10G, 2SEG -16%

LANSETA SAVAGE GEAR SPINNING 2SEG SG2 LIGHT GAME 2.21M, 3-10G, 2SEG

o.sg.72148
Livrare imediată!

233,17Lei(-16%) 194,76Lei

Cicada Savage Gear Vib Blade Firetiger 5.5cm 14.5g

Cicada Savage Gear Vib Blade Firetiger 5.5cm 14.5g

svs71449
Livrare imediată!

40,00Lei

Afişare 1701 - 1720 din 1908 (96 pagini)
Queries: 7, Total time: 161.996 ms [By time] [By id] [By file]
1 (0.146)
SELECT data
FROM `oc_session`
WHERE session_id = 'c5170a27593b11c373195a8dc5'
/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.114)
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.097)
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 (59.947)
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 (101.364)
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 1700,20
/var/www/clients/client1/web1/web/catalog/model/catalog/product.php:440
7 (0.229)
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