Shakespeare


Set Muste Shakespeare Sigma Fly Selection No2 Classic Wets

Set Muste Shakespeare Sigma Fly Selection No2 Classic Wets

1155007
Livrare imediată!

50,99Lei

Cutie Muste Shakespeare Sigma Fly Box Small

Cutie Muste Shakespeare Sigma Fly Box Small

1294089
Livrare 7-14 zile

87,43Lei

Lanseta Shakespeare Salt XT Light Rock Fishing 2.00m, 0.5-7g, 2seg

Lanseta Shakespeare Salt XT Light Rock Fishing 2.00m, 0.5-7g, 2seg

1544338
Livrare imediată!

258,25Lei

Taparina SHAKESPEARE Gummi Makk, Size 8/0, Blue, 1buc/pac

Taparina SHAKESPEARE Gummi Makk, Size 8/0, Blue, 1buc/pac

1581059
Livrare 7-14 zile

17,27Lei

Tava Laterala Shakespeare SKP pentru Scaun Modular 51x42x5.5cm

Tava Laterala Shakespeare SKP pentru Scaun Modular 51x42x5.5cm

1552885
Livrare imediată!

146,99Lei

Waders Shakespeare Sigma Nylon Hip Wader, Marime 45

Waders Shakespeare Sigma Nylon Hip Wader, Marime 45

1280622
Livrare 7-14 zile

196,23Lei

Kit Spinning pentru Copii SHAKESPEARE Cosmic Spinning Combo Pink, 12-38g

Kit Spinning pentru Copii SHAKESPEARE Cosmic Spinning Combo Pink, 12-38g

1512023
Livrare imediată!

142,34Lei

Vas Pentru Nada SKP Cu Capac Si Sita

Vas Pentru Nada SKP Cu Capac Si Sita

1550516
Livrare imediată!

108,78Lei

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

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

1542596
Livrare imediată!

344,68Lei

Scaun Pliabil Shakespeare Deluxe cu Rucsac

Scaun Pliabil Shakespeare Deluxe cu Rucsac

1154489
Livrare 7-14 zile

269,44Lei

Combo SHAKESPEARE Cedar Canyon Carbon Fly Kit, 5/6WT, 2.40m, 4seg

Combo SHAKESPEARE Cedar Canyon Carbon Fly Kit, 5/6WT, 2.40m, 4seg

1591086
Livrare 7-14 zile

323,32Lei

Kit Spinning pentru Copii SHAKESPEARE Catch a Monster Spin Purple

Kit Spinning pentru Copii SHAKESPEARE Catch a Monster Spin Purple

1506887
Livrare imediată!

122,00Lei

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

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

1542586
Livrare 7-14 zile

472,80Lei

Minciog Pastrav Shakespeare Agility Trout Small

Minciog Pastrav Shakespeare Agility Trout Small

1315260
Livrare 7-14 zile

130,14Lei

Taparina SHAKESPEARE Sandeel Rig, Size 12, 20Lbs, 1buc/pac

Taparina SHAKESPEARE Sandeel Rig, Size 12, 20Lbs, 1buc/pac

1550455
Livrare 7-14 zile

15,25Lei

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

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

1381022
Livrare 7-14 zile

408,74Lei

Waders Shakespeare Sigma Nylon Chest Wader, Marime 45

Waders Shakespeare Sigma Nylon Chest Wader, Marime 45

1280634
Livrare 7-14 zile

241,98Lei

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

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

1581056
Livrare 7-14 zile

17,27Lei

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

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

1542601
Livrare 7-14 zile

504,99Lei

Cutie Accesorii Shakespeare Tackle Box System Small

Cutie Accesorii Shakespeare Tackle Box System Small

1247787
Livrare 7-14 zile

116,92Lei

Afişare 181 - 200 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: 80.733 ms [By time] [By id] [By file]
1 (0.112)
SELECT data
FROM `oc_session`
WHERE session_id = 'b4ca68136a0c3cd20d9e781b8b'
/var/www/clients/client1/web1/web/system/library/session/db.php:24
2 (0.093)
SELECT `trigger`, `action`
FROM oc_event
/var/www/clients/client1/web1/web/index.php:453
3 (0.102)
SELECT *
FROM oc_url_alias
WHERE keyword = 'Shakespeare'
/var/www/clients/client1/web1/web/catalog/controller/common/seo_url.php:48
4 (0.103)
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 = '0'
/var/www/clients/client1/web1/web/catalog/model/catalog/manufacturer.php:4
5 (30.453)
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 = '0' AND p.manufacturer_id = '191'
/var/www/clients/client1/web1/web/catalog/model/catalog/product.php:1699
6 (49.766)
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 = '0' AND p.manufacturer_id = '191' GROUP BY p.product_id
ORDER BY p.sort_order ASC LIMIT 180,20
/var/www/clients/client1/web1/web/catalog/model/catalog/product.php:440
7 (0.104)
SELECT *
FROM `oc_mxt_setting`
WHERE store_id = '0' AND name = 'lichidare_stoc'
/var/www/clients/client1/web1/web/catalog/model/catalog/category.php:37