Shakespeare


Suport pentru Juvelnic Shakespeare SKP Keepnet Adaptor 13cm -32%

Suport pentru Juvelnic Shakespeare SKP Keepnet Adaptor 13cm

1552886
Livrare imediată!

34,94Lei(-32%) 23,78Lei

Tripod Shakespeare Salt Beach Rest

Tripod Shakespeare Salt Beach Rest

1154609
Livrare 7-14 zile

559,23Lei

Waders Shakespeare Sigma Nylon Chest Wader, Marime 41

Waders Shakespeare Sigma Nylon Chest Wader, Marime 41

1280630
Livrare imediată!

229,74Lei

Minciog pentru Copii Shakespeare Cosmic Net Orange

Minciog pentru Copii Shakespeare Cosmic Net Orange

1512026
Livrare imediată!

70,14Lei

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

Waders Shakespeare Sigma Nylon Hip Wader, Marime 42

Waders Shakespeare Sigma Nylon Hip Wader, Marime 42

1280619
Livrare 7-14 zile

196,23Lei

Kit Spinning pentru Copii SHAKESPEARE Cosmic Spinning Combo Orange

Kit Spinning pentru Copii SHAKESPEARE Cosmic Spinning Combo Orange

1512020
Livrare imediată!

142,34Lei

Taparina SHAKESPEARE Bottom Hugger Sea Rig, Size 6, 20Lbs, 60cm, 1buc/pac

Taparina SHAKESPEARE Bottom Hugger Sea Rig, Size 6, 20Lbs, 60cm, 1buc/pac

1550454
Livrare 7-14 zile

15,25Lei

Tava Laterala Shakespeare SKP pentru Scaun Modular, 39.5x31x5cm

Tava Laterala Shakespeare SKP pentru Scaun Modular, 39.5x31x5cm

1550482
Livrare imediată!

70,14Lei

Waders Shakespeare Sigma Neoprene Chest, Marime 46

Waders Shakespeare Sigma Neoprene Chest, Marime 46

1290714
Livrare 7-14 zile

341,63Lei

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

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

1542592
Livrare 7-14 zile

559,23Lei

Afişare 201 - 220 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: 67.466 ms [By time] [By id] [By file]
1 (0.119)
SELECT data
FROM `oc_session`
WHERE session_id = '1c5b12fdad6ec9ff1636c23c3a'
/var/www/clients/client1/web1/web/system/library/session/db.php:24
2 (0.117)
SELECT `trigger`, `action`
FROM oc_event
/var/www/clients/client1/web1/web/index.php:453
3 (0.133)
SELECT *
FROM oc_url_alias
WHERE keyword = 'Shakespeare'
/var/www/clients/client1/web1/web/catalog/controller/common/seo_url.php:48
4 (0.127)
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 (34.314)
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.562)
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 200,20
/var/www/clients/client1/web1/web/catalog/model/catalog/product.php:440
7 (0.094)
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