Savage Gear

Savage Gear

Sortare după:

Pilker SAVAGE GEAR 3D Sinking Sandeel, Ghost, 23g, 13.5cm, 1buc/pac

Pilker SAVAGE GEAR 3D Sinking Sandeel, Ghost, 23g, 13.5cm, 1buc/pac

1610620

Livrare 7-14 zile

45,74Lei

FIR FLUOROCARBON SAVAGE GEAR 026MM/4,7KG/50M

FIR FLUOROCARBON SAVAGE GEAR 026MM/4,7KG/50M

svs54849

Livrare imediată!

55,91Lei

Jig Offset SAVAGE GEAR Weedlees EWG Hooks, Nr.8/0, 3buc/pac

Jig Offset SAVAGE GEAR Weedlees EWG Hooks, Nr.8/0, 3buc/pac

svs61778

Livrare 7-14 zile

41,67Lei

NALUCA SAVAGE 3D HOLLOW DUCKLING 7.5CM/15G 02

NALUCA SAVAGE 3D HOLLOW DUCKLING 7.5CM/15G 02

svs57611

Livrare 7-14 zile

48,11Lei(-37%) 30,35Lei

Montura Savage Gear Carbon Ancore Nr. 6/6.5 Cm

Montura Savage Gear Carbon Ancore Nr. 6/6.5 Cm

svs54878

Livrare imediată!

26,39Lei

Agrafa Cu Vartej Cu Rulment SAVAGE GEAR Snaps Medium, Nr.2, 24kg, 6buc/pac

Agrafa Cu Vartej Cu Rulment SAVAGE GEAR Snaps Medium, Nr.2, 24kg, 6buc/pac

svs54925

Livrare 7-14 zile

33,54Lei

SALOPETA SAVAGE HEATLITE THERMO B AND B MARIMEA L

SALOPETA SAVAGE HEATLITE THERMO B AND B MARIMEA L

svs59130

Livrare 7-14 zile

387,39Lei

Geanta Savage Impermeabila Gear Rollup, 40 Litri, 55x23x16cm

Geanta Savage Impermeabila Gear Rollup, 40 Litri, 55x23x16cm

svs62411

Livrare imediată!

287,74Lei

Shad Savage Gear LB Cannibal, Perch, 12.5cm, 20g, 3buc/plic

Shad Savage Gear LB Cannibal, Perch, 12.5cm, 20g, 3buc/plic

svs61857-bucxxx3

Livrare imediată!

23,82Lei

SHAD SAVAGE LB CANNIBAL CURLTAIL 10CM/5G/PERCH 4BUC/PLIC

SHAD SAVAGE LB CANNIBAL CURLTAIL 10CM/5G/PERCH 4BUC/PLIC

f1.sg.63807

Livrare 24-48 ore

24,97Lei(-25%) 18,77Lei

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

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

svs71798

Livrare imediată!

28,51Lei(-46%) 15,49Lei

Lanseta Savage Gear SG2 Vertical Specialist 1.98m 12-35g 2seg

Lanseta Savage Gear SG2 Vertical Specialist 1.98m 12-35g 2seg

o.sg.72153

Livrare imediată!

361,74Lei(-55%) 162,84Lei

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

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

1608946

Livrare 7-14 zile

1.887,18Lei

NALUCA SAVAGE GEAR 3D CRAYFISH RATTLING 6.7CM 2.9G PURPLE HAZE GHOST

NALUCA SAVAGE GEAR 3D CRAYFISH RATTLING 6.7CM 2.9G PURPLE HAZE GHOST

f1.sg.72599

Livrare 24-48 ore

32,43Lei(-26%) 24,09Lei

Pilker SAVAGE GEAR Swimsquid Inchiku, White Glow, 10.3cm, 180g, 1buc/pac

Pilker SAVAGE GEAR Swimsquid Inchiku, White Glow, 10.3cm, 180g, 1buc/pac

svs77317

Livrare 7-14 zile

86,41Lei

CREATURA SAVAGE REACTION CRAYFISH 9.1CM/7.5G BLACK N BLUE 5BUC/PLIC

CREATURA SAVAGE REACTION CRAYFISH 9.1CM/7.5G BLACK N BLUE 5BUC/PLIC

svs74108

Livrare 7-14 zile

31,33Lei(-56%) 13,75Lei

CARLIG OFFSET SAVAGE GEAR WORM OFFSET SUPER SLIDE NR1/0 10BUC/PL

CARLIG OFFSET SAVAGE GEAR WORM OFFSET SUPER SLIDE NR1/0 10BUC/PL

svs74442

Livrare 7-14 zile

20,32Lei

PILKER SAVAGE GEAR JIG PSYCHO SPRAT 10.2CM 80G SINKING WHITE SILVER

PILKER SAVAGE GEAR JIG PSYCHO SPRAT 10.2CM 80G SINKING WHITE SILVER

f2.sg.74072

Livrare imediată!

43,34Lei

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

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

svs78217

Livrare 7-14 zile

47,77Lei

NALUCA SAVAGE GEAR SKIRT FLIRT JIG 6CM/4G SINKING BLACK RED

NALUCA SAVAGE GEAR SKIRT FLIRT JIG 6CM/4G SINKING BLACK RED

f1.sg.76836

Livrare 24-48 ore

28,44Lei(-56%) 12,57Lei

Afişare 2041 - 2060 din 2134 (107 pagini)

💬

WhatsApp Chat

👋 Salut! Cu ce vă pot ajuta?

Pot răspunde la întrebări despre:
✅ Comenzi și status livrare
✅ Informatii produse
✅ Recomandari produse(beta)
✅ Compatibilitate intre produse(beta)

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

1 (0.149)

SELECT data
FROM `oc_session`
WHERE session_id = '68bab02114a26eec4565df18a9'

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

2 (0.150)

SELECT `trigger`, `action`
FROM oc_event

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

3 (0.193)

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

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

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

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

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

7 (0.120)

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