Shakespeare


Lanseta Shakespeare Superteam SFX Plus Method, 3.30m, 80g, 3+3buc -20%

Lanseta Shakespeare Superteam SFX Plus Method, 3.30m, 80g, 3+3buc

1573279
Livrare imediată!

449,96Lei(-20%) 360,91Lei

Mulineta Shakespeare Superteam FLX 2500 5+1rul

Mulineta Shakespeare Superteam FLX 2500 5+1rul

1546261
Livrare 7-14 zile

323,32Lei

Mulineta Shakespeare Salt Spin 20 FD

Mulineta Shakespeare Salt Spin 20 FD

1544317
Livrare imediată!

280,62Lei

Mulineta Shakespeare Superteam Feeder Reel 4500 -9%

Mulineta Shakespeare Superteam Feeder Reel 4500

1537672
Livrare imediată!

203,00Lei(-9%) 183,92Lei

Mulineta Shakespeare Oracle 2 Fly 5/6

Mulineta Shakespeare Oracle 2 Fly 5/6

1542617
Livrare 7-14 zile

387,39Lei

Combo Shakespeare Firebird Spin, 2.40m, 10-40g, 2seg

Combo Shakespeare Firebird Spin, 2.40m, 10-40g, 2seg

1552883
Livrare 7-14 zile

202,32Lei

Mulineta Shakespeare Cypry 60FS

Mulineta Shakespeare Cypry 60FS

1381052
Livrare 7-14 zile

186,06Lei

Lanseta Shakespeare Cypry Carp Tele 3.30m, 3lb, 5seg

Lanseta Shakespeare Cypry Carp Tele 3.30m, 3lb, 5seg

1381126
Livrare 7-14 zile

215,55Lei

Husa Protectie Varf Lanseta Shakespeare Superteam Tip/Butt Protector

Husa Protectie Varf Lanseta Shakespeare Superteam Tip/Butt Protector

1550495
Livrare imediată!

70,14Lei

Cap Minciog Shakespeare SKP 20"

Cap Minciog Shakespeare SKP 20"

1550527
Livrare imediată!

83,99Lei

Mulineta Shakespeare Cedar Canyon Premium Reel 5/6

Mulineta Shakespeare Cedar Canyon Premium Reel 5/6

1546661
Livrare 7-14 zile

164,71Lei

Mulineta Shakespeare Cedar Canyon Disk Fly Reel, clasa 7/8

Mulineta Shakespeare Cedar Canyon Disk Fly Reel, clasa 7/8

1564804
Livrare 7-14 zile

228,76Lei

Lanseta Shakespeare Salt Boat 702 30-50lbs 2.13m -19%

Lanseta Shakespeare Salt Boat 702 30-50lbs 2.13m

1548348
Livrare imediată!

224,96Lei(-19%) 181,89Lei

Mulineta Shakespeare Salt Surf Long Cast 70 FD 7+1

Mulineta Shakespeare Salt Surf Long Cast 70 FD 7+1

1544321
Livrare 7-14 zile

301,97Lei

Mulineta Shakespeare Mach III Spinning Reel 2000

Mulineta Shakespeare Mach III Spinning Reel 2000

1537779
Livrare imediată!

194,19Lei

Combo Shakespeare Salt Herring Hustler 3.00m, 90g, Tele

Combo Shakespeare Salt Herring Hustler 3.00m, 90g, Tele

1558971
Livrare 7-14 zile

282,66Lei

CAP MINCIOG SHAKESPEARE LANDING NET HEAD 60cm

CAP MINCIOG SHAKESPEARE LANDING NET HEAD 60cm

1550528
Livrare imediată!

94,99Lei

Cap Minciog Shakespeare Challenge XT Match Net Head Large 60x50cm

Cap Minciog Shakespeare Challenge XT Match Net Head Large 60x50cm

1551678
Livrare 7-14 zile

56,92Lei

Lanseta SHAKESPEARE Firebird Spinning Rod, 15-60g, 2.40m, 2seg

Lanseta SHAKESPEARE Firebird Spinning Rod, 15-60g, 2.40m, 2seg

1550425
Livrare 7-14 zile

108,78Lei

Lanseta Shakespeare Superteam SFX Plus Feeder, 3.45m, 60g, 3+2seg

Lanseta Shakespeare Superteam SFX Plus Feeder, 3.45m, 60g, 3+2seg

1558421
Livrare imediată!

472,80Lei

Afişare 1 - 20 din 226 (12 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: 66.348 ms [By time] [By id] [By file]
1 (0.080)
SELECT data
FROM `oc_session`
WHERE session_id = '7fb65b5c0103ccac62f93b075c'
/var/www/clients/client1/web1/web/system/library/session/db.php:24
2 (0.114)
SELECT `trigger`, `action`
FROM oc_event
/var/www/clients/client1/web1/web/index.php:453
3 (0.102)
SELECT *
FROM oc_url_alias
WHERE keyword = 'Shakespeare'
/var/www/clients/client1/web1/web/catalog/controller/common/seo_url.php:48
4 (0.096)
SELECT *
FROM oc_manufacturer m
LEFT JOIN oc_manufacturer_to_store m2s ON (m.manufacturer_id = m2s.manufacturer_id)
WHERE m.manufacturer_id = '191' AND m2s.store_id = '2'
/var/www/clients/client1/web1/web/catalog/model/catalog/manufacturer.php:4
5 (29.402)
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 = '2' AND p.manufacturer_id = '191'
/var/www/clients/client1/web1/web/catalog/model/catalog/product.php:1699
6 (36.396)
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 = '2' AND p.manufacturer_id = '191' 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.158)
SELECT *
FROM `oc_mxt_setting`
WHERE store_id = '2' AND name = 'lichidare_stoc'
/var/www/clients/client1/web1/web/catalog/model/catalog/category.php:37