Abu Garcia


Lingurita Rattling Abu Garcia Atom, Golden Roach, 12cm, 45g

Lingurita Rattling Abu Garcia Atom, Golden Roach, 12cm, 45g

1525554
Livrare imediată!

41,67Lei

Vobler Abu Garcia Hard Bait Beast Hi-Lo Floating, Fegis, 47g, 12cm

Vobler Abu Garcia Hard Bait Beast Hi-Lo Floating, Fegis, 47g, 12cm

1572591
Livrare imediată!

62,01Lei

Montura Abu Garcia Svartzonker Stinger XL, 2buc/plic

Montura Abu Garcia Svartzonker Stinger XL, 2buc/plic

1517202
Livrare 7-14 zile

57,93Lei

Mulineta + Fir Abu Garcia Max X Spinning Reel 4000 -22%

Mulineta + Fir Abu Garcia Max X Spinning Reel 4000

1530856
Livrare imediată!

318,71Lei(-22%) 250,02Lei

Lanseta Abu Garcia ORRA Predator Spinning Rod 702 L, 3-14g, 2.13m, 2seg

Lanseta Abu Garcia ORRA Predator Spinning Rod 702 L, 3-14g, 2.13m, 2seg

1580842
Livrare 7-14 zile

301,97Lei

Lanseta Abu Garcia Diplomat V2 Travel 704ML, 2.13m, 5-21g, 5seg

Lanseta Abu Garcia Diplomat V2 Travel 704ML, 2.13m, 5-21g, 5seg

1561327
Livrare 7-14 zile

301,97Lei

Combo Abu Garcia Revolution Impact Yellow M, 10-30g, 2.10m, 2seg

Combo Abu Garcia Revolution Impact Yellow M, 10-30g, 2.10m, 2seg

1532622
Livrare 7-14 zile

443,31Lei

Mulineta Abu Garcia Ambassadeur C-7000 Round Reel Right Hand

Mulineta Abu Garcia Ambassadeur C-7000 Round Reel Right Hand

1324532
Livrare 7-14 zile

859,18Lei

Pluta Abu Garcia Bombarda Intermed Float Stop, Clear, 40g

Pluta Abu Garcia Bombarda Intermed Float Stop, Clear, 40g

1110081
Livrare imediată!

33,99Lei

Vobler Abu Garcia Svartzonker Mcmio, Crucian Carp, 54g, 18cm, 1buc/pac

Vobler Abu Garcia Svartzonker Mcmio, Crucian Carp, 54g, 18cm, 1buc/pac

1550127
Livrare 7-14 zile

102,68Lei

Cutit Abu Garcia Sheath Knife Filleting, 15cm

Cutit Abu Garcia Sheath Knife Filleting, 15cm

1196008
Livrare 7-14 zile

108,78Lei

Mulineta Abu Garcia Max Pro Spinning Reel 2000H

Mulineta Abu Garcia Max Pro Spinning Reel 2000H

1609821
Livrare 7-14 zile

301,97Lei

Lanseta ABU GARCIA Tormentor 2 Spinning Rod M, 15-35g, 1.83m, 2seg

Lanseta ABU GARCIA Tormentor 2 Spinning Rod M, 15-35g, 1.83m, 2seg

1612475
Livrare imediată!

164,71Lei

Lanseta Abu Garica Fantasista Nano Spinning Rod M, 5-30g, 2.13m, 2seg

Lanseta Abu Garica Fantasista Nano Spinning Rod M, 5-30g, 2.13m, 2seg

1612463
Livrare 7-14 zile

1.017,82Lei

Combo Abu Garcia Max SX Spinning M, 7-28g, 2.44m, 2seg

Combo Abu Garcia Max SX Spinning M, 7-28g, 2.44m, 2seg

1622852
Livrare 7-14 zile

403,66Lei

Mulineta ABU GARCIA Max X Spinning 6000

Mulineta ABU GARCIA Max X Spinning 6000

1609807
Livrare 7-14 zile

194,19Lei

Shad ABU GARCIA Beast Slim Paddletail, Firetiger, 21cm, 94g, 4buc/pac

Shad ABU GARCIA Beast Slim Paddletail, Firetiger, 21cm, 94g, 4buc/pac

1621275
Livrare 7-14 zile

163,69Lei

Vobler ABU GARCIA Beast Hi-Lo Jointed Sinking, Bronze Bomber, 9cm, 12g

Vobler ABU GARCIA Beast Hi-Lo Jointed Sinking, Bronze Bomber, 9cm, 12g

1621220
Livrare 7-14 zile

53,87Lei

Lingurita Oscilanta ABU GARCIA Toby Jointed, Black Back Minnow, 18g, 1buc/pac

Lingurita Oscilanta ABU GARCIA Toby Jointed, Black Back Minnow, 18g, 1buc/pac

1609474
Livrare 7-14 zile

41,67Lei

Agrafa ABU GARCIA Snap Swivels Gold, Nr.14, 10buc/pac

Agrafa ABU GARCIA Snap Swivels Gold, Nr.14, 10buc/pac

1424543
Livrare 7-14 zile

13,20Lei

Afişare 541 - 560 din 1426 (72 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: 127.346 ms [By time] [By id] [By file]
1 (0.123)
SELECT data
FROM `oc_session`
WHERE session_id = 'bdcca213cce3821a26c3189617'
/var/www/clients/client1/web1/web/system/library/session/db.php:24
2 (0.084)
SELECT `trigger`, `action`
FROM oc_event
/var/www/clients/client1/web1/web/index.php:453
3 (0.114)
SELECT *
FROM oc_url_alias
WHERE keyword = 'Abu-Garcia'
/var/www/clients/client1/web1/web/catalog/controller/common/seo_url.php:48
4 (0.115)
SELECT *
FROM oc_manufacturer m
LEFT JOIN oc_manufacturer_to_store m2s ON (m.manufacturer_id = m2s.manufacturer_id)
WHERE m.manufacturer_id = '122' AND m2s.store_id = '3'
/var/www/clients/client1/web1/web/catalog/model/catalog/manufacturer.php:4
5 (67.997)
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 = '3' AND p.manufacturer_id = '122'
/var/www/clients/client1/web1/web/catalog/model/catalog/product.php:1699
6 (58.781)
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 = '3' AND p.manufacturer_id = '122' GROUP BY p.product_id
ORDER BY p.sort_order ASC LIMIT 540,20
/var/www/clients/client1/web1/web/catalog/model/catalog/product.php:440
7 (0.132)
SELECT *
FROM `oc_mxt_setting`
WHERE store_id = '3' AND name = 'lichidare_stoc'
/var/www/clients/client1/web1/web/catalog/model/catalog/category.php:37