Abu Garcia

Abu Garcia

Sortare după:

Lingurita Rotativa ABU GARCIA Reflex Arctic LF, Pearl White, 7g, 4.5cm

Lingurita Rotativa ABU GARCIA Reflex Arctic LF, Pearl White, 7g, 4.5cm

1549932

Livrare 7-14 zile

21,34Lei

Mulineta Abu Garcia Cardinal 54 FD 4000

Mulineta Abu Garcia Cardinal 54 FD 4000

1345014

Livrare 7-14 zile

134,20Lei

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

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

1550151

Livrare 7-14 zile

118,96Lei

Lanseta Abu Garcia Devil Spinning 902M, 2.74m, 15-40g, 2buc

Lanseta Abu Garcia Devil Spinning 902M, 2.74m, 15-40g, 2buc

1216280

Livrare 7-14 zile

275,54Lei

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

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

1572790

Livrare 7-14 zile

33,54Lei

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

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

1559941

Livrare 7-14 zile

62,01Lei

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

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

1596293

Livrare 7-14 zile

45,74Lei

Lingurita Oscilanta Rattlin Abu Garcia Atom, Fegis, 45g, 12cm

Lingurita Oscilanta Rattlin Abu Garcia Atom, Fegis, 45g, 12cm

1525551

Livrare imediată!

41,67Lei

Lanseta Abu Garcia SOLV AG3 Spinning Rod AG3 M, 10-30g, 3.00m, 2seg

Lanseta Abu Garcia SOLV AG3 Spinning Rod AG3 M, 10-30g, 3.00m, 2seg

1539120

Livrare 7-14 zile

859,18Lei

Lanseta Abu Garcia Spike Pro Jigging Rod 802MH, 14-40g, 2.44m, 2seg

Lanseta Abu Garcia Spike Pro Jigging Rod 802MH, 14-40g, 2.44m, 2seg

1548569

Livrare imediată!

1.116,44Lei

Lanseta Abu Garcia Beast Spinning Rod 802H, 40-90g, 2.44m, 2seg

Lanseta Abu Garcia Beast Spinning Rod 802H, 40-90g, 2.44m, 2seg

1561321

Livrare 7-14 zile

472,80Lei

Lanseta Abu Garcia Svartzonker X 7112H, 30-100g, 2.40m, 2seg

Lanseta Abu Garcia Svartzonker X 7112H, 30-100g, 2.40m, 2seg

1579821

Livrare 7-14 zile

408,74Lei

Vobler Abu Garcia Svartzonker McTracer, Yellowfin Perch, 150g, 16.5cm

Vobler Abu Garcia Svartzonker McTracer, Yellowfin Perch, 150g, 16.5cm

1572608

Livrare 7-14 zile

94,55Lei

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

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

1549807

Livrare 7-14 zile

66,08Lei

Mulineta Abu Garcia Cardinal 50 FD 500

Mulineta Abu Garcia Cardinal 50 FD 500

1345010

Livrare 7-14 zile

116,92Lei

Combo Abu Garcia Tormentor2 Spinning ML 1000, 5-18g, 2.13m, 3seg

Combo Abu Garcia Tormentor2 Spinning ML 1000, 5-18g, 2.13m, 3seg

1612922

Livrare 7-14 zile

443,31Lei

Lanseta Abu Garica Beast X Trolling Casting Rod XXH, 50-230g, 2.74m, 2seg

Lanseta Abu Garica Beast X Trolling Casting Rod XXH, 50-230g, 2.74m, 2seg

1612437

Livrare 7-14 zile

580,58Lei

Lanseta Abu Garica Beast X Casting Rod MH, 20-70g, 2.13m, 1+1seg

Lanseta Abu Garica Beast X Casting Rod MH, 20-70g, 2.13m, 1+1seg

1612425

Livrare 7-14 zile

430,09Lei

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

323,32Lei

Shad ABU GARCIA Beast Paddletail, Shadow Tiger, 17cm, 49g, 6buc/pac

Shad ABU GARCIA Beast Paddletail, Shadow Tiger, 17cm, 49g, 6buc/pac

1621262

Livrare 7-14 zile

171,82Lei

Afişare 801 - 820 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: 96.376 ms [By time] [By id] [By file]

1 (0.103)

SELECT data
FROM `oc_session`
WHERE session_id = '76e8929453ec366118e55cb5c5'

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

2 (0.119)

SELECT `trigger`, `action`
FROM oc_event

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

3 (0.110)

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

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

4 (0.102)

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 (42.067)

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 (53.783)

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 800,20

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

7 (0.092)

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