Shakespeare


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

Husa Lansete Shakespeare Superteam Rod Holdall

Husa Lansete Shakespeare Superteam Rod Holdall

1550342
Livrare 7-14 zile

472,80Lei

Combo Shakespeare Firebird Feeder 3.00m

Combo Shakespeare Firebird Feeder 3.00m

1549716
Livrare imediată!

262,32Lei

Lanseta Shakespeare Cedar Canyon Elite Fly Rod, WT7/8, 2.74m, 4seg

Lanseta Shakespeare Cedar Canyon Elite Fly Rod, WT7/8, 2.74m, 4seg

1591094
Livrare imediată!

258,25Lei

Combo SHAKESPEARE Firebird Mackerel, 112-225g, 3.00m, 2seg

Combo SHAKESPEARE Firebird Mackerel, 112-225g, 3.00m, 2seg

1550308
Livrare imediată!

274,52Lei

Afişare 41 - 60 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: 89.480 ms [By time] [By id] [By file]
1 (0.098)
SELECT data
FROM `oc_session`
WHERE session_id = 'c6b69d20786fa5ad8a58aa762d'
/var/www/clients/client1/web1/web/system/library/session/db.php:24
2 (0.119)
SELECT `trigger`, `action`
FROM oc_event
/var/www/clients/client1/web1/web/index.php:453
3 (0.121)
SELECT *
FROM oc_url_alias
WHERE keyword = 'Shakespeare'
/var/www/clients/client1/web1/web/catalog/controller/common/seo_url.php:48
4 (0.113)
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 (54.619)
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 (34.261)
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 40,20
/var/www/clients/client1/web1/web/catalog/model/catalog/product.php:440
7 (0.149)
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