Savage Gear


PILKER SAVAGE GEAR JIG PSYCHO SPRAT 10.2CM 80G SINKING WHITE SILVER

PILKER SAVAGE GEAR JIG PSYCHO SPRAT 10.2CM 80G SINKING WHITE SILVER

f2.sg.74072
Livrare imediată!

41,64Lei

SPINNER SAVAGE GEAR 3D STICKLEBAIT TAILSPIN 7.3CM 9G SINKING BROWN TROUT -30%

SPINNER SAVAGE GEAR 3D STICKLEBAIT TAILSPIN 7.3CM 9G SINKING BROWN TROUT

sg.76816
Livrare 24-48 ore

39,37Lei(-30%) 27,55Lei

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

60,00Lei

MINCIOG SAVAGE FINEZZE PLASA CAUCIUCATA 40X50X50CM

MINCIOG SAVAGE FINEZZE PLASA CAUCIUCATA 40X50X50CM

a2.sg.50802
Livrare 24-48 ore

107,65Lei

AGRAFA CU VARTEJ SAVAGE EGG SNAP NR.4 22KG 10BUC -29%

AGRAFA CU VARTEJ SAVAGE EGG SNAP NR.4 22KG 10BUC

a7.sg.54913
Livrare imediată!

12,98Lei(-29%) 9,27Lei

OCHELARI POLARIZATI SAVAGE GEAR SHADES DARK GREY

OCHELARI POLARIZATI SAVAGE GEAR SHADES DARK GREY

svs57574
Livrare imediată!

143,00Lei

SAVAGE SKULL TEC-TUBE -40%

SAVAGE SKULL TEC-TUBE

a8.sg.50839
Livrare imediată!

19,64Lei(-40%) 11,78Lei

Carlige Savage Gear Offset EWG, NR4/0/2G 3BUC/PL

Carlige Savage Gear Offset EWG, NR4/0/2G 3BUC/PL

f2.sg.61776
Livrare imediată!

39,12Lei

Shad Savage Gear LB Cannibal, Firetiger, 12.5cm, 20g, 3buc/plic

Shad Savage Gear LB Cannibal, Firetiger, 12.5cm, 20g, 3buc/plic

svs61858-bucxxx
Livrare imediată!

22,44Lei

SHAD SAVAGE LB CANNIBAL CURLTAIL 10CM/5G/PERCH 4BUC/PLIC -30%

SHAD SAVAGE LB CANNIBAL CURLTAIL 10CM/5G/PERCH 4BUC/PLIC

f1.sg.63807
Livrare 24-48 ore

24,98Lei(-30%) 17,48Lei

Foarfeca Savage Gear Magic Folding 11cm

Foarfeca Savage Gear Magic Folding 11cm

svs71894
Livrare imediată!

38,00Lei

Savage Gear Craft Cannibal Paddletail Dark Water Mix 6.5cm 4g 4buc/plic

Savage Gear Craft Cannibal Paddletail Dark Water Mix 6.5cm 4g 4buc/plic

f1.sg.71828
Livrare imediată!

31,15Lei

Cizme Piept SAVAGE GEAR Sg8 Chest Sf LS, Marime 42-44

Cizme Piept SAVAGE GEAR Sg8 Chest Sf LS, Marime 42-44

1608951
Livrare 7-14 zile

1.726,00Lei

CICADA STRIKE PRO ASTRO BLADE 5.5CM 17.7G

CICADA STRIKE PRO ASTRO BLADE 5.5CM 17.7G

sp.pjg005bc.a45e
Livrare imediată!

35,44Lei

SPINNERBAIT SAVAGE GEAR DA BUSH 16CM 32G SINKING WHITE SILVER -50%

SPINNERBAIT SAVAGE GEAR DA BUSH 16CM 32G SINKING WHITE SILVER

sg.72609
Livrare 24-48 ore

54,60Lei(-50%) 27,30Lei

Minciog Telescopic SAVAGE GEAR Full Frame Net XL Rubber XL-Mesh, 70x85x292cm

Minciog Telescopic SAVAGE GEAR Full Frame Net XL Rubber XL-Mesh, 70x85x292cm

svs69759
Livrare imediată!

437,00Lei

MULINETA SAVAGE GEAR SG2 4000 FD 5+1BB/150M/020MM/5,2:1/ GRAPH SPARE SPOOL -40%

MULINETA SAVAGE GEAR SG2 4000 FD 5+1BB/150M/020MM/5,2:1/ GRAPH SPARE SPOOL

o.sg.74721
Livrare 24-48 ore

202,09Lei(-40%) 121,25Lei

VOBLER SAVAGE GEAR GRAVITY TWITCH SUSPENDING MR PERCH 9.5CM 15G

VOBLER SAVAGE GEAR GRAVITY TWITCH SUSPENDING MR PERCH 9.5CM 15G

sg.74129
Livrare 24-48 ore

38,33Lei

Pilker SAVAGE GEAR Seeker ISP Sinking, Green Siver, 10cm, 28g, 1buc/pac

Pilker SAVAGE GEAR Seeker ISP Sinking, Green Siver, 10cm, 28g, 1buc/pac

svs55353
Livrare 7-14 zile

30,00Lei

NALUCA SAVAGE GEAR 3D SUICIDE DUCK UGLY DUCKLING 10.5CM 28G

NALUCA SAVAGE GEAR 3D SUICIDE DUCK UGLY DUCKLING 10.5CM 28G

f1.sg.71866
Livrare 24-48 ore

66,52Lei

Afişare 1501 - 1520 din 1907 (96 pagini)
Queries: 7, Total time: 109.826 ms [By time] [By id] [By file]
1 (0.195)
SELECT data
FROM `oc_session`
WHERE session_id = 'dc17019ad63dfc40d91667c4bc'
/var/www/clients/client1/web1/web/system/library/session/db.php:24
2 (0.197)
SELECT `trigger`, `action`
FROM oc_event
/var/www/clients/client1/web1/web/index.php:453
3 (0.166)
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.145)
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 (42.460)
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 (66.552)
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 1500,20
/var/www/clients/client1/web1/web/catalog/model/catalog/product.php:440
7 (0.111)
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