Savage Gear


VOBLER SAVAGE GEAR GRAVITY TWITCH 8,3CM/10G SUSPENDING MINNOW -20%

VOBLER SAVAGE GEAR GRAVITY TWITCH 8,3CM/10G SUSPENDING MINNOW

sg.74112
Livrare 24-48 ore

44,98Lei(-20%) 35,99Lei

FES SAVAGE FOLD UP ONE SIZE SUN ORANGE

FES SAVAGE FOLD UP ONE SIZE SUN ORANGE

a8.sg.73742
Livrare 24-48 ore

51,17Lei

Hanorac, Savage, Gear, Junior, Logo, Black, Ink, 12-14, ani, a8.sg.76681, Hanorace, Hanorace Savage Gear, Savage Gear -20%

Hanorac, Savage, Gear, Junior, Logo, Black, Ink, 12-14, ani, a8.sg.76681, Hanorace, Hanorace Savage Gear, Savage Gear

a8.sg.76681
Livrare imediată!

236,70Lei(-20%) 189,00Lei

Shad, Savage, Gear, Cannibal,, Flou, Yellow, Glow,, 12.5cm,, 20g,, 4buc/pac, f1.sg.77158, Shad-uri, Shad-uri Savage Gear, Savage Gear
Shad, Savage, Gear, Cannibal,, Clearwater, Mix,, 10cm,, 9g, +, 10g,, Nr.3/0,, 4buc/pac, f1.sg.77184, Shad-uri, Shad-uri Savage Gear, Savage Gear
Shad Savage Gear Fat Minnow T-Tail, Dark Water Mix, 10.5cm, 11g, 5buc/pac -20%

Shad Savage Gear Fat Minnow T-Tail, Dark Water Mix, 10.5cm, 11g, 5buc/pac

f1.sg.77010
Livrare imediată!

39,73Lei(-20%) 31,78Lei

Vobler, Savage, Gear, Shrimp, Twith, SR, Fire,, 5.2cm,, 5.5g, sg.77024, Voblere Suspending, Voblere Suspending Savage Gear, Savage Gear
Lingurita Rotativa Savage Gear Spinner Sticklebait, Sinking, Firetiger Gold, Nr.1, 4.5g

Lingurita Rotativa Savage Gear Spinner Sticklebait, Sinking, Firetiger Gold, Nr.1, 4.5g

sg.82235
Livrare 24-48 ore

28,60Lei

Shad, Savage, Gear, Craft, Bleak,, Firecracker,, 7.0cm,, 2.5g,, 5buc/pac, f1.sg.1609101, Shad-uri, Shad-uri Savage Gear, Shad-uri Savage Gear, Savage Gear
SAVAGE GEAR FAT TAIL 6,5CM/16G SINKING WHITE SILVER

SAVAGE GEAR FAT TAIL 6,5CM/16G SINKING WHITE SILVER

sg.71763
Livrare imediată!

37,41Lei

Vobler, Savage, Gear, Gravity, Twitch, SR, Perch, 6.7cm, 6g, sg.71649, Voblere Suspending, Voblere Suspending Savage Gear, Savage Gear
Vobler, Savage, Gear, Gravity, Crank, MR, Firetiger, 7.3cm, 19g, sg.71686, Voblere Floating, Voblere Floating Savage Gear, Savage Gear -40%
SHAD SAVAGE GEAR CRAFT 8.8CM/4.2G ROACH 5BUC/PLIC -40%

SHAD SAVAGE GEAR CRAFT 8.8CM/4.2G ROACH 5BUC/PLIC

f1.sg.72409
Livrare 24-48 ore

36,85Lei(-40%) 22,11Lei

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

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

sg.72316
Livrare imediată!

44,03Lei

TRICOU SAVAGE GEAR SIGNATURE LOGO GREY MELANGE MAR.XL -20%

TRICOU SAVAGE GEAR SIGNATURE LOGO GREY MELANGE MAR.XL

