Savage Gear

Savage Gear

Sortare după:

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

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

svs78214

Livrare 7-14 zile

50,00Lei

NALUCA SAVAGE GEAR SKIRT FLIRT JIG 6.5CM/10G SINKING GREEN PUMPKIN

NALUCA SAVAGE GEAR SKIRT FLIRT JIG 6.5CM/10G SINKING GREEN PUMPKIN

f1.sg.76850

Livrare imediată!

30,84Lei(-60%) 12,34Lei

Shad SAVAGE GEAR Soft Lure Monster Slug, Pearl Apple, 50g, 25cm, 2buc/pac

Shad SAVAGE GEAR Soft Lure Monster Slug, Pearl Apple, 50g, 25cm, 2buc/pac

svs69792

Livrare 7-14 zile

46,01Lei

Lanseta Spinning Savage Gear Revange SG6 Medium Game 2.43m, 12-35g, 2seg

Lanseta Spinning Savage Gear Revange SG6 Medium Game 2.43m, 12-35g, 2seg

o.sg.1601806

Livrare 24-48 ore

888,35Lei

Teaser Savage Gear Trace Marime S, 1.00mm, 36kg, 60cm, 2buc/pac

Teaser Savage Gear Trace Marime S, 1.00mm, 36kg, 60cm, 2buc/pac

sg.1611092

Livrare 24-48 ore

31,34Lei

Swimbait SAVAGE GEAR 3D Roach RTF Lure, Green Silver, 15cm, 60g

Swimbait SAVAGE GEAR 3D Roach RTF Lure, Green Silver, 15cm, 60g

1625365

Livrare 7-14 zile

48,00Lei

CARLIGE OFFSET LESTATE NR.04 5BUC/PL. SAVAGE GEAR

CARLIGE OFFSET LESTATE NR.04 5BUC/PL. SAVAGE GEAR

f2.sg.42201

Livrare 24-48 ore

29,04Lei(-60%) 11,61Lei

FIR SAVAGE SOFT FLUOROCARBON 074MM/28.7KG/20M

FIR SAVAGE SOFT FLUOROCARBON 074MM/28.7KG/20M

svs54856

Livrare 7-14 zile

102,99Lei

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

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

1610621

Livrare 7-14 zile

43,99Lei

Fir Savage Gear Regenerator 050MM/14.5KG/30M

Fir Savage Gear Regenerator 050MM/14.5KG/30M

svs54839

Livrare 7-14 zile

24,00Lei

MINCIOG SAVAGE FINEZZE PLASA CAUCIUCATA 46X56X65CM

MINCIOG SAVAGE FINEZZE PLASA CAUCIUCATA 46X56X65CM

svs57575

Livrare imediată!

139,00Lei

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

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

svs61987

Livrare imediată!

36,00Lei

Vobler Savage Gear 3D Smash Tail, Firetiger, 10cm, 17g

Vobler Savage Gear 3D Smash Tail, Firetiger, 10cm, 17g

svs61996

Livrare imediată!

48,00Lei

SHAD SAVAGE LB 4D HERRING 9CM/5G PERCH 4BUC/PLIC

SHAD SAVAGE LB 4D HERRING 9CM/5G PERCH 4BUC/PLIC

f1.sg.63652

Livrare 24-48 ore

33,95Lei(-20%) 27,16Lei

SHAD SAVAGE LB CANNIBAL 12.5CM/PERCH 3BUC/PLIC

SHAD SAVAGE LB CANNIBAL 12.5CM/PERCH 3BUC/PLIC

f1.sg.69972

Livrare imediată!

14,59Lei

Shad Savage Gear Craft Cannibal Paddletail 8.5cm 7g 4buc/plic Olive Hot Orange

Shad Savage Gear Craft Cannibal Paddletail 8.5cm 7g 4buc/plic Olive Hot Orange

f1.sg.71808

Livrare imediată!

25,42Lei(-40%) 15,26Lei

BLUZA SAVAGE GEAR AQUA UV LONG SLEEVE TEE BONNIE BLUE MARIME S

BLUZA SAVAGE GEAR AQUA UV LONG SLEEVE TEE BONNIE BLUE MARIME S

a8.sg.73659

Livrare 24-48 ore

196,86Lei(-40%) 118,11Lei

Ochelari polarizati Savage Gear Savage 1 Yellow

Ochelari polarizati Savage Gear Savage 1 Yellow

a8.sg.72245

Livrare 24-48 ore

133,15Lei

Shad Savage Gear Minnow WL KHAKI 12.5cm 28g 3buc

Shad Savage Gear Minnow WL KHAKI 12.5cm 28g 3buc

f1.sg.72445

Livrare 24-48 ore

54,67Lei(-20%) 43,74Lei

Cizme Piept SAVAGE GEAR Sg8 Chest Sf LS, Marime 42-44

Cizme Piept SAVAGE GEAR Sg8 Chest Sf LS, Marime 42-44

1608951

Livrare 7-14 zile

1.726,00Lei

Afişare 1341 - 1360 din 2027 (102 pagini)

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

1 (0.133)

SELECT data
FROM `oc_session`
WHERE session_id = '9ca8e81758d9ed58b2ba2008eb'

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

2 (0.080)

SELECT `trigger`, `action`
FROM oc_event

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

3 (0.101)

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

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

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

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

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

7 (0.124)

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