Savage Gear

Savage Gear

Sortare după:

MINCIOG SAVAGE FINEZZE PLASA CAUCIUCATA 46X56X65CM

MINCIOG SAVAGE FINEZZE PLASA CAUCIUCATA 46X56X65CM

svs57575

Livrare imediată!

142,34Lei

Vobler Savage Gear Cicada 3D, Culoare 61989, 3.3cm, 3.5g

Vobler Savage Gear Cicada 3D, Culoare 61989, 3.3cm, 3.5g

svs61989

Livrare imediată!

37,61Lei

NALUCA SAVAGE GEAR 4D TROUT LINE 15CM/40G MS01

NALUCA SAVAGE GEAR 4D TROUT LINE 15CM/40G MS01

svs57385

Livrare imediată!

57,93Lei

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

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

f1.sg.63661

Livrare 24-48 ore

31,38Lei(-36%) 20,13Lei

Vobler Savage Gear 3D Roach Jerkster Sinking Culoare SS06 6.3cm 8g

Vobler Savage Gear 3D Roach Jerkster Sinking Culoare SS06 6.3cm 8g

sg.62220

Livrare 24-48 ore

39,13Lei(-36%) 24,87Lei

Shad Savage Gear Fat T-Tail Minnow Minnow 9cm 7G 4buc/plic

Shad Savage Gear Fat T-Tail Minnow Minnow 9cm 7G 4buc/plic

f1.sg.61813

Livrare 24-48 ore

20,17Lei(-24%) 15,35Lei

SHAD SAVAGE LB 4D HERRING 13CM 17G GREEN SILVER 4BUC/PLIC

SHAD SAVAGE LB 4D HERRING 13CM 17G GREEN SILVER 4BUC/PLIC

f1.sg.63667

Livrare 24-48 ore

42,57Lei(-16%) 35,62Lei

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

41,67Lei

Shad Savage Gear Craft Cannibal Paddletail 12.5cm 20g 3buc/plic Roach

Shad Savage Gear Craft Cannibal Paddletail 12.5cm 20g 3buc/plic Roach

f1.sg.71819

Livrare imediată!

31,23Lei(-39%) 19,05Lei

Hanorac SAVAGE GEAR Tec Foam Zip, Dark Grey Melange, Marimea L

Hanorac SAVAGE GEAR Tec Foam Zip, Dark Grey Melange, Marimea L

svs76587

Livrare 7-14 zile

314,18Lei

Cizme Piept SAVAGE GEAR Sg8 Chest Sf XLS, Marime 45-47

Cizme Piept SAVAGE GEAR Sg8 Chest Sf XLS, Marime 45-47

1608954

Livrare 7-14 zile

1.756,01Lei

CICADA STRIKE PRO ASTRO BLADE 5.5CM 17.7G SE01E

CICADA STRIKE PRO ASTRO BLADE 5.5CM 17.7G SE01E

sp.pjg005bc.se01e

Livrare 24-48 ore

36,44Lei

Tambur Rezerva SAVAGE GEAR SGS6 FD Spare Spool, 10000FD

Tambur Rezerva SAVAGE GEAR SGS6 FD Spare Spool, 10000FD

svs73119

Livrare 7-14 zile

144,95Lei(-44%) 81,23Lei

Hanorac SAVAGE GEAR Tec Foam, Dark Grey Melange, Marimea S

Hanorac SAVAGE GEAR Tec Foam, Dark Grey Melange, Marimea S

svs76693

Livrare 7-14 zile

291,82Lei

LANSETA SAVAGE GEAR SG2 LIGHT GAME 2.51M 3-14G 2SEG

LANSETA SAVAGE GEAR SG2 LIGHT GAME 2.51M 3-14G 2SEG

o.sg.72150

Livrare 24-48 ore

311,64Lei

Shad Savage Gear Cannibal Shad 6.8cm 3g Chartreus

Shad Savage Gear Cannibal Shad 6.8cm 3g Chartreus

f1.sg.74528

Livrare 24-48 ore

19,30Lei

CUTIE SAVAGE NR.5B PT.NALUCI 35,5X23X5CM

CUTIE SAVAGE NR.5B PT.NALUCI 35,5X23X5CM

svs74225

Livrare imediată!

68,11Lei

SHAD SAVAGE GEAR 3D RIVER ROACH 10CM 10G FIRETIGER 4BUC/PLIC

SHAD SAVAGE GEAR 3D RIVER ROACH 10CM 10G FIRETIGER 4BUC/PLIC

f1.sg.74288

Livrare 24-48 ore

37,44Lei

Pilker SAVAGE GEAR Seeker ISP Sinking, Green Siver, 9.8cm, 23cm, 1buc/pac

Pilker SAVAGE GEAR Seeker ISP Sinking, Green Siver, 9.8cm, 23cm, 1buc/pac

svs55348

Livrare 7-14 zile

29,48Lei

SPINNER SAVAGE GEAR 3D STICKLEBAIT TAILSPIN 7.3CM 13G SINKING GREEN SILVER AYU

SPINNER SAVAGE GEAR 3D STICKLEBAIT TAILSPIN 7.3CM 13G SINKING GREEN SILVER AYU

sg.76813

Livrare 24-48 ore

39,37Lei(-36%) 25,01Lei

Afişare 2021 - 2040 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: 120.402 ms [By time] [By id] [By file]

1 (0.089)

SELECT data
FROM `oc_session`
WHERE session_id = '34a25ac27a43f0d7725e867089'

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

2 (0.075)

SELECT `trigger`, `action`
FROM oc_event

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

3 (0.090)

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

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

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

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

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

7 (0.173)

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