Penn


Mulineta Penn Rival Black 6000LC

Mulineta Penn Rival Black 6000LC

1524482
Livrare 7-14 zile

457,55Lei

Lanseta Penn Conflict Elite Spinning, 2.90m, 8-45g, 2seg

Lanseta Penn Conflict Elite Spinning, 2.90m, 8-45g, 2seg

1558363
Livrare 7-14 zile

1.754,98Lei

Lanseta Penn Conflict Inshore 822 MH Max 45, 2.49m

Lanseta Penn Conflict Inshore 822 MH Max 45, 2.49m

1543703
Livrare imediată!

540,92Lei

Lanseta Penn Conflict Trolling Rod 701 M, 12-20lb, 2.13m, 1seg

Lanseta Penn Conflict Trolling Rod 701 M, 12-20lb, 2.13m, 1seg

1545357
Livrare 7-14 zile

582,62Lei

Mulineta Penn Squall Low Profile Reel Baitcast LH, 300LP

Mulineta Penn Squall Low Profile Reel Baitcast LH, 300LP

1525506
Livrare 7-14 zile

1.054,41Lei

Lanseta PENN Conflict X Inshore Spinning Rod 962MH, Up To 45g, 2.90m, 2seg

Lanseta PENN Conflict X Inshore Spinning Rod 962MH, Up To 45g, 2.90m, 2seg

1620703
Livrare 7-14 zile

582,62Lei

Mulineta PENN Battle IV Spin Reel Box, 8000

Mulineta PENN Battle IV Spin Reel Box, 8000

1621735
Livrare 7-14 zile

706,66Lei

Mulineta PENN Slammer IV 7500

Mulineta PENN Slammer IV 7500

1545768
Livrare 7-14 zile

1.448,93Lei

Mulineta Penn Conflict Il Spinning 5000

Mulineta Penn Conflict Il Spinning 5000

1422312
Livrare 7-14 zile

997,48Lei

Mulineta Penn Fierce IV Spinning FRCIV 1000 Reel Box

Mulineta Penn Fierce IV Spinning FRCIV 1000 Reel Box

1558701
Livrare 7-14 zile

353,83Lei

Mulineta Penn Wrath BX, 4000

Mulineta Penn Wrath BX, 4000

1596329
Livrare imediată!

312,14Lei

Mulineta Penn Slammer IV Spinning Reel Box, 4500HS

Mulineta Penn Slammer IV Spinning Reel Box, 4500HS

1545763
Livrare 7-14 zile

1.229,30Lei

Mulineta Penn Tidal Long Cast 8000, 4.3:1, 8rul

Mulineta Penn Tidal Long Cast 8000, 4.3:1, 8rul

1594963
Livrare imediată!

878,50Lei

Lanseta PENN Regiment IV Boat Travel Rod H, 20-30lbs, 2.28m, 4seg

Lanseta PENN Regiment IV Boat Travel Rod H, 20-30lbs, 2.28m, 4seg

1620459
Livrare 7-14 zile

623,30Lei

Lanseta Telescopica Penn Tidal X Telescopic Surf Solid Tip, 4.20m, 160g, 5seg

Lanseta Telescopica Penn Tidal X Telescopic Surf Solid Tip, 4.20m, 160g, 5seg

1621321
Livrare 7-14 zile

522,62Lei

Lanseta Telescopica PENN Tidal Tele Surf, 4.20m, 80-160g, 5seg

Lanseta Telescopica PENN Tidal Tele Surf, 4.20m, 80-160g, 5seg

1580074
Livrare 7-14 zile

482,97Lei

Combo Somn PENN Legion Cat Bronze Allround Catfish Combo 8000 CMB, 3.02m, 400g -18%

Combo Somn PENN Legion Cat Bronze Allround Catfish Combo 8000 CMB, 3.02m, 400g

1562877
Livrare imediată!

742,46Lei(-18%) 607,93Lei

Mulineta Penn Fierce IV Spinning FRCIV 5000 Reel Box

Mulineta Penn Fierce IV Spinning FRCIV 5000 Reel Box

1558710
Livrare 7-14 zile

457,55Lei

Mulineta Penn Clash Spinning Reel Box 2500

Mulineta Penn Clash Spinning Reel Box 2500

1522157
Livrare 7-14 zile

1.010,69Lei

Lanseta Penn Conflict Offshore Pelagic Casting Rod, 35-80g, 2.44m, 1+1seg

Lanseta Penn Conflict Offshore Pelagic Casting Rod, 35-80g, 2.44m, 1+1seg

1530415
Livrare 7-14 zile

790,05Lei

Afişare 1 - 20 din 341 (18 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: 71.465 ms [By time] [By id] [By file]
1 (0.109)
SELECT data
FROM `oc_session`
WHERE session_id = '9238c4d0bc75bf49c6a7636054'
/var/www/clients/client1/web1/web/system/library/session/db.php:24
2 (0.123)
SELECT `trigger`, `action`
FROM oc_event
/var/www/clients/client1/web1/web/index.php:453
3 (0.090)
SELECT *
FROM oc_url_alias
WHERE keyword = 'Penn'
/var/www/clients/client1/web1/web/catalog/controller/common/seo_url.php:48
4 (0.083)
SELECT *
FROM oc_manufacturer m
LEFT JOIN oc_manufacturer_to_store m2s ON (m.manufacturer_id = m2s.manufacturer_id)
WHERE m.manufacturer_id = '88' AND m2s.store_id = '3'
/var/www/clients/client1/web1/web/catalog/model/catalog/manufacturer.php:4
5 (38.040)
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 = '88'
/var/www/clients/client1/web1/web/catalog/model/catalog/product.php:1699
6 (32.897)
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 = '88' 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.123)
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