Savage Gear


Vobler, Savage, Gear, Gravity, Crank, MR, Roach, 7.3cm, 19g, sg.71684, Voblere Floating, Voblere Floating Savage Gear, Savage Gear -42%
LINGURITA ROTATIVA SAVAGE CAVIAR NR.3 FLUO YELLOW CHART 9.5G

LINGURITA ROTATIVA SAVAGE CAVIAR NR.3 FLUO YELLOW CHART 9.5G

f.sg.42313
Livrare 24-48 ore

23,70Lei

SHAD SAVAGE GEAR CRAFT 7.2CM 2.6G MOTOR OIL 5BUC/PLIC -40%

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

f1.sg.72407
Livrare 24-48 ore

34,90Lei(-40%) 20,94Lei

VOBLER, SAVAGE, GEAR, 3D, STICKLEBAIT, TWITCH, 5.5CM, 7G, BLACK, SILVER, sg.72314, Voblere Sinking, Voblere Sinking Savage Gear, Savage Gear
TRICOU SAVAGE GEAR SIGNATURE LOGO GREY MELANGE MAR.M -20%

TRICOU SAVAGE GEAR SIGNATURE LOGO GREY MELANGE MAR.M

a8.sg.73650
Livrare 24-48 ore

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

Lanseta Savage Gear SG4 Shore Game F 2.79cm 10-30g 2seg

Lanseta Savage Gear SG4 Shore Game F 2.79cm 10-30g 2seg

o.sg.75011
Livrare 24-48 ore

583,90Lei

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

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

f1.sg.74078
Livrare 24-48 ore

31,23Lei(-40%) 18,74Lei

VOBLER, SAVAGE, GEAR, GRAVITY, TWITCH, 8,3CM/10G, SUSPENDING, GREEN, SILVER, sg.74110, Voblere Sinking, Voblere Sinking Savage Gear, Savage Gear -20%
Hanorac Savage Gear Junior Jaw Grey Melange 14-16 ani -20%

Hanorac Savage Gear Junior Jaw Grey Melange 14-16 ani

a8.sg.76679
Livrare imediată!

224,20Lei(-20%) 179,36Lei

Shad, Savage, Gear, Cannibal,, Firecracker,, 8cm,, 5g,, 5buc/pac, f1.sg.77131, Shad-uri, Shad-uri Savage Gear, Savage Gear
Shad Savage Gear Cannibal, White Flash, 6.8cm, 3g, 5buc/pac

Shad Savage Gear Cannibal, White Flash, 6.8cm, 3g, 5buc/pac

f1.sg.77127
Livrare 24-48 ore

17,14Lei

Shad Savage Gear Fat Minnow T-Tail, Clear Water Mix, 7.5cm, 5g, 5buc/pac -20%

Shad Savage Gear Fat Minnow T-Tail, Clear Water Mix, 7.5cm, 5g, 5buc/pac

f1.sg.77007
Livrare 24-48 ore

30,38Lei(-20%) 24,30Lei

Vobler, Savage, Gear, Gravity, Minnow, Pink, Head,, 5cm,, 8g, sg.73519, Voblere Sinking, Voblere Sinking Savage Gear, Savage Gear
Lingurita, Rotativa, Savage, Gear, Spinner, Sticklebait,, Sinking,, Green, Silver, Ayu,, Nr.1,, 4.5g, sg.82233, Lingurite Rotative, Lingurite Rotative Savage Gear, Savage Gear
Shad, Savage, Gear, Craft, Bleak,, Dark, Water, Mix,, 7.0cm,, 2.5g,, 5buc/pac, f1.sg.1609140, Shad-uri, Shad-uri Savage Gear, Shad-uri Savage Gear, Savage Gear
Shad, Savage, Gear, Craft, Bleak,, PL, White, Pearl, Flash,, 10.0cm,, 6.8g,, 5buc/pac, f1.sg.1609128, Shad-uri, Shad-uri Savage Gear, Shad-uri Savage Gear, Savage Gear
SAVAGE GEAR FAT TAIL 5,5CM/9G SINKING PERCH

SAVAGE GEAR FAT TAIL 5,5CM/9G SINKING PERCH

sg.71761
Livrare imediată!

35,25Lei

Vobler, Savage, Gear, Gravity, Twitch, SR, Blue, Chrome, 6.7cm, 6g, sg.71647, Voblere Suspending, Voblere Suspending Savage Gear, Savage Gear
Vobler Savage Gear Fat Vibes Perch 6.6cm 22g

Vobler Savage Gear Fat Vibes Perch 6.6cm 22g

sg.71673
Livrare imediată!

44,03Lei

LINGURITA ROTATIVA SAVAGE ROTEX NR.1 COPPER 3.5G

LINGURITA ROTATIVA SAVAGE ROTEX NR.1 COPPER 3.5G

f.sg.42114
Livrare imediată!

16,58Lei

Afişare 1 - 20 din 1428 (72 pagini)
Queries: 9, Total time: 90.963 ms [By time] [By id] [By file]
1 (0.135)
SELECT data
FROM `oc_session`
WHERE session_id = 'eb6f1b2bfb0f4787ce9cf4cbda'
/var/www/clients/client1/web1/web/system/library/session/db.php:23
2 (0.116)
SELECT *
FROM oc_platforma_promovari LIMIT 1
/var/www/clients/client1/web1/web/index.php:128
3 (0.122)
SELECT `trigger`, `action`
FROM oc_event
/var/www/clients/client1/web1/web/index.php:422
4 (0.152)
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.147)
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
6 (35.355)
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:1661
7 (54.686)
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 = '2' 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.128)
SELECT *
FROM oc_platforma_promovari
/var/www/clients/client1/web1/web/catalog/model/common/platforma.php:4
9 (0.122)
SELECT *
FROM `oc_mxt_setting`
WHERE store_id = '2' AND name = 'lichidare_stoc'
/var/www/clients/client1/web1/web/catalog/model/catalog/category.php:38