Shakespeare


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

Lanseta Shakespeare Cedar Canyon Fly Rod, WT5/6, 2.43m, 4seg

Lanseta Shakespeare Cedar Canyon Fly Rod, WT5/6, 2.43m, 4seg

1591091
Livrare 7-14 zile

151,49Lei

Kit Naluci Leurres ZEBCO Target Fish Trout Spin

Kit Naluci Leurres ZEBCO Target Fish Trout Spin

z0960014
Livrare 7-14 zile

38,28Lei

Mulineta Shakespeare Salt Spin 40 FD

Mulineta Shakespeare Salt Spin 40 FD

1544319
Livrare imediată!

323,32Lei

Combo Shakespeare Catch More Fish 2 Combo 2.10m, 5-15g

Combo Shakespeare Catch More Fish 2 Combo 2.10m, 5-15g

1423614
Livrare imediată!

362,98Lei

Mulineta Shakespeare Cedar Canyon Click Fly Reel, clasa 7/8

Mulineta Shakespeare Cedar Canyon Click Fly Reel, clasa 7/8

1564801
Livrare imediată!

130,14Lei

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 Shakespeare Oracle 2 River Fly 2.59m, Clasa 4, 4seg

Lanseta Shakespeare Oracle 2 River Fly 2.59m, Clasa 4, 4seg

1542597
Livrare 7-14 zile

344,68Lei

Maner Minciog Shakespeare Challenge XT Tele Landing Net Handle 3m

Maner Minciog Shakespeare Challenge XT Tele Landing Net Handle 3m

1551674
Livrare imediată!

91,50Lei

Combo SHAKESPEARE Cedar Canyon Elite Fly Combo, 5/6WT, 2.74m, 4seg

Combo SHAKESPEARE Cedar Canyon Elite Fly Combo, 5/6WT, 2.74m, 4seg

1591088
Livrare 7-14 zile

403,66Lei

Kit Spinning pentru Copii SHAKESPEARE Catch a Monster Spin Pink

Kit Spinning pentru Copii SHAKESPEARE Catch a Monster Spin Pink

1506888
Livrare imediată!

137,99Lei

Lanseta Shakespeare Oracle 2 Stillwater Fly 2.90m, Clasa 7, 4seg

Lanseta Shakespeare Oracle 2 Stillwater Fly 2.90m, Clasa 7, 4seg

1542587
Livrare 7-14 zile

472,80Lei

Minciog Barca Shakespeare Agility Boat

Minciog Barca Shakespeare Agility Boat

1315261
Livrare 7-14 zile

138,27Lei

Lanseta Shakespeare Sigma Supra Fly 3.00m, Clasa 6, 4seg

Lanseta Shakespeare Sigma Supra Fly 3.00m, Clasa 6, 4seg

1381024
Livrare 7-14 zile

387,39Lei

Waders Shakespeare Sigma Nylon Chest Wader, Marime 46

Waders Shakespeare Sigma Nylon Chest Wader, Marime 46

1280635
Livrare imediată!

241,98Lei

Taparina SHAKESPEARE Gummi Makk, Size 5/0, Red, 1buc/pac

Taparina SHAKESPEARE Gummi Makk, Size 5/0, Red, 1buc/pac

1581052
Livrare 7-14 zile

17,27Lei

Lanseta Shakespeare Oracle 2 River Fly 3.05m, Clasa 4, 4seg

Lanseta Shakespeare Oracle 2 River Fly 3.05m, Clasa 4, 4seg

1542602
Livrare imediată!

366,03Lei

Afişare 101 - 120 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.740 ms [By time] [By id] [By file]
1 (0.076)
SELECT data
FROM `oc_session`
WHERE session_id = 'c6b69d20786fa5ad8a58aa762d'
/var/www/clients/client1/web1/web/system/library/session/db.php:24
2 (0.068)
SELECT `trigger`, `action`
FROM oc_event
/var/www/clients/client1/web1/web/index.php:453
3 (0.082)
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.222)
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.049)
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 100,20
/var/www/clients/client1/web1/web/catalog/model/catalog/product.php:440
7 (0.151)
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