Abu Garcia


Lingura Oscilanta ABU GARCIA Koster Spoon, Cooper, 28g, 1buc/pac

Lingura Oscilanta ABU GARCIA Koster Spoon, Cooper, 28g, 1buc/pac

1096557
Livrare 7-14 zile

285,71Lei

Lingurita Oscilanta Abu Garcia Atom Pro Roach 7.5cm 20g

Lingurita Oscilanta Abu Garcia Atom Pro Roach 7.5cm 20g

1571116
Livrare 7-14 zile

34,90Lei

Vobler Abu Garcia Svartzonker McSnack Mix 9cm, 22g, 3buc/pac

Vobler Abu Garcia Svartzonker McSnack Mix 9cm, 22g, 3buc/pac

1550154
Livrare 7-14 zile

155,55Lei

Lingurita Oscilanta ABU GARCIA Shaky, Ayu, 10g, 1buc/pac

Lingurita Oscilanta ABU GARCIA Shaky, Ayu, 10g, 1buc/pac

1572779
Livrare 7-14 zile

25,40Lei

LINGURITA OSCILANTA ABU GARCIA ATOM PRO, PERCH, 11CM, 55G

LINGURITA OSCILANTA ABU GARCIA ATOM PRO, PERCH, 11CM, 55G

1571153
Livrare 7-14 zile

86,41Lei

Lingura Rotativa Abu Garcia Droppen Maxi Spinners, Blue Glitter, 9g, 7.5cm

Lingura Rotativa Abu Garcia Droppen Maxi Spinners, Blue Glitter, 9g, 7.5cm

1581010
Livrare 7-14 zile

62,01Lei

Vobler Abu Garcia Hard Bait Beast Hi-Lo Sinking, Bronze Bomber, 33g, 14cm

Vobler Abu Garcia Hard Bait Beast Hi-Lo Sinking, Bronze Bomber, 33g, 14cm

1572576
Livrare 7-14 zile

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

Afişare 521 - 540 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: 92.488 ms [By time] [By id] [By file]
1 (0.130)
SELECT data
FROM `oc_session`
WHERE session_id = 'b0487a0da39e9fc967c39e6e48'
/var/www/clients/client1/web1/web/system/library/session/db.php:24
2 (0.181)
SELECT `trigger`, `action`
FROM oc_event
/var/www/clients/client1/web1/web/index.php:453
3 (0.087)
SELECT *
FROM oc_url_alias
WHERE keyword = 'Abu-Garcia'
/var/www/clients/client1/web1/web/catalog/controller/common/seo_url.php:48
4 (0.085)
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 (42.271)
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 (49.493)
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 520,20
/var/www/clients/client1/web1/web/catalog/model/catalog/product.php:440
7 (0.241)
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