Abu Garcia

Abu Garcia

Sortare după:

Lingurita Oscilanta ABU GARCIA Shaky, Atomic Trout, 20g, 1buc/pac

Lingurita Oscilanta ABU GARCIA Shaky, Atomic Trout, 20g, 1buc/pac

1572792

Livrare 7-14 zile

33,54Lei

Lingura Oscilanata Abu Garcia Hard Bait Toby Spoon, Zebra, 60g, 11.5cm

Lingura Oscilanata Abu Garcia Hard Bait Toby Spoon, Zebra, 60g, 11.5cm

1550255

Livrare 7-14 zile

49,82Lei

Lingurita Rotativa ABU GARCIA Fast Attack Stickle Spinner, 10cm, 22g, Firetiger, 1buc/pac

Lingurita Rotativa ABU GARCIA Fast Attack Stickle Spinner, 10cm, 22g, Firetiger, 1buc/pac

1596295

Livrare 7-14 zile

45,74Lei

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

62,01Lei

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

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

1525558

Livrare imediată!

41,67Lei

Lanseta Abu Garcia SOLV AG3 Spinning Rod AG3 ML, 10-30g, 2.70m, 2seg

Lanseta Abu Garcia SOLV AG3 Spinning Rod AG3 ML, 10-30g, 2.70m, 2seg

1539119

Livrare 7-14 zile

816,48Lei

Mulineta Abu Garcia Revo X Spinning Reel, 2000S

Mulineta Abu Garcia Revo X Spinning Reel, 2000S

1563832

Livrare 7-14 zile

644,64Lei

Combo Abu Garcia Fast Attack Zander Spinning Combo M, 10-40g, 2.40m, 2seg

Combo Abu Garcia Fast Attack Zander Spinning Combo M, 10-40g, 2.40m, 2seg

1562060

Livrare 7-14 zile

463,65Lei

Vobler Abu Garcia Svartzonker McTracer, Blue Sunrise, 150g, 16.5cm

Vobler Abu Garcia Svartzonker McTracer, Blue Sunrise, 150g, 16.5cm

1572606

Livrare 7-14 zile

94,55Lei

Lingura Rotativa Abu Garcia Droppen Maxi Spinners, Roach, 12g, 8.5cm

Lingura Rotativa Abu Garcia Droppen Maxi Spinners, Roach, 12g, 8.5cm

1549805

Livrare 7-14 zile

66,08Lei

Lanseta Abu Garcia Spike X Jigging Rod 802 Medium, 2.44m,12-28g, 2seg

Lanseta Abu Garcia Spike X Jigging Rod 802 Medium, 2.44m,12-28g, 2seg

1539774

Livrare imediată!

730,05Lei

Combo Abu Garcia Tormentor2 Spinning M 3000, 7-28g, 2.74m, 3seg

Combo Abu Garcia Tormentor2 Spinning M 3000, 7-28g, 2.74m, 3seg

1612924

Livrare 7-14 zile

523,64Lei

Lanseta Abu Garica Fantasista Nano Casting Rod L, 2-14g, 1.98m, 1+1seg

Lanseta Abu Garica Fantasista Nano Casting Rod L, 2-14g, 1.98m, 1+1seg

1612438

Livrare 7-14 zile

997,48Lei

Lanseta Abu Garica Beast X Casting Rod H, 30-90g, 2.29m, 1+1seg

Lanseta Abu Garica Beast X Casting Rod H, 30-90g, 2.29m, 1+1seg

1612427

Livrare 7-14 zile

430,09Lei

Combo Abu Garcia Max X Spinning Combo 902MH, 15-40g, 2.74m, 2seg

Combo Abu Garcia Max X Spinning Combo 902MH, 15-40g, 2.74m, 2seg

1622866

Livrare 7-14 zile

342,65Lei

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

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

1621266

Livrare 7-14 zile

163,69Lei

Vobler ABU GARCIA Beast Hi-Lo Jointed Floating, Blue Herring, 12cm, 47g

Vobler ABU GARCIA Beast Hi-Lo Jointed Floating, Blue Herring, 12cm, 47g

1621248

Livrare 7-14 zile

62,01Lei

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

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

1609452

Livrare imediată!

33,54Lei

Multiplicator ABU GARCIA Revo 5 X Low Profile, Left

1400522

Livrare imediată!

1.574,60Lei(-24%) 1.201,84Lei

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

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

1550241

Livrare 7-14 zile

31,50Lei

Afişare 881 - 900 din 1426 (72 pagini)

💬

WhatsApp Chat

👋 Salut! Cu ce vă pot ajuta?

Pot răspunde la întrebări despre:
✅ Comenzi și status livrare
✅ Informatii produse
✅ Recomandari produse(beta)
✅ Compatibilitate intre produse(beta)

Queries: 7, Total time: 105.929 ms [By time] [By id] [By file]

1 (0.096)

SELECT data
FROM `oc_session`
WHERE session_id = '7b89b1b35f15daf43f5941e3a0'

/var/www/clients/client1/web1/web/system/library/session/db.php:24

2 (0.116)

SELECT `trigger`, `action`
FROM oc_event

/var/www/clients/client1/web1/web/index.php:453

3 (0.130)

SELECT *
FROM oc_url_alias
WHERE keyword = 'Abu-Garcia'

/var/www/clients/client1/web1/web/catalog/controller/common/seo_url.php:48

4 (0.100)

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 = '3'

/var/www/clients/client1/web1/web/catalog/model/catalog/manufacturer.php:4

5 (49.081)

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 = '3' AND p.manufacturer_id = '122'

/var/www/clients/client1/web1/web/catalog/model/catalog/product.php:1699

6 (56.265)

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 = '3' AND p.manufacturer_id = '122' GROUP BY p.product_id
ORDER BY p.sort_order ASC LIMIT 880,20

/var/www/clients/client1/web1/web/catalog/model/catalog/product.php:440

7 (0.141)

SELECT *
FROM `oc_mxt_setting`
WHERE store_id = '3' AND name = 'lichidare_stoc'

/var/www/clients/client1/web1/web/catalog/model/catalog/category.php:37