Abu Garcia


Mulineta Abu Garcia Max X SP10

Mulineta Abu Garcia Max X SP10

1523248
Livrare imediată!

191,21Lei

Mulineta Abu Garcia Cardinal 54 FD 4000

Mulineta Abu Garcia Cardinal 54 FD 4000

1345014
Livrare 7-14 zile

131,00Lei

Vobler Hard Bait Abu Garcia Svartzonker SVZ McMy Tail, Crucian Carp, 20cm, 83g

Vobler Hard Bait Abu Garcia Svartzonker SVZ McMy Tail, Crucian Carp, 20cm, 83g

1550147
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

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

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

1549804
Livrare 7-14 zile

60,00Lei

Vobler Abu Garcia Hard Bait Beast Hi-Lo Sinking, Striped Ayu, 33g, 14cm

Vobler Abu Garcia Hard Bait Beast Hi-Lo Sinking, Striped Ayu, 33g, 14cm

1572578
Livrare 7-14 zile

60,00Lei

Lingura Oscilanata Abu Garcia Hard Bait Toby Spoon, Devil, 10g, 5.7cm, 3buc/plic

Lingura Oscilanata Abu Garcia Hard Bait Toby Spoon, Devil, 10g, 5.7cm, 3buc/plic

1550263
Livrare 7-14 zile

52,00Lei

Mulineta Revo3 SX Spinning Reel, 4000MSH

Mulineta Revo3 SX Spinning Reel, 4000MSH

1563831
Livrare 7-14 zile

717,00Lei

Vobler Abu Garcia Hard Bait Beast Hi-Lo Sinking, Firetiger, 12.3g, 10cm

Vobler Abu Garcia Hard Bait Beast Hi-Lo Sinking, Firetiger, 12.3g, 10cm

1572565
Livrare imediată!

52,00Lei

Lanseta Abu Garcia SOLV AG1 Spinning Rod ML, 5-21g, 2.70m, 2seg

Lanseta Abu Garcia SOLV AG1 Spinning Rod ML, 5-21g, 2.70m, 2seg

1558834
Livrare 7-14 zile

2.235,00Lei

Lanseta Abu Garcia Veritas Spinning Rod ML, 5-21g, 2.23m, 2seg

Lanseta Abu Garcia Veritas Spinning Rod ML, 5-21g, 2.23m, 2seg

1558816
Livrare 7-14 zile

548,99Lei

Lanseta Abu Garcia Travel Salmo Seeker Spinning 804ML, 8-20g, 2.40m, 4seg

Lanseta Abu Garcia Travel Salmo Seeker Spinning 804ML, 8-20g, 2.40m, 4seg

1302972
Livrare 7-14 zile

548,99Lei

Combo Abu Garcia Fast Attack Pike Spinning Combo MH, 10-50g, 2.40m, 2seg

Combo Abu Garcia Fast Attack Pike Spinning Combo MH, 10-50g, 2.40m, 2seg

1562061
Livrare 7-14 zile

455,00Lei

Mulineta Abu Garcia Alphamar LC Syncro RH 20

Mulineta Abu Garcia Alphamar LC Syncro RH 20

1302969
Livrare 7-14 zile

633,00Lei

Vobler Abu Garcia Svartzonker Mc My Tail, Yellowfin Perch, 50g, 17cm

Vobler Abu Garcia Svartzonker Mc My Tail, Yellowfin Perch, 50g, 17cm

1550142
Livrare 7-14 zile

103,99Lei

Lingura Rotativa Abu Garcia Droppen Maxi Spinners, Green Back Minnow, 12g, 8.5cm

Lingura Rotativa Abu Garcia Droppen Maxi Spinners, Green Back Minnow, 12g, 8.5cm

1581018
Livrare 7-14 zile

64,00Lei

Lingurita Oscilanta Abu Garcia Atom, G/Green, 35g, 9cm

Lingurita Oscilanta Abu Garcia Atom, G/Green, 35g, 9cm

p.1312847
Livrare 24-48 ore

34,50Lei

Lanseta ABU GARCIA Tormentor 2 Travel Spinning Rod L, 4-12g, 1.83m, 3seg

Lanseta ABU GARCIA Tormentor 2 Travel Spinning Rod L, 4-12g, 1.83m, 3seg

1612485
Livrare 7-14 zile

148,00Lei

Lanseta Abu Garcia Carabus Delicate 2 Spinning Rod UL, 0.8-4g, 2.29m, 2seg

Lanseta Abu Garcia Carabus Delicate 2 Spinning Rod UL, 0.8-4g, 2.29m, 2seg

1620707
Livrare 7-14 zile

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

Afişare 1 - 20 din 1094 (55 pagini)
Queries: 7, Total time: 79.672 ms [By time] [By id] [By file]
1 (0.076)
SELECT data
FROM `oc_session`
WHERE session_id = '08edeaa32fb863efa1a48f9a0a'
/var/www/clients/client1/web1/web/system/library/session/db.php:24
2 (0.118)
SELECT `trigger`, `action`
FROM oc_event
/var/www/clients/client1/web1/web/index.php:453
3 (0.135)
SELECT *
FROM oc_url_alias
WHERE keyword = 'Abu-Garcia'
/var/www/clients/client1/web1/web/catalog/controller/common/seo_url.php:48
4 (0.133)
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 (34.976)
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 (44.115)
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 0,20
/var/www/clients/client1/web1/web/catalog/model/catalog/product.php:440
7 (0.119)
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