Shakespeare


Lanseta Shakespeare Superteam SFX Plus Method, 3.96m, 180g, 3+3buc

Lanseta Shakespeare Superteam SFX Plus Method, 3.96m, 180g, 3+3buc

1558416
Livrare imediată!

559,23Lei

Adapost Shakespeare Salt Beach Shelter

Adapost Shakespeare Salt Beach Shelter

1545369
Livrare 7-14 zile

727,00Lei

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

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

1544311
Livrare 7-14 zile

186,06Lei

Suport Lansete Shakespeare Superteam EVA Support Bar Size L

Suport Lansete Shakespeare Superteam EVA Support Bar Size L

1564329
Livrare imediată!

87,43Lei

Scaun Shakespeare Compact Folding Stool Verde/Maro 60km

Scaun Shakespeare Compact Folding Stool Verde/Maro 60km

1154481
Livrare 7-14 zile

124,03Lei

Mulineta Shakespeare Salt Spin 3000fd

Mulineta Shakespeare Salt Spin 3000fd

1544318
Livrare imediată!

298,39Lei

Cap Minciog Shakespeare Challenge XT Specimen Landing Net Head 75cm

Cap Minciog Shakespeare Challenge XT Specimen Landing Net Head 75cm

1551683
Livrare 7-14 zile

87,43Lei

Lanseta Shakespeare Cypry Carp 3.60m, 3lb, 3seg

Lanseta Shakespeare Cypry Carp 3.60m, 3lb, 3seg

1381124
Livrare imediată!

215,55Lei

Mulineta Fly SHAKESPEARE Freeflow Centrepin Reel 4.25IN

Mulineta Fly SHAKESPEARE Freeflow Centrepin Reel 4.25IN

1609929
Livrare 7-14 zile

430,09Lei

Mulineta Shakespeare Salt Spin 60 Pre-Spooled

Mulineta Shakespeare Salt Spin 60 Pre-Spooled

1548352
Livrare 7-14 zile

116,92Lei

Mulineta Shakespeare Superteam Feeder FRX 3500 -8%

Mulineta Shakespeare Superteam Feeder FRX 3500

1537673
Livrare imediată!

296,00Lei(-8%) 271,37Lei

Mulineta Shakespeare Superteam FL 2000

Mulineta Shakespeare Superteam FL 2000

1546257
Livrare 7-14 zile

215,55Lei

Mulineta Shakespeare Cedar Canyon Disk Fly Reel, clasa 3/4

Mulineta Shakespeare Cedar Canyon Disk Fly Reel, clasa 3/4

1564802
Livrare 7-14 zile

164,71Lei

Suport Shakespeare SKP Feeder Chair Rear Rest 14cm

Suport Shakespeare SKP Feeder Chair Rear Rest 14cm

1552887
Livrare 7-14 zile

49,90Lei

Combo Shakespeare Salt Jetty Jouster 2.40m, 20-60g, Tele

Combo Shakespeare Salt Jetty Jouster 2.40m, 20-60g, Tele

1558968
Livrare 7-14 zile

262,32Lei

Brat Feeder Shakespeare SKP Vertical Feeder Arm

Brat Feeder Shakespeare SKP Vertical Feeder Arm

1550488
Livrare imediată!

164,71Lei

Suport Lansete Shakespeare Sand Spike

Suport Lansete Shakespeare Sand Spike

1207870
Livrare 7-14 zile

186,06Lei

Cutie Accesorii Shakespeare Seatbox Tacklebox

Cutie Accesorii Shakespeare Seatbox Tacklebox

1407345
Livrare 7-14 zile

56,92Lei

Juvelnic Shakespeare Challenge XT Round Keepnet 3m

Juvelnic Shakespeare Challenge XT Round Keepnet 3m

1551676
Livrare 7-14 zile

87,43Lei

Kit Accesorii Spinning pentru Copii SHAKESPEARE Cosmic Tackle Box Orange

Kit Accesorii Spinning pentru Copii SHAKESPEARE Cosmic Tackle Box Orange

1512024
Livrare imediată!

130,14Lei

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: 62.968 ms [By time] [By id] [By file]
1 (0.093)
SELECT data
FROM `oc_session`
WHERE session_id = 'ff9d40f42942d4b8a4f36de324'
/var/www/clients/client1/web1/web/system/library/session/db.php:24
2 (0.085)
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 = 'Shakespeare'
/var/www/clients/client1/web1/web/catalog/controller/common/seo_url.php:48
4 (0.104)
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 (30.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 = '0' AND p.manufacturer_id = '191'
/var/www/clients/client1/web1/web/catalog/model/catalog/product.php:1699
6 (32.415)
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 0,20
/var/www/clients/client1/web1/web/catalog/model/catalog/product.php:440
7 (0.137)
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