Abu Garcia


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

100,00Lei

Cutit Abu Garcia Sheath Knife Filleting, 15cm

Cutit Abu Garcia Sheath Knife Filleting, 15cm

1196008
Livrare 7-14 zile

106,01Lei

Mulineta Abu Garcia Cardinal 53 FD 3000

Mulineta Abu Garcia Cardinal 53 FD 3000

1345013
Livrare imediată!

123,00Lei

Lanseta ABU GARCIA Tormentor 2 Travel Spinning Rod H, 30-70g, 2.74m, 4seg

Lanseta ABU GARCIA Tormentor 2 Travel Spinning Rod H, 30-70g, 2.74m, 4seg

1612491
Livrare imediată!

275,00Lei

Lanseta Abu Garcia Carabus Exquisite Spinning Rod XUL, 0.5-3g, 1.83m, 2seg

Lanseta Abu Garcia Carabus Exquisite Spinning Rod XUL, 0.5-3g, 1.83m, 2seg

1612458
Livrare 7-14 zile

211,00Lei

Lanseta Abu Garica Beast Pro Casting Rod XHP, 120-300g, 2.59m, 2seg

Lanseta Abu Garica Beast Pro Casting Rod XHP, 120-300g, 2.59m, 2seg

1612421
Livrare 7-14 zile

1.223,00Lei

Combo Abu Garcia Max X Spinning Combo 80M, 10-30g, 2.44m, 7seg

Combo Abu Garcia Max X Spinning Combo 80M, 10-30g, 2.44m, 7seg

1622869
Livrare 7-14 zile

317,00Lei

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

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

1621240
Livrare 7-14 zile

52,00Lei

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

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

1609466
Livrare 7-14 zile

36,00Lei

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

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

1376743
Livrare 7-14 zile

10,00Lei

Lingura Oscilanata ABU GARCIA Toby Spoon, Black Back Minnow, 7g, 5.7cm, 1buc/pac

Lingura Oscilanata ABU GARCIA Toby Spoon, Black Back Minnow, 7g, 5.7cm, 1buc/pac

1546284
Livrare 7-14 zile

16,01Lei

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

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

1550230
Livrare 7-14 zile

26,00Lei

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

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

1550207
Livrare 7-14 zile

22,00Lei

Lingura Oscilanata ABU GARCIA Toby Spoon LF, Holo Roach, 10g, 5.7cm, 1buc/pac

Lingura Oscilanata ABU GARCIA Toby Spoon LF, Holo Roach, 10g, 5.7cm, 1buc/pac

1550190
Livrare 7-14 zile

18,00Lei

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

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

1312864
Livrare 7-14 zile

32,00Lei

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

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

1312831
Livrare 7-14 zile

26,00Lei

VOBLER ABU GARCIA SVARTZONKER MCMIO FIRE CARP FLASH 18cm 54g

VOBLER ABU GARCIA SVARTZONKER MCMIO FIRE CARP FLASH 18cm 54g

1550131
Livrare imediată!

100,00Lei

Lanseta ABU GARCIA Svartzonker Downsizer The One, 2.50m, 30-110g, 2seg

Lanseta ABU GARCIA Svartzonker Downsizer The One, 2.50m, 30-110g, 2seg

1539796
Livrare 7-14 zile

759,01Lei

Lingurita Oscilanta ABU GARCIA Rattlin' Atom, Fegis, 9.5cm, 16.5g

Lingurita Oscilanta ABU GARCIA Rattlin' Atom, Fegis, 9.5cm, 16.5g

1571176
Livrare imediată!

36,00Lei

Lingurita Rotativa ABU GARCIA Droppen LF, Culoare Ayu, 4.6cm, 8g

Lingurita Rotativa ABU GARCIA Droppen LF, Culoare Ayu, 4.6cm, 8g

1549744
Livrare 7-14 zile

20,00Lei

Afişare 561 - 580 din 1277 (64 pagini)
Queries: 7, Total time: 115.222 ms [By time] [By id] [By file]
1 (0.090)
SELECT data
FROM `oc_session`
WHERE session_id = 'd1c0c799bd4d88897031c4cb53'
/var/www/clients/client1/web1/web/system/library/session/db.php:24
2 (0.111)
SELECT `trigger`, `action`
FROM oc_event
/var/www/clients/client1/web1/web/index.php:453
3 (0.122)
SELECT *
FROM oc_url_alias
WHERE keyword = 'Abu-Garcia'
/var/www/clients/client1/web1/web/catalog/controller/common/seo_url.php:48
4 (0.110)
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 = '0'
/var/www/clients/client1/web1/web/catalog/model/catalog/manufacturer.php:4
5 (53.166)
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 = '0' AND p.manufacturer_id = '122'
/var/www/clients/client1/web1/web/catalog/model/catalog/product.php:1699
6 (61.484)
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 = '0' AND p.manufacturer_id = '122' GROUP BY p.product_id
ORDER BY p.sort_order ASC LIMIT 560,20
/var/www/clients/client1/web1/web/catalog/model/catalog/product.php:440
7 (0.139)
SELECT *
FROM `oc_mxt_setting`
WHERE store_id = '0' AND name = 'lichidare_stoc'
/var/www/clients/client1/web1/web/catalog/model/catalog/category.php:37