Penn


Geanta Penn Waterproof Rollup Bag, 59x27x43cm -63%

Geanta Penn Waterproof Rollup Bag, 59x27x43cm

1543824
Livrare 7-14 zile

249,95Lei(-63%) 91,74Lei

Lanseta Telescopica PENN Wrath Bolescopic, Up To 110g, 2.44m, 4seg

Lanseta Telescopica PENN Wrath Bolescopic, Up To 110g, 2.44m, 4seg

1581624
Livrare 7-14 zile

250,12Lei

Mulineta Penn International VISW 80 Silver

Mulineta Penn International VISW 80 Silver

1419236
Livrare 7-14 zile

5.422,62Lei

Ulei Pentru Mulinete Penn Precision Reel Oil

Ulei Pentru Mulinete Penn Precision Reel Oil

1238738
Livrare imediată!

50,82Lei

Husa Mulinete Penn Neoprene Spinning Reel Cover Large

Husa Mulinete Penn Neoprene Spinning Reel Cover Large

1203359
Livrare imediată!

70,56Lei

Mulineta Penn International VIS 130 Gold

Mulineta Penn International VIS 130 Gold

1370785
Livrare 7-14 zile

7.455,21Lei

Mulineta Penn Fathom Il Level Wind 30

Mulineta Penn Fathom Il Level Wind 30

1481311
Livrare 7-14 zile

1.361,49Lei

Mulineta Penn Squall II Level Wind Reel Box Left Hand, 20LW

Mulineta Penn Squall II Level Wind Reel Box Left Hand, 20LW

1545926
Livrare 7-14 zile

834,78Lei

Lanseta Penn Tidal Africa Surfcasting EH, 4.00m, 600-800g, 3seg

Lanseta Penn Tidal Africa Surfcasting EH, 4.00m, 600-800g, 3seg

1548370
Livrare 7-14 zile

683,27Lei

Mulineta Penn Squall Lever Drag 2 Speed 16 VS

Mulineta Penn Squall Lever Drag 2 Speed 16 VS

1292936
Livrare 7-14 zile

1.317,76Lei

Mulineta Penn Fathom Il Star Drag 15

Mulineta Penn Fathom Il Star Drag 15

1505233
Livrare 7-14 zile

1.054,41Lei

Mulineta Penn Senator Star Drag 115L2 RH

Mulineta Penn Senator Star Drag 115L2 RH

1199904
Livrare 7-14 zile

878,50Lei

Lanseta Penn Tidal Surfcasting 4.20m, 50-200g, 3seg

Lanseta Penn Tidal Surfcasting 4.20m, 50-200g, 3seg

1541068
Livrare 7-14 zile

563,29Lei

Mulineta Penn Squall II Star Drag Reel Box Left Hand, 30N

Mulineta Penn Squall II Star Drag Reel Box Left Hand, 30N

1522172
Livrare 7-14 zile

965,96Lei

Mulineta Penn International VISW 30 Silver

Mulineta Penn International VISW 30 Silver

1419231
Livrare 7-14 zile

3.728,62Lei

Husa Protectie Tamburi Penn Spool Case, 21x8x8cm -63%

Husa Protectie Tamburi Penn Spool Case, 21x8x8cm

1545375
Livrare 7-14 zile

99,95Lei(-63%) 37,29Lei

Lanseta PENN Tidal X K-type Hybrid Sensitip H, 100-300g, 4.20m, 3seg

Lanseta PENN Tidal X K-type Hybrid Sensitip H, 100-300g, 4.20m, 3seg

1621326
Livrare 7-14 zile

563,29Lei

Mulineta Penn International VISW 50 Gold

Mulineta Penn International VISW 50 Gold

1370781
Livrare 7-14 zile

3.873,00Lei

Mulineta Penn Fathom Il Level Wind 20

Mulineta Penn Fathom Il Level Wind 20

1481307
Livrare 7-14 zile

1.317,76Lei

Lanseta Telescopica PENN Wrath Bolescopic, Up To 110g, 2.13m, 3seg

Lanseta Telescopica PENN Wrath Bolescopic, Up To 110g, 2.13m, 3seg

1581638
Livrare imediată!

229,78Lei

Afişare 321 - 340 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: 113.914 ms [By time] [By id] [By file]
1 (0.103)
SELECT data
FROM `oc_session`
WHERE session_id = '87b9f446103adeac9bd9f40bb8'
/var/www/clients/client1/web1/web/system/library/session/db.php:24
2 (0.087)
SELECT `trigger`, `action`
FROM oc_event
/var/www/clients/client1/web1/web/index.php:453
3 (0.094)
SELECT *
FROM oc_url_alias
WHERE keyword = 'Penn'
/var/www/clients/client1/web1/web/catalog/controller/common/seo_url.php:48
4 (0.117)
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 (54.710)
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 (58.593)
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 320,20
/var/www/clients/client1/web1/web/catalog/model/catalog/product.php:440
7 (0.210)
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