Savage Gear

Savage Gear

Sortare după:

SPINNER SAVAGE GEAR 3D STICKLEBAIT TAILSPIN 8CM 18G SINKING GREEN SILVER AYU

SPINNER SAVAGE GEAR 3D STICKLEBAIT TAILSPIN 8CM 18G SINKING GREEN SILVER AYU

sg.76818

Livrare 24-48 ore

44,03Lei(-30%) 30,82Lei

Pilker SAVAGE GEAR Squid Dealer 3.0, Phantom, 14.3g, 10cm, 1buc/pac

Pilker SAVAGE GEAR Squid Dealer 3.0, Phantom, 14.3g, 10cm, 1buc/pac

svs78083

Livrare 7-14 zile

42,00Lei

BLUZA SAVAGE GEAR REGENERATOR FLEECE KOMBU GREEN L

BLUZA SAVAGE GEAR REGENERATOR FLEECE KOMBU GREEN L

a8.sg.76534

Livrare 24-48 ore

245,62Lei

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

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

1624945

Livrare 7-14 zile

52,00Lei

FIR PENTRU STRUNA SAVAGE GEAR CARBON49 0.48MM/11KG/10M

FIR PENTRU STRUNA SAVAGE GEAR CARBON49 0.48MM/11KG/10M

svs54895

Livrare imediată!

80,00Lei

Cap Jig SAVAGE GEAR Corkscrew, 100g, 1buc/pac

Cap Jig SAVAGE GEAR Corkscrew, 100g, 1buc/pac

svs71926

Livrare 7-14 zile

30,00Lei

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

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

f2.sg.50356

Livrare imediată!

10,03Lei(-29%) 7,16Lei

Fir Struna Savage 7x7 Carbon49, Grey, 0.70mm, 23kg, 10m

Fir Struna Savage 7x7 Carbon49, Grey, 0.70mm, 23kg, 10m

a.sg.54897

Livrare 24-48 ore

81,96Lei

STRUNA SAVAGE TITANIUM7 TRACE 20CM 030MM/7KG 2BUC/PL

STRUNA SAVAGE TITANIUM7 TRACE 20CM 030MM/7KG 2BUC/PL

a7.sg.61769

Livrare 24-48 ore

42,84Lei(-40%) 25,70Lei

SHAD SAVAGE LB CANNIBAL 6.8CM/PERCH 5BUC/PLIC

SHAD SAVAGE LB CANNIBAL 6.8CM/PERCH 5BUC/PLIC

f1.sg.69948

Livrare imediată!

18,30Lei

Shad Savage Gear Craft Cannibal Paddletail 6.5cm 4g 4buc/plic Olive Pearl Silver Smolt

Shad Savage Gear Craft Cannibal Paddletail 6.5cm 4g 4buc/plic Olive Pearl Silver Smolt

f1.sg.71799

Livrare 24-48 ore

28,51Lei(-50%) 14,24Lei

SAVAGE GEAR SHAD 4D LINE THRU ROACH 18CM 80G SS GOLDEN AMBULANCE

SAVAGE GEAR SHAD 4D LINE THRU ROACH 18CM 80G SS GOLDEN AMBULANCE

f1.sg.71945

Livrare 24-48 ore

66,52Lei

BLUZA SAVAGE GEAR MARINE UV LONG SLEEVE TEE SEA BLUE MARIME M

BLUZA SAVAGE GEAR MARINE UV LONG SLEEVE TEE SEA BLUE MARIME M

a8.sg.73665

Livrare 24-48 ore

158,14Lei

Shad Savage Gear Minnow WL Green Silver 10cm 16g 3buc

Shad Savage Gear Minnow WL Green Silver 10cm 16g 3buc

f1.sg.72438

Livrare 24-48 ore

50,13Lei(-20%) 40,10Lei

Tambur Rezerva SAVAGE GEAR SGS8 FD Spare Spool, 10000FD

Tambur Rezerva SAVAGE GEAR SGS8 FD Spare Spool, 10000FD

svs73126

Livrare 7-14 zile

144,95Lei(-46%) 78,90Lei

Jig SAVAGE GEAR Tungsten Ball Jighead, Nr.1/0, 5.3g, 3buc/pac

Jig SAVAGE GEAR Tungsten Ball Jighead, Nr.1/0, 5.3g, 3buc/pac

svs82281

Livrare 7-14 zile

36,00Lei

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

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

KIT SAVAGE GEAR EASYON SPINNER BAIT SILVER MARIME S 2BUC/PLIC

KIT SAVAGE GEAR EASYON SPINNER BAIT SILVER MARIME S 2BUC/PLIC

a.sg.72288

Livrare 24-48 ore

18,74Lei(-30%) 13,13Lei

LANSETA SPINNING SAVAGE GEAR 2BUC SG4 VIB&BLADE SPEC. 2,08M/4-21G

LANSETA SPINNING SAVAGE GEAR 2BUC SG4 VIB&BLADE SPEC. 2,08M/4-21G

svs75805

Livrare 7-14 zile

597,55Lei(-20%) 478,03Lei

Pilker SAVAGE GEAR Seeker ISP Sinking, White Pearl, 9.8cm, 23cm, 1buc/pac

Pilker SAVAGE GEAR Seeker ISP Sinking, White Pearl, 9.8cm, 23cm, 1buc/pac

svs55352

Livrare 7-14 zile

28,00Lei

Afişare 1221 - 1240 din 2027 (102 pagini)

Queries: 7, Total time: 100.786 ms [By time] [By id] [By file]

1 (0.156)

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

/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.135)

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

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 = '0'

/var/www/clients/client1/web1/web/catalog/model/catalog/manufacturer.php:4

5 (39.965)

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 = '0' AND p.manufacturer_id = '85'

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

6 (60.202)

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 = '0' AND p.manufacturer_id = '85' GROUP BY p.product_id
ORDER BY p.sort_order ASC LIMIT 1220,20

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

7 (0.097)

SELECT *
FROM `oc_mxt_setting`
WHERE store_id = '0' AND name = 'lichidare_stoc'

/var/www/clients/client1/web1/web/catalog/model/catalog/category.php:37