Abu Garcia


Vobler Abu Garcia Svartzonker McHybrid, Fegis, 100g, 20cm

Vobler Abu Garcia Svartzonker McHybrid, Fegis, 100g, 20cm

1531911
Livrare 7-14 zile

114,88Lei

Vobler Abu Garcia Svartzonker Mcmio, Yellowfin Perch, 21g, 14cm, 1buc/pac

Vobler Abu Garcia Svartzonker Mcmio, Yellowfin Perch, 21g, 14cm, 1buc/pac

1550122
Livrare 7-14 zile

94,55Lei

Husa Abu Garcia Rod Sleeve Multi, 104x25x3cm

Husa Abu Garcia Rod Sleeve Multi, 104x25x3cm

1530850
Livrare imediată!

116,92Lei

Mulineta Abu Garcia Max Pro Spinning Reel 4000H

Mulineta Abu Garcia Max Pro Spinning Reel 4000H

1609827
Livrare imediată!

344,68Lei

Lanseta ABU GARCIA Tormentor 2 Spinning Rod ML, 5-21g, 2.44m, 2seg

Lanseta ABU GARCIA Tormentor 2 Spinning Rod ML, 5-21g, 2.44m, 2seg

1612479
Livrare 7-14 zile

164,71Lei

Lanseta Abu Garica Fantasista Nano Spinning Rod M, 7-35g, 2.36m, 2seg

Lanseta Abu Garica Fantasista Nano Spinning Rod M, 7-35g, 2.36m, 2seg

1612466
Livrare 7-14 zile

1.121,52Lei

Combo Abu Garcia Max SX Spinning 902MH, 15-40g, 2.74m, 2seg

Combo Abu Garcia Max SX Spinning 902MH, 15-40g, 2.74m, 2seg

1622855
Livrare 7-14 zile

443,31Lei

Lanseta ABU GARCIA Diplomat DMPS-612UL E, 1.89m, 0.5-4.5g, 2seg

Lanseta ABU GARCIA Diplomat DMPS-612UL E, 1.89m, 0.5-4.5g, 2seg

1623089
Livrare 7-14 zile

1.287,26Lei

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

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

1621273
Livrare 7-14 zile

163,69Lei

Vobler ABU GARCIA Beast Hi-Lo Jointed Sinking, Gold Black Or, 9cm, 12g

Vobler ABU GARCIA Beast Hi-Lo Jointed Sinking, Gold Black Or, 9cm, 12g

1621223
Livrare 7-14 zile

53,87Lei

Lingurita Oscilanta ABU GARCIA Toby Jointed, Fire Starter, 18g

Lingurita Oscilanta ABU GARCIA Toby Jointed, Fire Starter, 18g

1609471
Livrare 7-14 zile

41,67Lei

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

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

1376744
Livrare 7-14 zile

13,20Lei

Lingura Oscilanata ABU GARCIA Toby Spoon LF, Blue Flash, 20g, 7.5cm, 1buc/pac

Lingura Oscilanata ABU GARCIA Toby Spoon LF, Blue Flash, 20g, 7.5cm, 1buc/pac

1550217
Livrare 7-14 zile

25,40Lei

Lingura Oscilanata ABU GARCIA Toby Spoon LF, Orange Cooper Holo, 15g, 7.5cm, 1buc/pac

Lingura Oscilanata ABU GARCIA Toby Spoon LF, Orange Cooper Holo, 15g, 7.5cm, 1buc/pac

1550201
Livrare 7-14 zile

21,34Lei

Husa ABU GARCIA Individuala Neoprene Rod Bag, 1 Lanseta + 1 Mulineta, 130cm

Husa ABU GARCIA Individuala Neoprene Rod Bag, 1 Lanseta + 1 Mulineta, 130cm

1622945
Livrare 7-14 zile

60,98Lei

Lingurita Oscilanta ABU GARCIA Atom, Culoare YP, 7.5cm, 25g, 1buc/pac

Lingurita Oscilanta ABU GARCIA Atom, Culoare YP, 7.5cm, 25g, 1buc/pac

1312828
Livrare 7-14 zile

27,44Lei

Lanseta ABU GARCIA Spike X Finesse Jigging 862, 2.59m, 5-30g, 2seg

Lanseta ABU GARCIA Spike X Finesse Jigging 862, 2.59m, 5-30g, 2seg

1539787
Livrare 7-14 zile

859,18Lei

Lingurita Rotativa ABU GARCIA Droppen LF, Culoare Orange, 5.3cm, 12g

Lingurita Rotativa ABU GARCIA Droppen LF, Culoare Orange, 5.3cm, 12g

1549751
Livrare 7-14 zile

25,40Lei

Lingurita Rotativa ABU GARCIA Fast Attack Spinner LF, Silver/Red Dots, 10g, 5cm

Lingurita Rotativa ABU GARCIA Fast Attack Spinner LF, Silver/Red Dots, 10g, 5cm

1549876
Livrare 7-14 zile

25,40Lei

VOBLER ABU GARCIA SVARTZONKER MCMIO FIRE CARP FLASH 14cm 21g -24%

VOBLER ABU GARCIA SVARTZONKER MCMIO FIRE CARP FLASH 14cm 21g

1550123
Livrare imediată!

91,96Lei(-24%) 70,03Lei

Afişare 901 - 920 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.195 ms [By time] [By id] [By file]
1 (0.087)
SELECT data
FROM `oc_session`
WHERE session_id = '7b89b1b35f15daf43f5941e3a0'
/var/www/clients/client1/web1/web/system/library/session/db.php:24
2 (0.068)
SELECT `trigger`, `action`
FROM oc_event
/var/www/clients/client1/web1/web/index.php:453
3 (0.093)
SELECT *
FROM oc_url_alias
WHERE keyword = 'Abu-Garcia'
/var/www/clients/client1/web1/web/catalog/controller/common/seo_url.php:48
4 (0.211)
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 (36.478)
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 (62.155)
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 900,20
/var/www/clients/client1/web1/web/catalog/model/catalog/product.php:440
7 (0.103)
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