Savage Gear

Savage Gear

Sortare după:

Carlige Offset Savage Gear EWG Nr.10/0 5g 2buc

Carlige Offset Savage Gear EWG Nr.10/0 5g 2buc

f2.sg.61779

Livrare 24-48 ore

41,68Lei

SHAD SAVAGE 4D LINE THRU PULSETAIL TROUT 16CM/51G RAINBOW

SHAD SAVAGE 4D LINE THRU PULSETAIL TROUT 16CM/51G RAINBOW

svs61975

Livrare imediată!

78,27Lei

SHAD SAVAGE LB CANNIBAL 12.5CM/PERCH 3BUC/PLIC

SHAD SAVAGE LB CANNIBAL 12.5CM/PERCH 3BUC/PLIC

f1.sg.69972

Livrare imediată!

15,84Lei

Shad Savage Gear Craft Cannibal Paddletail 8.5cm 7g 4buc/plic Roach

Shad Savage Gear Craft Cannibal Paddletail 8.5cm 7g 4buc/plic Roach

f1.sg.71803

Livrare 24-48 ore

25,42Lei(-31%) 17,42Lei

Lanseta Savage Gear SG2 Shore Game 274cm 10-30g 2seg

Lanseta Savage Gear SG2 Shore Game 274cm 10-30g 2seg

o.sg.72175

Livrare 24-48 ore

404,30Lei(-28%) 289,69Lei

SAPCA SAVAGE GEAR FLEX FIT CAMO ONE SIZE CAMO GREY

SAPCA SAVAGE GEAR FLEX FIT CAMO ONE SIZE CAMO GREY

svs73714

Livrare 7-14 zile

76,24Lei

CICADA SAVAGE GEAR 4D VIB BLADE SW 3.5CM 4G FAST SINKING GREEN MACKEREL

CICADA SAVAGE GEAR 4D VIB BLADE SW 3.5CM 4G FAST SINKING GREEN MACKEREL

sg.73570

Livrare imediată!

34,67Lei

SPINNERBAIT SAVAGE GEAR DA BUSH 14CM 21G SINKING YELLOW WHITE SILVER

SPINNERBAIT SAVAGE GEAR DA BUSH 14CM 21G SINKING YELLOW WHITE SILVER

sg.72604

Livrare 24-48 ore

42,54Lei(-45%) 23,53Lei

Ghete SAVAGE GEAR Sg8 Wading Boot Felt, Nr.45

Ghete SAVAGE GEAR Sg8 Wading Boot Felt, Nr.45

1601851

Livrare 7-14 zile

571,43Lei

MULINETA SAVAGE GEAR SGS6 5000 FD 6+1BB

MULINETA SAVAGE GEAR SGS6 5000 FD 6+1BB

o.sg.74754

Livrare 24-48 ore

511,87Lei(-39%) 314,20Lei

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

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

svs82294

Livrare 7-14 zile

37,61Lei

VOBLER SAVAGE GEAR GRAVITY TWITCH SUSPENDING MR DIRTY ROACH 9.5CM 15G

VOBLER SAVAGE GEAR GRAVITY TWITCH SUSPENDING MR DIRTY ROACH 9.5CM 15G

sg.74130

Livrare 24-48 ore

40,89Lei

PILKER SAVAGE GEAR 3D SLIM JIG MINNOW 17CM/150G FAST SINKING BONE WHITE GLOW PHP

PILKER SAVAGE GEAR 3D SLIM JIG MINNOW 17CM/150G FAST SINKING BONE WHITE GLOW PHP

sg.74455

Livrare 24-48 ore

79,88Lei(-47%) 42,53Lei

Rac Savage Gear 4D Craw Summer Craw 7.5cm 5.5g 6buc/plic

Rac Savage Gear 4D Craw Summer Craw 7.5cm 5.5g 6buc/plic

f1.sg.77462

Livrare 24-48 ore

29,87Lei

Husa lansete Savage Gear Twin 2 compartimente 120cm

Husa lansete Savage Gear Twin 2 compartimente 120cm

svs74252

Livrare 7-14 zile

221,65Lei

PILKER JIG SAVAGE GEAR PENCIL MICRO Z 4.5CM 8G S HOLO PINK GLOW

PILKER JIG SAVAGE GEAR PENCIL MICRO Z 4.5CM 8G S HOLO PINK GLOW

sg.77396

Livrare 24-48 ore

37,03Lei

Pilker SAVAGE GEAR Powerglow EGI, Culoare Blue, 17.2g, 10cm, 1buc/pac

Pilker SAVAGE GEAR Powerglow EGI, Culoare Blue, 17.2g, 10cm, 1buc/pac

svs78093

Livrare 7-14 zile

47,77Lei

Pilker SAVAGE GEAR Super Cast EGI ND3.0, White Spirit, 17g, 10.5cm, 1buc/pac

Pilker SAVAGE GEAR Super Cast EGI ND3.0, White Spirit, 17g, 10.5cm, 1buc/pac

svs78068

Livrare 7-14 zile

62,01Lei

Lanseta Spinning Savage Gear Revange SG6 Medium Game 2.43m, 12-35g, 2seg

Lanseta Spinning Savage Gear Revange SG6 Medium Game 2.43m, 12-35g, 2seg

o.sg.1601806

Livrare 24-48 ore

905,20Lei

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

53,87Lei

Afişare 1921 - 1940 din 2170 (109 pagini)

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

1 (0.141)

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

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

2 (0.112)

SELECT `trigger`, `action`
FROM oc_event

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

3 (0.134)

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

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

5 (52.719)

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

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

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

7 (0.132)

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