Abu Garcia


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

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

1546307
Livrare 7-14 zile

24,00Lei

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

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

1546294
Livrare 7-14 zile

20,00Lei

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

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

1248393
Livrare 7-14 zile

32,00Lei

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

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

1579947
Livrare 7-14 zile

43,99Lei

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

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

1595277
Livrare 7-14 zile

32,00Lei

Lingurita Oscilanta ABU GARCIA Jazz Spoon, Silver Red, 10g, 4.5cm, 1buc/pac

Lingurita Oscilanta ABU GARCIA Jazz Spoon, Silver Red, 10g, 4.5cm, 1buc/pac

1248365
Livrare 7-14 zile

22,00Lei

Mulineta Abu Garcia Carabus AG SX 1000

Mulineta Abu Garcia Carabus AG SX 1000

1525863
Livrare imediată!

338,00Lei

Lingurita Rotativa ABU GARCIA Droppen LF, Culoare Orange, 4.4cm, 6g

Lingurita Rotativa ABU GARCIA Droppen LF, Culoare Orange, 4.4cm, 6g

1549727
Livrare 7-14 zile

18,00Lei

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

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

1549759
Livrare 7-14 zile

24,00Lei

Vobler Hard Bait Abu Garcia Svartzonker SVZ McMy Tail, Real Roach, 20cm, 83g

Vobler Hard Bait Abu Garcia Svartzonker SVZ McMy Tail, Real Roach, 20cm, 83g

1550145
Livrare 7-14 zile

116,00Lei

Minciog Abu Garcia Pliabil cu Maner Telescopic 60-150cm

Minciog Abu Garcia Pliabil cu Maner Telescopic 60-150cm

1152217
Livrare 7-14 zile

262,00Lei

Vobler Abu Garcia Hard Bait Svartzonker McSnack, Evelina FL Perch, 9cm, 22g

Vobler Abu Garcia Hard Bait Svartzonker McSnack, Evelina FL Perch, 9cm, 22g

1517088
Livrare 7-14 zile

64,00Lei

Vobler Abu Garcia Hard Bait Beast Hi-Lo Floating, Bronze Bomber, 47g, 12cm

Vobler Abu Garcia Hard Bait Beast Hi-Lo Floating, Bronze Bomber, 47g, 12cm

1572592
Livrare imediată!

60,00Lei

Lingura Oscilanata Abu Garcia Hard Bait Toby Assorted, 12g, 7.5cm, 3buc/plic

Lingura Oscilanata Abu Garcia Hard Bait Toby Assorted, 12g, 7.5cm, 3buc/plic

1550264
Livrare 7-14 zile

60,00Lei

Lingurita Oscilanta Rattlin Abu Garcia Atom, Baltic Herring, 45g, 12cm

Lingurita Oscilanta Rattlin Abu Garcia Atom, Baltic Herring, 45g, 12cm

1525558
Livrare imediată!

40,00Lei

Lanseta Abu Garcia Venerate Spinning Cork Rod M, 10-30g, 2.13m, 2seg

Lanseta Abu Garcia Venerate Spinning Cork Rod M, 10-30g, 2.13m, 2seg

1539840
Livrare 7-14 zile

275,00Lei

Lanseta Abu Garcia EON Spinning Rod L, 2-10g, 2.03m, 2seg

Lanseta Abu Garcia EON Spinning Rod L, 2-10g, 2.03m, 2seg

1561341
Livrare imediată!

809,96Lei

Lanseta Abu Garcia Vendetta V3 Casting Rod MH, 15-40g, 2.74m, 2seg

Lanseta Abu Garcia Vendetta V3 Casting Rod MH, 15-40g, 2.74m, 2seg

1544529
Livrare 7-14 zile

464,00Lei

Geanta Accesorii Abu Garcia Beast Pro EVA Boat Bag XL, 46x28x27cm

Geanta Accesorii Abu Garcia Beast Pro EVA Boat Bag XL, 46x28x27cm

1532341
Livrare 7-14 zile

445,46Lei

Mulineta Baitcast Abu Garcia Max 4 Low Profile Reel RH 40LP

Mulineta Baitcast Abu Garcia Max 4 Low Profile Reel RH 40LP

1543123
Livrare imediată!

759,01Lei

Afişare 181 - 200 din 1277 (64 pagini)
Queries: 7, Total time: 81.670 ms [By time] [By id] [By file]
1 (0.109)
SELECT data
FROM `oc_session`
WHERE session_id = '6a65315d914950539facda735f'
/var/www/clients/client1/web1/web/system/library/session/db.php:24
2 (0.061)
SELECT `trigger`, `action`
FROM oc_event
/var/www/clients/client1/web1/web/index.php:453
3 (0.085)
SELECT *
FROM oc_url_alias
WHERE keyword = 'Abu-Garcia'
/var/www/clients/client1/web1/web/catalog/controller/common/seo_url.php:48
4 (0.130)
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 (35.004)
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 (46.145)
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 180,20
/var/www/clients/client1/web1/web/catalog/model/catalog/product.php:440
7 (0.136)
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