Abu Garcia


Vobler Abu Garcia Svartzonker McTracer 12.5cm 69g Golden Minnow -26%

Vobler Abu Garcia Svartzonker McTracer 12.5cm 69g Golden Minnow

1572602
Livrare imediată!

79,90Lei(-26%) 58,91Lei

Lanseta Abu Garcia Devil Casting 802M, 2.43m, 10-30g, 2buc

Lanseta Abu Garcia Devil Casting 802M, 2.43m, 10-30g, 2buc

1216283
Livrare 7-14 zile

249,00Lei

Husa mulinete Carryall Abu Garcia Beast BEAST PRO REEL POUCH -38%

Husa mulinete Carryall Abu Garcia Beast BEAST PRO REEL POUCH

1528434
Livrare 7-14 zile

71,28Lei(-38%) 43,90Lei

Lingura Oscilanata Abu Garcia Hard Bait Toby Spoon , Red Hot Tiger, 60g, 11.5cm

Lingura Oscilanata Abu Garcia Hard Bait Toby Spoon , Red Hot Tiger, 60g, 11.5cm

1550258
Livrare 7-14 zile

48,00Lei

Lanseta Abu Garcia Diplomat V2 Travel 904M, 2.74m, 12-32g, 4seg

Lanseta Abu Garcia Diplomat V2 Travel 904M, 2.74m, 12-32g, 4seg

1561333
Livrare 7-14 zile

380,00Lei

Vobler Abu Garcia Hard Bait Beast Hi-Lo Floating, Cooper Perch, 22.4g, 9cm

Vobler Abu Garcia Hard Bait Beast Hi-Lo Floating, Cooper Perch, 22.4g, 9cm

1572585
Livrare imediată!

52,00Lei

Mulineta Abu Garcia Spike Pro Spinning Reel, 2500SH

Mulineta Abu Garcia Spike Pro Spinning Reel, 2500SH

1564206
Livrare 7-14 zile

886,00Lei

Lanseta Abu Garcia Veritas SENSI-S Spinning Rod UL, 1-7g, 2.44m, 2seg

Lanseta Abu Garcia Veritas SENSI-S Spinning Rod UL, 1-7g, 2.44m, 2seg

1558831
Livrare imediată!

591,00Lei

Combo Abu Garcia Cardinal X Spinning 602ML, 5-25g, 1.83m, 2seg

Combo Abu Garcia Cardinal X Spinning 602ML, 5-25g, 1.83m, 2seg

1548302
Livrare 7-14 zile

257,00Lei

Combo Abu Garcia Cardinal Classic Combo Seafishing Tow Tip H, 20-80g, 2.70m, 3+1seg

Combo Abu Garcia Cardinal Classic Combo Seafishing Tow Tip H, 20-80g, 2.70m, 3+1seg

1345001
Livrare imediată!

435,00Lei

Vobler Abu Garcia Svartzonker Mc My Tail, Real Hot Pike, 50g, 17cm

Vobler Abu Garcia Svartzonker Mc My Tail, Real Hot Pike, 50g, 17cm

1550136
Livrare 7-14 zile

103,99Lei

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

85,00Lei

Mulineta ABU GARCIA SX Pro Spinning Reel MAXSXSP3000

Mulineta ABU GARCIA SX Pro Spinning Reel MAXSXSP3000

1609815
Livrare imediată!

232,00Lei

Lanseta ABU GARCIA Tormentor 2 Spinning Rod MH, 10-45g, 2.74m, 2seg

Lanseta ABU GARCIA Tormentor 2 Spinning Rod MH, 10-45g, 2.74m, 2seg

1612482
Livrare 7-14 zile

211,00Lei

Lanseta Abu Garica Beast Pro Live Casting Rod XXH, 50-150g, 2.24m, 1+1seg

Lanseta Abu Garica Beast Pro Live Casting Rod XXH, 50-150g, 2.24m, 1+1seg

1612417
Livrare 7-14 zile

1.012,00Lei

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

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

1622863
Livrare 7-14 zile

317,00Lei

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

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

1621267
Livrare 7-14 zile

160,00Lei

Vobler ABU GARCIA Beast Hi-Lo Jointed Floating, Bronze Bomber, 12cm, 47g

Vobler ABU GARCIA Beast Hi-Lo Jointed Floating, Bronze Bomber, 12cm, 47g

1621244
Livrare 7-14 zile

60,00Lei

Lingurita Oscilanta ABU GARCIA Toby Jointed, Red Hot Tiger, 18g

Lingurita Oscilanta ABU GARCIA Toby Jointed, Red Hot Tiger, 18g

1609468
Livrare 7-14 zile

40,00Lei

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

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

1550242
Livrare 7-14 zile

30,00Lei

Afişare 121 - 140 din 1069 (54 pagini)
Queries: 7, Total time: 84.281 ms [By time] [By id] [By file]
1 (0.133)
SELECT data
FROM `oc_session`
WHERE session_id = '9524af677881f07df493f2d754'
/var/www/clients/client1/web1/web/system/library/session/db.php:24
2 (0.127)
SELECT `trigger`, `action`
FROM oc_event
/var/www/clients/client1/web1/web/index.php:453
3 (0.158)
SELECT *
FROM oc_url_alias
WHERE keyword = 'Abu-Garcia'
/var/www/clients/client1/web1/web/catalog/controller/common/seo_url.php:48
4 (0.137)
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 = '2'
/var/www/clients/client1/web1/web/catalog/model/catalog/manufacturer.php:4
5 (39.679)
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 = '2' AND p.manufacturer_id = '122'
/var/www/clients/client1/web1/web/catalog/model/catalog/product.php:1699
6 (43.883)
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 = '2' AND p.manufacturer_id = '122' GROUP BY p.product_id
ORDER BY p.sort_order ASC LIMIT 120,20
/var/www/clients/client1/web1/web/catalog/model/catalog/product.php:440
7 (0.164)
SELECT *
FROM `oc_mxt_setting`
WHERE store_id = '2' AND name = 'lichidare_stoc'
/var/www/clients/client1/web1/web/catalog/model/catalog/category.php:37