Savage Gear

Savage Gear

Sortare după:

Chatterbait SAVAGE GEAR Crazy Swim Jig, White Silver, 20g, 12.5cm, 1buc/pac

Chatterbait SAVAGE GEAR Crazy Swim Jig, White Silver, 20g, 12.5cm, 1buc/pac

svs76741

Livrare 7-14 zile

40,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 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(-50%) 21,27Lei

Husa Savage Gear Neopren Mulineta Marime XL

Husa Savage Gear Neopren Mulineta Marime XL

svs74804

Livrare 7-14 zile

64,95Lei(-48%) 33,86Lei

Cizme Piept SAVAGE GEAR Sg8 Zip Chest Sf Waders, Marime XXLS 45-47

Cizme Piept SAVAGE GEAR Sg8 Zip Chest Sf Waders, Marime XXLS 45-47

1608947

Livrare 7-14 zile

1.855,00Lei

Jig SAVAGE GEAR Tungsten Ball Jighead, Nr.1/0, 7.2g, 2buc/pac

Jig SAVAGE GEAR Tungsten Ball Jighead, Nr.1/0, 7.2g, 2buc/pac

svs82282

Livrare 7-14 zile

30,00Lei

VOBLER SAVAGE GEAR GRAVITY TWITCH SUSPENDING MR AYU CHROME 8.3CM 10G

VOBLER SAVAGE GEAR GRAVITY TWITCH SUSPENDING MR AYU CHROME 8.3CM 10G

sg.74125

Livrare 24-48 ore

43,28Lei(-40%) 25,97Lei

NALUCA SAVAGE GEAR HARD 3D EEL MOTOR HOT TAIL 17CM 50G 2+1BUC/PLIC

NALUCA SAVAGE GEAR HARD 3D EEL MOTOR HOT TAIL 17CM 50G 2+1BUC/PLIC

f1.sg.74136

Livrare 24-48 ore

60,23Lei(-40%) 36,14Lei

LANSETA SPINNING SAVAGE GEAR 2BUC SG4 T/C FINEZZE SPEC. 2,13M/7-21G

LANSETA SPINNING SAVAGE GEAR 2BUC SG4 T/C FINEZZE SPEC. 2,13M/7-21G

o.sg.75789

Livrare 24-48 ore

440,26Lei

SHAD SAVAGE GEAR 3D RIVER ROACH 8CM 5G DARK WATER MIX 4BUC/PLIC

SHAD SAVAGE GEAR 3D RIVER ROACH 8CM 5G DARK WATER MIX 4BUC/PLIC

svs74308

Livrare 7-14 zile

42,00Lei

MULTIPLICATOR SAVAGE GEAR SG6 BC 250 LH 5+1BB/MXMM/6.6:1

MULTIPLICATOR SAVAGE GEAR SG6 BC 250 LH 5+1BB/MXMM/6.6:1

o.sg.74779

Livrare 24-48 ore

620,00Lei

Pilker SAVAGE GEAR 3D Slim Jig Minnow Fast Sinking, Saddled Bream, 10cm, 40g, 1buc/pac

Pilker SAVAGE GEAR 3D Slim Jig Minnow Fast Sinking, Saddled Bream, 10cm, 40g, 1buc/pac

svs78201

Livrare 7-14 zile

46,01Lei

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

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

svs78067

Livrare 7-14 zile

60,00Lei

JACHETA SAVAGE PRO GUARD THERMO MAS.L

JACHETA SAVAGE PRO GUARD THERMO MAS.L

a8.sg.47901

Livrare 24-48 ore

492,70Lei(-40%) 295,62Lei

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

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

1624949

Livrare 7-14 zile

52,00Lei

FIR SAVAGE SOFT FLUOROCARBON 060MM 21.6KG 20M

FIR SAVAGE SOFT FLUOROCARBON 060MM 21.6KG 20M

svs54855

Livrare imediată!

78,00Lei

Fir Savage Gear Regenerator 040MM/10KG/30M

Fir Savage Gear Regenerator 040MM/10KG/30M

a.sg.54838

Livrare 24-48 ore

26,51Lei

Vobler Savage Gear 3D Twitch Minnow Sinking SS03 8cm 8.5g

Vobler Savage Gear 3D Twitch Minnow Sinking SS03 8cm 8.5g

sg.57379

Livrare 24-48 ore

36,58Lei(-20%) 29,26Lei

Lanseta Savage Gear Finezze Dropshot 2.33m, 5-20g, 2buc

Lanseta Savage Gear Finezze Dropshot 2.33m, 5-20g, 2buc

o.sg.50183

Livrare 24-48 ore

524,69Lei(-40%) 314,81Lei

Montura Savage Gear Titan Corkscrew, 2 Ancore, Nr.1/0

Montura Savage Gear Titan Corkscrew, 2 Ancore, Nr.1/0

a.sg.61774

Livrare imediată!

43,14Lei

Afişare 2121 - 2140 din 2179 (109 pagini)

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

1 (0.093)

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

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

2 (0.111)

SELECT `trigger`, `action`
FROM oc_event

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

3 (0.110)

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

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

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

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

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

7 (0.164)

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