Savage Gear


Lanseta SAVAGE GEAR SG4 M Game M, 2.43m, 10-30g, 2seg

Lanseta SAVAGE GEAR SG4 M Game M, 2.43m, 10-30g, 2seg

svs75764
Livrare 7-14 zile

489,99Lei

Lanseta SAVAGE GEAR Revenge SG6 Medium Game Baitcast, 15-45g, 2.13m, 2buc

Lanseta SAVAGE GEAR Revenge SG6 Medium Game Baitcast, 15-45g, 2.13m, 2buc

1601803
Livrare 7-14 zile

908,01Lei

Spinnerbait SAVAGE GEAR DA Bush, Yellow White Silver, 42g, 18cm, 1buc/pac

Spinnerbait SAVAGE GEAR DA Bush, Yellow White Silver, 42g, 18cm, 1buc/pac

svs72616
Livrare 7-14 zile

68,00Lei

Lingurtia Rotativa SAVAGE GEAR Sticklebait Spinner 3, GS AYU, 9.1g, 1buc/pac

Lingurtia Rotativa SAVAGE GEAR Sticklebait Spinner 3, GS AYU, 9.1g, 1buc/pac

svs82245
Livrare 7-14 zile

28,00Lei

Lingurtia Rotativa SAVAGE GEAR Grub Spinners, Cooper Red Yellow, Nr.0, 2.2g, 1buc/pac

Lingurtia Rotativa SAVAGE GEAR Grub Spinners, Cooper Red Yellow, Nr.0, 2.2g, 1buc/pac

svs82455
Livrare 7-14 zile

21,00Lei

Vobler Savage Gear Gravity Crank MR Dirty Roach 5.8cm 9g -40%

Vobler Savage Gear Gravity Crank MR Dirty Roach 5.8cm 9g

sg.71682
Livrare 24-48 ore

41,83Lei(-40%) 25,10Lei

TRICOU SAVAGE CANNIBAL INK GREY MELANGE MARIME L

TRICOU SAVAGE CANNIBAL INK GREY MELANGE MARIME L

a8.sg.71600
Livrare imediată!

83,59Lei

Spinnertail SAVAGE GEAR Sticklebait Tail Spin Sinking, Green Silver Ayu, 8cm, 18g, 1buc/pac

Spinnertail SAVAGE GEAR Sticklebait Tail Spin Sinking, Green Silver Ayu, 8cm, 18g, 1buc/pac

svs76818
Livrare 7-14 zile

43,99Lei

Vobler SAVAGE GEAR Deviator Swim SS Glider, Roach, 12.5cm, 50g, 1buc/pac

Vobler SAVAGE GEAR Deviator Swim SS Glider, Roach, 12.5cm, 50g, 1buc/pac

svs69873
Livrare 7-14 zile

64,00Lei

SHAD SAVAGE GEAR CRAFT 7.2CM 2.6G FIRETIGER 5BUC/PLIC -50%

SHAD SAVAGE GEAR CRAFT 7.2CM 2.6G FIRETIGER 5BUC/PLIC

f1.sg.72405
Livrare 24-48 ore

34,90Lei(-50%) 17,45Lei

Jacheta SAVAGE GEAR Reflection Hybrid Jacket S, Black-Gray -42%

Jacheta SAVAGE GEAR Reflection Hybrid Jacket S, Black-Gray

svs76559
Livrare 7-14 zile

499,95Lei(-42%) 288,55Lei

HANORAC SAVAGE GEAR COSMO BLACK INK MARIME XXL

HANORAC SAVAGE GEAR COSMO BLACK INK MARIME XXL

a8.sg.73701
Livrare 24-48 ore

213,19Lei

Shad Savage Gear Craft Bleak, Lemon Glow Firetail, 7.0cm, 2.5g, 5buc/pac

Shad Savage Gear Craft Bleak, Lemon Glow Firetail, 7.0cm, 2.5g, 5buc/pac

1609107
Livrare imediată!

25,00Lei

VOBLER SAVAGE GEAR 3D STICKLEBAIT TWITCH 5.5CM 7G BROWN TROUT SMOLT

VOBLER SAVAGE GEAR 3D STICKLEBAIT TWITCH 5.5CM 7G BROWN TROUT SMOLT

svs72316
Livrare imediată!

43,99Lei

Ancore Triple SAVAGE GEAR SGY 1X Treble, Nr.2/0, 6buc/pac

Ancore Triple SAVAGE GEAR SGY 1X Treble, Nr.2/0, 6buc/pac

svs76725
Livrare 7-14 zile

30,00Lei

Naluca SAVAGE GEAR Swim Squid LRF, Horny Squid, 0.8g, 5cm, 5buc/pac

Naluca SAVAGE GEAR Swim Squid LRF, Horny Squid, 0.8g, 5cm, 5buc/pac

svs77337
Livrare imediată!

42,00Lei

MANUSI SAVAGE GEAR CU DEGETE TAIATE WIND PRO BLACK MAR.XL -50%

MANUSI SAVAGE GEAR CU DEGETE TAIATE WIND PRO BLACK MAR.XL

a8.sg.76473
Livrare 24-48 ore

66,47Lei(-50%) 33,22Lei

Shad SAVAGE GEAR Collapser, Caramello, 12g, 14cm, 3buc/pac

Shad SAVAGE GEAR Collapser, Caramello, 12g, 14cm, 3buc/pac

1623203
Livrare 7-14 zile

32,00Lei

Vobler SAVAGE GEAR Petit G Crank SR Floating, Bone, 4cm, 4.3g, 1buc/pac

Vobler SAVAGE GEAR Petit G Crank SR Floating, Bone, 4cm, 4.3g, 1buc/pac

1610668
Livrare 7-14 zile

36,00Lei

SHORT SAVAGE GEAR MARINE SEA BLUE MAR.XL -40%

SHORT SAVAGE GEAR MARINE SEA BLUE MAR.XL

a8.sg.73917
Livrare 24-48 ore

189,94Lei(-40%) 113,95Lei

Afişare 281 - 300 din 1907 (96 pagini)
Queries: 7, Total time: 124.020 ms [By time] [By id] [By file]
1 (0.121)
SELECT data
FROM `oc_session`
WHERE session_id = '28dc14325e014d1ceb76a286ee'
/var/www/clients/client1/web1/web/system/library/session/db.php:24
2 (0.070)
SELECT `trigger`, `action`
FROM oc_event
/var/www/clients/client1/web1/web/index.php:453
3 (0.096)
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.092)
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 (46.615)
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.894)
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 280,20
/var/www/clients/client1/web1/web/catalog/model/catalog/product.php:440
7 (0.132)
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