Shakespeare


Geanta Shakespeare Superteam Tackle and Accessory Bag

Geanta Shakespeare Superteam Tackle and Accessory Bag

1550317
Livrare 7-14 zile

472,80Lei

Mulineta Shakespeare Oracle 2 Fly 8/9

Mulineta Shakespeare Oracle 2 Fly 8/9

1542619
Livrare 7-14 zile

515,50Lei

Combo Shakespeare Salt Surf Slayer 3.60m, 112-170g, 2seg

Combo Shakespeare Salt Surf Slayer 3.60m, 112-170g, 2seg

1558963
Livrare imediată!

342,65Lei

Mulineta SHAKESPEARE Firebird Spinning Reel 60FS

Mulineta SHAKESPEARE Firebird Spinning Reel 60FS

1550366
Livrare 7-14 zile

130,14Lei

Suport Modular Shakespeare SKP pentru Umbrela 22cm -21%

Suport Modular Shakespeare SKP pentru Umbrela 22cm

1550483
Livrare imediată!

44,50Lei(-21%) 34,96Lei

Lanseta Shakespeare Cypry Carp Tele 3.60m, 3lb

Lanseta Shakespeare Cypry Carp Tele 3.60m, 3lb

1381127
Livrare 7-14 zile

236,91Lei

Lanseta Shakespeare Challenge XT Coarse Rod Feeder 2,73m, 2+2seg

Lanseta Shakespeare Challenge XT Coarse Rod Feeder 2,73m, 2+2seg

1551665
Livrare 7-14 zile

224,70Lei

Husa Lansete Shakespeare Rod Sling, 2 lansete

Husa Lansete Shakespeare Rod Sling, 2 lansete

1550337
Livrare imediată!

254,18Lei

Mulineta Shakespeare Salt Spin 80 Pre-Spooled

Mulineta Shakespeare Salt Spin 80 Pre-Spooled

1548354
Livrare 7-14 zile

138,27Lei

Set Picheti Shakespeare Standard Bank Stick Selection, 6buc/set -31%

Set Picheti Shakespeare Standard Bank Stick Selection, 6buc/set

1155127
Livrare imediată!

123,17Lei(-31%) 85,29Lei

Lanseta Shakespeare Salt Boat 702 12-20lbs 2.13m -19%

Lanseta Shakespeare Salt Boat 702 12-20lbs 2.13m

1544313
Livrare imediată!

202,46Lei(-19%) 163,59Lei

Mulineta Shakespeare Salt Surf Long Cast 80 FD 7+1

Mulineta Shakespeare Salt Surf Long Cast 80 FD 7+1

1544322
Livrare 7-14 zile

344,68Lei

Lanseta Shakespeare Salt Boat 502 1.50m, 12-20lb

Lanseta Shakespeare Salt Boat 502 1.50m, 12-20lb

1544310
Livrare 7-14 zile

172,84Lei

Mulineta Shakespeare SKP FS Spinning 4000

Mulineta Shakespeare SKP FS Spinning 4000

1564319
Livrare 7-14 zile

280,62Lei

CAP MINCIOG SHAKESPEARE LANDING NET HEAD 72cm

CAP MINCIOG SHAKESPEARE LANDING NET HEAD 72cm

1550529
Livrare imediată!

92,47Lei

Cablu Shakespeare Sigma Retainer

Cablu Shakespeare Sigma Retainer

1294097
Livrare 7-14 zile

130,14Lei

Cap Minciog Shakespeare Challenge XT Specimen Landing Net Head 105cm

Cap Minciog Shakespeare Challenge XT Specimen Landing Net Head 105cm

1551681
Livrare 7-14 zile

99,63Lei

Lanseta SHAKESPEARE Firebird Spinning Rod, 10-25g, 1.80m, 2seg

Lanseta SHAKESPEARE Firebird Spinning Rod, 10-25g, 1.80m, 2seg

1550427
Livrare 7-14 zile

87,43Lei

Lanseta Shakespeare Superteam SFX Method Feeder, 3.90m, 200g, 3seg

Lanseta Shakespeare Superteam SFX Method Feeder, 3.90m, 200g, 3seg

1558429
Livrare imediată!

366,03Lei

Lanseta Shakespeare Cypry Carp 3.00m, 3lb, 2seg

Lanseta Shakespeare Cypry Carp 3.00m, 3lb, 2seg

1381119
Livrare imediată!

194,19Lei

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: 65.240 ms [By time] [By id] [By file]
1 (0.161)
SELECT data
FROM `oc_session`
WHERE session_id = 'f61ae17352ee77f77f2d498696'
/var/www/clients/client1/web1/web/system/library/session/db.php:24
2 (0.079)
SELECT `trigger`, `action`
FROM oc_event
/var/www/clients/client1/web1/web/index.php:453
3 (0.091)
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 = '2'
/var/www/clients/client1/web1/web/catalog/model/catalog/manufacturer.php:4
5 (29.542)
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 (35.140)
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.123)
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