Abu Garcia


Vobler, Abu, Garcia, Svartzonker, McHybrid, Baby, Green, Pumpkin, 8cm, 11g, 1446041, Voblere Suspending, Voblere Suspending Abu Garcia, Abu Garcia
MULINETA, ABU, GARCIA, MAX, STX, 1000, 1532489, Mulinete Rapitori, Mulinete Rapitori Abu Garcia, Mulinete Abu Garcia, Rapitori Abu Garcia, Abu Garcia
Montura Abu Garcia Svartzonker Stinger Small, Nr.2/0, 2buc/plic

Montura Abu Garcia Svartzonker Stinger Small, Nr.2/0, 2buc/plic

1524010
Livrare imediată!

55,20Lei

Vobler Hard Bait Abu Garcia Svartzonker SVZ McMy Tail, Motoroil Burbot, 20cm, 83g

Vobler Hard Bait Abu Garcia Svartzonker SVZ McMy Tail, Motoroil Burbot, 20cm, 83g

1550148
Livrare 7-14 zile

115,96Lei

Lanseta Abu Garcia Seven Boat Sea Fishing Rod 2.10m, 30lbs

Lanseta Abu Garcia Seven Boat Sea Fishing Rod 2.10m, 30lbs

1111022
Livrare 7-14 zile

169,96Lei

VOBLER, ABU, GARCIA, SVARTZONKER, MCCELLY,, REAL, HOT, PIKE,, 14CM,, 64G, 1531920, Voblere Sinking, Voblere Sinking Abu Garcia, Abu Garcia
Vobler Abu Garcia Hard Bait Beast Hi-Lo Floating, Red Tiger, 47g, 12cm

Vobler Abu Garcia Hard Bait Beast Hi-Lo Floating, Red Tiger, 47g, 12cm

1572590
Livrare imediată!

63,71Lei

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

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

1581017
Livrare imediată!

63,96Lei

Lanseta Abu Garcia ORRA Predator Spinning Rod 802 MH, 7-28g, 2.44m, 2seg

Lanseta Abu Garcia ORRA Predator Spinning Rod 802 MH, 7-28g, 2.44m, 2seg

1580847
Livrare imediată!

301,46Lei

Lanseta Abu Garcia Venerate Spinning Cork Rod ML, 5-20g, 2.44m, 2seg

Lanseta Abu Garcia Venerate Spinning Cork Rod ML, 5-20g, 2.44m, 2seg

1539841
Livrare 7-14 zile

267,71Lei

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 Veritas Spinning Rod H, 20-60g, 2.74m, 2seg

Lanseta Abu Garcia Veritas Spinning Rod H, 20-60g, 2.74m, 2seg

1558824
Livrare 7-14 zile

679,96Lei

Lanseta Abu Garcia Vendetta V3 Spinning Rod 702ML, 5-20g, 2.13m, 2seg

Lanseta Abu Garcia Vendetta V3 Spinning Rod 702ML, 5-20g, 2.13m, 2seg

1544425
Livrare 7-14 zile

359,96Lei

Combo Abu Garcia Revolution Red 802M, 20-45g, 2.40m, 2seg

Combo Abu Garcia Revolution Red 802M, 20-45g, 2.40m, 2seg

1532612
Livrare 7-14 zile

494,96Lei

Mulineta Abu Garcia Revo 5 X-W LP Casting Reel Left Hand

Mulineta Abu Garcia Revo 5 X-W LP Casting Reel Left Hand

1565149
Livrare 7-14 zile

552,46Lei

Lanseta Abu Garcia Spike Pro Vertical Pelagic Casting Rod 6311H, 28-70g, 1.90m, 1+1seg

Lanseta Abu Garcia Spike Pro Vertical Pelagic Casting Rod 6311H, 28-70g, 1.90m, 1+1seg

1539718
Livrare 7-14 zile

1.079,96Lei

Pluta Abu Garcia Bombarda Intermed Float Stop, Clear, 25g

Pluta Abu Garcia Bombarda Intermed Float Stop, Clear, 25g

1110085
Livrare imediată!

16,80Lei

VOBLER, ABU, GARCIA, SVARTZONKER, MCMIO, FIRE, CARP, FLASH, 18cm, 54g, 1550131, Voblere Sinking, Voblere Sinking Abu Garcia, Abu Garcia
Shad Abu Garcia Svartzonker McPrey Prerigged, Ray of Light, 22g, 12cm, 3buc/blister -27%

Shad Abu Garcia Svartzonker McPrey Prerigged, Ray of Light, 22g, 12cm, 3buc/blister

1553316
Livrare imediată!

63,96Lei(-27%) 46,99Lei

Mulineta Abu Garcia Cardinal 53 FD 4000

Mulineta Abu Garcia Cardinal 53 FD 4000

1345014
Livrare imediată!

123,20Lei

Afişare 1 - 20 din 687 (35 pagini)
Queries: 10, Total time: 87.879 ms [By time] [By id] [By file]
1 (0.099)
SELECT data
FROM `oc_session`
WHERE session_id = '5659a4bd247e1e95fcf2fd6a4e'
/var/www/clients/client1/web1/web/system/library/session/db.php:23
2 (0.086)
SELECT *
FROM oc_platforma_promovari LIMIT 1
/var/www/clients/client1/web1/web/index.php:128
3 (0.084)
SELECT `trigger`, `action`
FROM oc_event
/var/www/clients/client1/web1/web/index.php:422
4 (0.164)
SELECT *
FROM oc_url_alias
WHERE keyword = 'Abu-Garcia'
/var/www/clients/client1/web1/web/catalog/controller/common/seo_url.php:48
5 (0.112)
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
6 (48.713)
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:1650
7 (38.229)
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, (SELECT price
FROM oc_product_special ps
WHERE ps.product_id = p.product_id AND ps.customer_group_id = '1' AND ((ps.date_start = '0000-00-00' OR ps.date_start < NOW()) AND (ps.date_end = '0000-00-00' OR ps.date_end > NOW()))
ORDER BY ps.priority ASC, ps.price ASC LIMIT 1) AS special, p.viewed, p.price
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' 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:432
8 (0.154)
SELECT *
FROM oc_url_alias
WHERE `query` = 'product_id=165628'
/var/www/clients/client1/web1/web/catalog/controller/common/seo_url.php:169
9 (0.117)
SELECT *
FROM oc_platforma_promovari
/var/www/clients/client1/web1/web/catalog/model/common/platforma.php:4
10 (0.121)
SELECT *
FROM `oc_mxt_setting`
WHERE store_id = '0' AND name = 'lichidare_stoc'
/var/www/clients/client1/web1/web/catalog/model/catalog/category.php:38