Abu Garcia


Combo Abu Garcia Max X Black Ops Spinning 802M, 10-30g, 2.44m, 2seg

Combo Abu Garcia Max X Black Ops Spinning 802M, 10-30g, 2.44m, 2seg

1551688
Livrare 7-14 zile

463,65Lei

Mulineta Abu Garcia Abumatic Abu506 MkII

Mulineta Abu Garcia Abumatic Abu506 MkII

1262685
Livrare 7-14 zile

472,80Lei

Pluta Abu Garcia Bombarda Sink Float Stop, Black, 20g

Pluta Abu Garcia Bombarda Sink Float Stop, Black, 20g

1110090
Stoc epuizat

10,66Lei

Vobler Abu Garcia Svartzonker Mcmio, Yellowfin Perch, 54g, 18cm, 1buc/pac

Vobler Abu Garcia Svartzonker Mcmio, Yellowfin Perch, 54g, 18cm, 1buc/pac

1550130
Livrare 7-14 zile

102,68Lei

Sapca Abu Garcia Solv Trucker Cap Navy Blue With Beige

Sapca Abu Garcia Solv Trucker Cap Navy Blue With Beige

1551636
Livrare 7-14 zile

87,43Lei

Mulineta Abu Garcia Stx SP20 Spinning Reel, 2000

Mulineta Abu Garcia Stx SP20 Spinning Reel, 2000

p.1532490
Livrare 24-48 ore

268,60Lei

Combo Abu Garcia Tormentor2 Spinning ML 3000, 15-45g, 2.74m, 3seg

Combo Abu Garcia Tormentor2 Spinning ML 3000, 15-45g, 2.74m, 3seg

1612925
Livrare 7-14 zile

523,64Lei

Lanseta Abu Garica Beast X Trolling Casting Rod XTR, 150-400g, 2.59m, 2seg

Lanseta Abu Garica Beast X Trolling Casting Rod XTR, 150-400g, 2.59m, 2seg

1612435
Livrare 7-14 zile

601,93Lei

Lanseta Abu Garica Beast X Casting Rod H, 40-120g, 2.23m, 1+1seg

Lanseta Abu Garica Beast X Casting Rod H, 40-120g, 2.23m, 1+1seg

1612426
Livrare 7-14 zile

472,80Lei

Combo Abu Garcia Max X Spinning Combo 902XH, 30-80g, 2.74m, 2seg

Combo Abu Garcia Max X Spinning Combo 902XH, 30-80g, 2.74m, 2seg

1622867
Livrare 7-14 zile

362,98Lei

Shad ABU GARCIA Beast Paddletail, Albino Trout, 21cm, 94g, 4buc/pac

Shad ABU GARCIA Beast Paddletail, Albino Trout, 21cm, 94g, 4buc/pac

1621271
Livrare 7-14 zile

163,69Lei

Vobler ABU GARCIA Beast Hi-Lo Jointed Floating, Tiger, 9cm, 22.4g

Vobler ABU GARCIA Beast Hi-Lo Jointed Floating, Tiger, 9cm, 22.4g

1621234
Livrare imediată!

53,87Lei

Lingurita Oscilanta ABU GARCIA Toby Jointed, Orange Copper Holo, 10g, 1buc/pac

Lingurita Oscilanta ABU GARCIA Toby Jointed, Orange Copper Holo, 10g, 1buc/pac

1609454
Livrare 7-14 zile

33,54Lei

Mulineta ABU GARCIA Max SX Spinning Reel 750

Mulineta ABU GARCIA Max SX Spinning Reel 750

1609809
Livrare imediată!

215,55Lei

Lingura Oscilanata ABU GARCIA Toby Spoon LF, Green Back Minnow, 40g, 9cm, 1buc/pac

Lingura Oscilanata ABU GARCIA Toby Spoon LF, Green Back Minnow, 40g, 9cm, 1buc/pac

1546321
Livrare 7-14 zile

31,50Lei

Lingura Oscilanata ABU GARCIA Toby Spoon LF, Trout, 18g, 9cm, 1buc/pac

Lingura Oscilanata ABU GARCIA Toby Spoon LF, Trout, 18g, 9cm, 1buc/pac

1550206
Livrare 7-14 zile

23,37Lei

Lingurita Oscilanta ABU GARCIA Toby Salmo Spoon, Gold Green Glitter, 11cm, 30g, 1buc/pac

Lingurita Oscilanta ABU GARCIA Toby Salmo Spoon, Gold Green Glitter, 11cm, 30g, 1buc/pac

1248393
Livrare 7-14 zile

33,54Lei

Lingurita Oscilanta ABU GARCIA Atom Pro, Rainbow Trout, 7.5cm, 25g, 1buc/pac

Lingurita Oscilanta ABU GARCIA Atom Pro, Rainbow Trout, 7.5cm, 25g, 1buc/pac

1579946
Livrare 7-14 zile

45,74Lei

Lingurita Roativa ABU GARCIA Fast Attack Stickle Spinner, Salt N Pepper, 5g, 4.5cm, 1buc/pac

Lingurita Roativa ABU GARCIA Fast Attack Stickle Spinner, Salt N Pepper, 5g, 4.5cm, 1buc/pac

1595281
Livrare 7-14 zile

33,54Lei

Lingurita Oscilanta ABU GARCIA Jazz Spoon, Silver Red Dot, 10g, 4.5cm, 1buc/pac

Lingurita Oscilanta ABU GARCIA Jazz Spoon, Silver Red Dot, 10g, 4.5cm, 1buc/pac

1204187
Livrare 7-14 zile

23,37Lei

Afişare 701 - 720 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: 99.002 ms [By time] [By id] [By file]
1 (0.117)
SELECT data
FROM `oc_session`
WHERE session_id = 'a34e1908b4589750ac1a3b0026'
/var/www/clients/client1/web1/web/system/library/session/db.php:24
2 (0.113)
SELECT `trigger`, `action`
FROM oc_event
/var/www/clients/client1/web1/web/index.php:453
3 (0.149)
SELECT *
FROM oc_url_alias
WHERE keyword = 'Abu-Garcia'
/var/www/clients/client1/web1/web/catalog/controller/common/seo_url.php:48
4 (0.140)
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 (44.430)
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 (53.889)
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 700,20
/var/www/clients/client1/web1/web/catalog/model/catalog/product.php:440
7 (0.164)
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