Shakespeare


Lanseta Shakespeare Salt Boat 602 1.80m, 20-30lb

Lanseta Shakespeare Salt Boat 602 1.80m, 20-30lb

1544312
Livrare 7-14 zile

186,06Lei

Lanseta Shakespeare Superteam SFX Plus Method, 3.85m, 150g, 3+3buc -20%

Lanseta Shakespeare Superteam SFX Plus Method, 3.85m, 150g, 3+3buc

1558417
Livrare imediată!

494,96Lei(-20%) 397,45Lei

Mulineta Shakespeare Superteam FLX 2000 5+1rul

Mulineta Shakespeare Superteam FLX 2000 5+1rul

1546260
Livrare 7-14 zile

301,97Lei

Mulineta Shakespeare Firebird 50 FD Spinning Reel

Mulineta Shakespeare Firebird 50 FD Spinning Reel

1551685
Livrare 7-14 zile

95,57Lei

Mulineta Shakespeare Superteam Feeder Reel 3500 -9%

Mulineta Shakespeare Superteam Feeder Reel 3500

1537671
Livrare imediată!

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

Mulineta Shakespeare Oracle 2 Fly 3/4

Mulineta Shakespeare Oracle 2 Fly 3/4

1542616
Livrare 7-14 zile

366,03Lei

Lanseta Shakespeare Cypry Carp 3.90m, 3.5lb, 3seg

Lanseta Shakespeare Cypry Carp 3.90m, 3.5lb, 3seg

1381125
Livrare 7-14 zile

236,91Lei

Varga Shakespeare Firebird Pole 8m

Varga Shakespeare Firebird Pole 8m

1550381
Livrare imediată!

164,71Lei

Mulineta Shakespeare Multiplicator Salt 20 LB LH

Mulineta Shakespeare Multiplicator Salt 20 LB LH

1545360
Livrare imediată!

280,62Lei

Mulineta Shakespeare Superteam FL 2500

Mulineta Shakespeare Superteam FL 2500

1546258
Livrare 7-14 zile

236,91Lei

Mulineta Shakespeare Cedar Canyon Disk Fly Reel, clasa 5/6

Mulineta Shakespeare Cedar Canyon Disk Fly Reel, clasa 5/6

1564803
Livrare 7-14 zile

186,06Lei

Mulineta Shakespeare Salt Spin 70 Pre-Spooled

Mulineta Shakespeare Salt Spin 70 Pre-Spooled

1548353
Livrare 7-14 zile

126,07Lei

Combo Shakespeare Salt Boat Basher 2.10m, 100-300g, 2seg

Combo Shakespeare Salt Boat Basher 2.10m, 100-300g, 2seg

1558969
Livrare 7-14 zile

282,66Lei

Lanseta Shakespeare Salt Boat 702 20-30lbs 2.13m

Lanseta Shakespeare Salt Boat 702 20-30lbs 2.13m

1544314
Livrare imediată!

207,41Lei

Perna Scaun Shakespeare Seatbox Cushion

Perna Scaun Shakespeare Seatbox Cushion

1443816
Livrare imediată!

101,66Lei

Juvelnic Shakespeare Challenge XT Square Keepnet 3m

Juvelnic Shakespeare Challenge XT Square Keepnet 3m

1551677
Livrare 7-14 zile

112,84Lei

Lanseta SHAKESPEARE Firebird Spinning Rod, 20-80g, 2.70m, 2seg

Lanseta SHAKESPEARE Firebird Spinning Rod, 20-80g, 2.70m, 2seg

1550423
Livrare 7-14 zile

143,35Lei

Suport Feeder Shakespeare SKP Front Rod Rest EVA 35cm

Suport Feeder Shakespeare SKP Front Rod Rest EVA 35cm

1550489
Livrare 7-14 zile

82,24Lei

Lanseta Shakespeare Cypry 3.60m 3lb 2buc

Lanseta Shakespeare Cypry 3.60m 3lb 2buc

1381122
Livrare 7-14 zile

215,55Lei

Combo Shakespeare Firebird Tele Spinning 3.00m, 20-50g

Combo Shakespeare Firebird Tele Spinning 3.00m, 20-50g

1550301
Livrare 7-14 zile

181,98Lei

Afişare 61 - 80 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: 102.157 ms [By time] [By id] [By file]
1 (0.093)
SELECT data
FROM `oc_session`
WHERE session_id = '41c2dc76f3a4506914b04ce59a'
/var/www/clients/client1/web1/web/system/library/session/db.php:24
2 (0.100)
SELECT `trigger`, `action`
FROM oc_event
/var/www/clients/client1/web1/web/index.php:453
3 (0.122)
SELECT *
FROM oc_url_alias
WHERE keyword = 'Shakespeare'
/var/www/clients/client1/web1/web/catalog/controller/common/seo_url.php:48
4 (0.123)
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 = '0'
/var/www/clients/client1/web1/web/catalog/model/catalog/manufacturer.php:4
5 (55.938)
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 = '191'
/var/www/clients/client1/web1/web/catalog/model/catalog/product.php:1699
6 (45.690)
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 = '0' AND p.manufacturer_id = '191' GROUP BY p.product_id
ORDER BY p.sort_order ASC LIMIT 60,20
/var/www/clients/client1/web1/web/catalog/model/catalog/product.php:440
7 (0.091)
SELECT *
FROM `oc_mxt_setting`
WHERE store_id = '0' AND name = 'lichidare_stoc'
/var/www/clients/client1/web1/web/catalog/model/catalog/category.php:37