Abu Garcia


Lanseta Abu Garcia Beast Pro Pelagic Casting Rod 6511H, 50-120g, 1.95m, 1+1seg

Lanseta Abu Garcia Beast Pro Pelagic Casting Rod 6511H, 50-120g, 1.95m, 1+1seg

1577392
Livrare 7-14 zile

989,96Lei

Vobler Abu Garcia Svartzonker McHybrid, Ghost Walleye, 74g, 16.5cm

Vobler Abu Garcia Svartzonker McHybrid, Ghost Walleye, 74g, 16.5cm

1579553
Livrare 7-14 zile

96,00Lei

Vobler Abu Garcia Svartzonker McHybrid, Fire Bass, 100g, 20cm

Vobler Abu Garcia Svartzonker McHybrid, Fire Bass, 100g, 20cm

1550112
Livrare 7-14 zile

112,00Lei

Husa Abu Garcia Rod Sleeve Multi, 104x25x3cm

Husa Abu Garcia Rod Sleeve Multi, 104x25x3cm

1530850
Livrare imediată!

114,00Lei

Mulineta ABU GARCIA Zenon MG-X Spinning Reel SP2500MS, 6.2:1, 0.20mm/180m, 10+1rul

Mulineta ABU GARCIA Zenon MG-X Spinning Reel SP2500MS, 6.2:1, 0.20mm/180m, 10+1rul

1591766
Livrare imediată!

1.559,99Lei

Lanseta ABU GARCIA Tormentor 2 Spinning Rod M, 10-30g, 1.83m, 2seg

Lanseta ABU GARCIA Tormentor 2 Spinning Rod M, 10-30g, 1.83m, 2seg

1612473
Livrare imediată!

140,00Lei

Lanseta Abu Garica Fantasista Nano Spinning Rod ML, 3-21g, 2.13m, 2seg

Lanseta Abu Garica Fantasista Nano Spinning Rod ML, 3-21g, 2.13m, 2seg

1612462
Livrare 7-14 zile

980,00Lei

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

396,00Lei

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.265,01Lei

Grub ABU GARCIA Beast Twintail, Albino Trout, 21cm, 74g, 4buc/pac

Grub ABU GARCIA Beast Twintail, Albino Trout, 21cm, 74g, 4buc/pac

1621287
Livrare 7-14 zile

160,00Lei

Vobler ABU GARCIA Beast Hi-Lo Jointed Sinking, Blue Herring, 12cm, 33g

Vobler ABU GARCIA Beast Hi-Lo Jointed Sinking, Blue Herring, 12cm, 33g

1621232
Livrare 7-14 zile

60,00Lei

Lingurita Oscilanta ABU GARCIA Atom Pro, Brown Trout, 7.5cm, 20g, 1buc/pac

Lingurita Oscilanta ABU GARCIA Atom Pro, Brown Trout, 7.5cm, 20g, 1buc/pac

1571118
Livrare imediată!

36,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

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

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

1546305
Livrare 7-14 zile

24,00Lei

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

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

1546293
Livrare 7-14 zile

20,00Lei

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

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

1152513
Livrare 7-14 zile

32,00Lei

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

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

1571128
Livrare 7-14 zile

43,99Lei

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

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

1595276
Livrare 7-14 zile

32,00Lei

Mulineta Abu Garcia Superior 3000SH

Mulineta Abu Garcia Superior 3000SH

1500959
Livrare imediată!

449,96Lei

Minciog Pliabil Abu Garcia Spike Foldable Landing Net, 60x50cm

Minciog Pliabil Abu Garcia Spike Foldable Landing Net, 60x50cm

1544417
Livrare imediată!

317,00Lei

Afişare 541 - 560 din 1150 (58 pagini)
Queries: 7, Total time: 86.184 ms [By time] [By id] [By file]
1 (0.072)
SELECT data
FROM `oc_session`
WHERE session_id = '883eca973db4bb2bd18725867b'
/var/www/clients/client1/web1/web/system/library/session/db.php:24
2 (0.087)
SELECT `trigger`, `action`
FROM oc_event
/var/www/clients/client1/web1/web/index.php:453
3 (0.102)
SELECT *
FROM oc_url_alias
WHERE keyword = 'Abu-Garcia'
/var/www/clients/client1/web1/web/catalog/controller/common/seo_url.php:48
4 (0.099)
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 (35.585)
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 (50.073)
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 540,20
/var/www/clients/client1/web1/web/catalog/model/catalog/product.php:440
7 (0.166)
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