Shakespeare


Mulineta Shakespeare Salt Spin 40 FD

Mulineta Shakespeare Salt Spin 40 FD

1544319
Livrare imediată!

323,32Lei

Mulineta Shakespeare Oracle 2 Fly 10/11

Mulineta Shakespeare Oracle 2 Fly 10/11

1542620
Livrare 7-14 zile

559,23Lei

Combo Shakespeare Salt Pier Pounder 3.00m, 112-225g, 2seg

Combo Shakespeare Salt Pier Pounder 3.00m, 112-225g, 2seg

1558964
Livrare 7-14 zile

302,98Lei

Mulineta SHAKESPEARE Firebird Spinning Reel 60FS

Mulineta SHAKESPEARE Firebird Spinning Reel 60FS

1550365
Livrare 7-14 zile

108,78Lei

Lanseta feeder Shakespeare SKP Concept Feeder 3.60m 2+3buc -20%

Lanseta feeder Shakespeare SKP Concept Feeder 3.60m 2+3buc

1550398
Livrare imediată!

427,46Lei(-20%) 343,56Lei

Ham pentru Cutie Shakespeare Seat Box Sherpa

Ham pentru Cutie Shakespeare Seat Box Sherpa

1155184
Livrare 7-14 zile

151,49Lei

Tava Laterala Shakespeare Seatbox Side Tray Black

Tava Laterala Shakespeare Seatbox Side Tray Black

1407344
Livrare 7-14 zile

83,36Lei

Buzz Bar Shakespeare SKP Feeder 2 Posturi 22cm 2buc/set -34%

Buzz Bar Shakespeare SKP Feeder 2 Posturi 22cm 2buc/set

1550487
Livrare 7-14 zile

149,96Lei(-34%) 98,55Lei

Husa Vergi Shakespeare Superteam Pole Holdall

Husa Vergi Shakespeare Superteam Pole Holdall

1550341
Livrare 7-14 zile

472,80Lei

Combo Shakespeare Firebird Carp 3.60m 3.00lb

Combo Shakespeare Firebird Carp 3.60m 3.00lb

1549714
Livrare imediată!

282,66Lei

Lanseta Shakespeare Cedar Canyon Select Fly Rod, WT5/6, 2.44m, 3seg

Lanseta Shakespeare Cedar Canyon Select Fly Rod, WT5/6, 2.44m, 3seg

1590982
Livrare 7-14 zile

130,14Lei

Pichet SHAKESPEARE Value Rod Rest, Black, 80cm, 1buc/pac

Pichet SHAKESPEARE Value Rod Rest, Black, 80cm, 1buc/pac

1155129
Livrare 7-14 zile

20,32Lei

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

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

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

Scaun Shakespeare Compact Folding Stool Verde/Maro 60km

Scaun Shakespeare Compact Folding Stool Verde/Maro 60km

1154481
Livrare 7-14 zile

124,03Lei

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

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

1381124
Livrare imediată!

215,55Lei

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: 61.988 ms [By time] [By id] [By file]
1 (0.116)
SELECT data
FROM `oc_session`
WHERE session_id = 'c6b69d20786fa5ad8a58aa762d'
/var/www/clients/client1/web1/web/system/library/session/db.php:24
2 (0.110)
SELECT `trigger`, `action`
FROM oc_event
/var/www/clients/client1/web1/web/index.php:453
3 (0.109)
SELECT *
FROM oc_url_alias
WHERE keyword = 'Shakespeare'
/var/www/clients/client1/web1/web/catalog/controller/common/seo_url.php:48
4 (0.092)
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.196)
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 (32.222)
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 60,20
/var/www/clients/client1/web1/web/catalog/model/catalog/product.php:440
7 (0.143)
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