a8.sg.73652
Livrare 24-48 ore

98,06Lei(-20%) 78,44Lei

MULINETA SAVAGE GEAR SG6 2500H FD 8RUL/150MX020/6,2:1

MULINETA SAVAGE GEAR SG6 2500H FD 8RUL/150MX020/6,2:1

o.sg.74736
Livrare imediată!

416,95Lei

Shad SAVAGE GEAR CRAFT 7,2CM/2,6G BLUE PEARL 4BUC/PL -40%

Shad SAVAGE GEAR CRAFT 7,2CM/2,6G BLUE PEARL 4BUC/PL

f1.sg.74080
Livrare 24-48 ore

29,00Lei(-40%) 17,40Lei

SHAD SAVAGE GEAR GOBSTER 11.5CM 16G GREEN PEARL 5BUC/PLIC -40%

SHAD SAVAGE GEAR GOBSTER 11.5CM 16G GREEN PEARL 5BUC/PLIC

f1.sg.76947
Livrare 24-48 ore

30,70Lei(-40%) 18,42Lei

COSTUM, SAVAGE, GEAR, SG2, THERMAL, BLUENIGHTS/BLACK, L, a8.sg.76592, Costume, Costume Savage Gear, Savage Gear -20%

COSTUM, SAVAGE, GEAR, SG2, THERMAL, BLUENIGHTS/BLACK, L, a8.sg.76592, Costume, Costume Savage Gear, Savage Gear

a8.sg.76592
Livrare 24-48 ore

970,46Lei(-20%) 776,37Lei

Shad, Savage, Gear, Cannibal,, Chartreuse, Pumpkin,, 10cm,, 9g,, 5buc/pac, f1.sg.77146, Shad-uri, Shad-uri Savage Gear, Savage Gear
Afişare 1 - 20 din 1428 (72 pagini)
Queries: 9, Total time: 93.197 ms [By time] [By id] [By file]
1 (0.139)
SELECT data
FROM `oc_session`
WHERE session_id = '907b0e499ca13c3923587da094'
/var/www/clients/client1/web1/web/system/library/session/db.php:23
2 (0.089)
SELECT *
FROM oc_platforma_promovari LIMIT 1
/var/www/clients/client1/web1/web/index.php:128
3 (0.067)
SELECT `trigger`, `action`
FROM oc_event
/var/www/clients/client1/web1/web/index.php:422
4 (0.097)
SELECT *
FROM oc_url_alias
WHERE keyword = 'savage-gear.html'
/var/www/clients/client1/web1/web/catalog/controller/common/seo_url.php:48
5 (0.094)
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 = '3'
/var/www/clients/client1/web1/web/catalog/model/catalog/manufacturer.php:4
6 (37.540)
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 = '3' AND p.manufacturer_id = '85'
/var/www/clients/client1/web1/web/catalog/model/catalog/product.php:1661
7 (55.002)
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, (SELECT price
FROM oc_product_special ps
WHERE ps.product_id = p.product_id AND ps.customer_group_id = '1' AND ((ps.date_start = '0000-00-00' OR ps.date_start < NOW()) AND (ps.date_end = '0000-00-00' OR ps.date_end > NOW()))
ORDER BY ps.priority ASC, ps.price ASC LIMIT 1) AS special, p.viewed, p.price
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 = '3' AND p.manufacturer_id = '85' GROUP BY p.product_id
ORDER BY p.sort_order ASC LIMIT 0,20
/var/www/clients/client1/web1/web/catalog/model/catalog/product.php:438
8 (0.089)
SELECT *
FROM oc_platforma_promovari
/var/www/clients/client1/web1/web/catalog/model/common/platforma.php:4
9 (0.080)
SELECT *
FROM `oc_mxt_setting`
WHERE store_id = '3' AND name = 'lichidare_stoc'
/var/www/clients/client1/web1/web/catalog/model/catalog/category.php:38