Savage Gear

Savage Gear

Sortare după:

SHAD SAVAGE LB 4D HERRING 11CM/9G/FIRETIGER 4BUC/PLIC

SHAD SAVAGE LB 4D HERRING 11CM/9G/FIRETIGER 4BUC/PLIC

f1.sg.63660

Livrare 24-48 ore

38,01Lei(-20%) 30,40Lei

Vobler Savage Gear 3D Goby Crank Culoare 62159 4cm 3.5g

Vobler Savage Gear 3D Goby Crank Culoare 62159 4cm 3.5g

sg.62159

Livrare imediată!

42,05Lei(-30%) 29,44Lei

SAPCA SAVAGE SALT UV

SAPCA SAVAGE SALT UV

a8.sg.62279

Livrare 24-48 ore

81,40Lei

FOARFECA SAVAGE GEAR 11CM

FOARFECA SAVAGE GEAR 11CM

svs71893

Livrare imediată!

30,00Lei

Spinnerbait Savage Gear Da Bush Fluo Orange 14cm 21g

Spinnerbait Savage Gear Da Bush Fluo Orange 14cm 21g

sg.71755

Livrare 24-48 ore

41,79Lei(-40%) 25,07Lei

Shad Savage Gear Craft Cannibal Paddletail 6.5cm 4g 4buc/plic Golden Ambulance

Shad Savage Gear Craft Cannibal Paddletail 6.5cm 4g 4buc/plic Golden Ambulance

f1.sg.71802

Livrare imediată!

14,23Lei(-20%) 11,38Lei

Lanseta Savage Gear SG2 Ultra Light Game 1.98m 2-8g 2seg

Lanseta Savage Gear SG2 Ultra Light Game 1.98m 2-8g 2seg

o.sg.72145

Livrare 24-48 ore

335,51Lei(-20%) 268,40Lei

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

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

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

1608945

Livrare 7-14 zile

1.855,00Lei

Fir Fluorocarbon Savage Gear Semi Soft LRF 0.19mm 30m 2.22kg

Fir Fluorocarbon Savage Gear Semi Soft LRF 0.19mm 30m 2.22kg

svs74497

Livrare imediată!

26,00Lei

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 SGS8 8000

MULINETA SAVAGE GEAR SGS8 8000

o.sg.74764

Livrare 24-48 ore

624,30Lei(-40%) 374,58Lei

BLUZA SAVAGE GEAR TOURNAMENT GEAR BLACK INK MARIME S

BLUZA SAVAGE GEAR TOURNAMENT GEAR BLACK INK MARIME S

a8.sg.73682

Livrare 24-48 ore

199,82Lei

Pilker SAVAGE GEAR 3D Slim Jig Minnow Fast Sinking, FS BG, 12.5cm, 60g, 1buc/pac

Pilker SAVAGE GEAR 3D Slim Jig Minnow Fast Sinking, FS BG, 12.5cm, 60g, 1buc/pac

svs78206

Livrare 7-14 zile

50,00Lei

HUSA SAVAGE GEAR TWIN 140CM PT 2 LANSETE

HUSA SAVAGE GEAR TWIN 140CM PT 2 LANSETE

a8.sg.74253

Livrare 24-48 ore

244,38Lei

Jig Savage Gear Minnow 1/0 14g 3buc/plic

Jig Savage Gear Minnow 1/0 14g 3buc/plic

f2.sg.72450

Livrare 24-48 ore

40,91Lei(-60%) 16,37Lei

SPINNER SAVAGE GEAR 3D STICKLEBAIT TAILSPIN 7.3CM 13G SINKING BLACK RED

SPINNER SAVAGE GEAR 3D STICKLEBAIT TAILSPIN 7.3CM 13G SINKING BLACK RED

sg.76815

Livrare 24-48 ore

39,37Lei(-30%) 27,55Lei

Swimbait SAVAGE GEAR 3D Perch RTF Lure, Ghost Silver, 20cm, 137g

Swimbait SAVAGE GEAR 3D Perch RTF Lure, Ghost Silver, 20cm, 137g

1634388

Livrare 7-14 zile

60,00Lei

Protecite Lansete SAVAGE GEAR Neoprene Rod Tip/Butt Protector

Protecite Lansete SAVAGE GEAR Neoprene Rod Tip/Butt Protector

1622901

Livrare 7-14 zile

64,00Lei

NALUCA SAVAGE GEAR 3D SUICIDE DUCK 10,5CM/28G 02

NALUCA SAVAGE GEAR 3D SUICIDE DUCK 10,5CM/28G 02

svs53731

Livrare imediată!

68,00Lei

Afişare 1781 - 1800 din 1899 (95 pagini)

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

1 (0.078)

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

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

2 (0.079)

SELECT `trigger`, `action`
FROM oc_event

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

3 (0.127)

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

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

5 (40.887)

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:1699

6 (69.520)

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

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

7 (0.133)

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

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