Shakespeare


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

Scaun Pliabil Shakespeare Folding Stool

Scaun Pliabil Shakespeare Folding Stool

1154485
Livrare imediată!

101,66Lei

Husa Juvelnic Shakespeare Superteam Net Bag

Husa Juvelnic Shakespeare Superteam Net Bag

1550329
Livrare imediată!

186,06Lei

Taparina SHAKESPEARE Daylite Lure, Size 1/0, 1buc/pac

Taparina SHAKESPEARE Daylite Lure, Size 1/0, 1buc/pac

1550450
Livrare 7-14 zile

15,25Lei

Set Muste Shakespeare Sigma Fly Selection No5 Stillwater

Set Muste Shakespeare Sigma Fly Selection No5 Stillwater

1155011
Livrare imediată!

49,82Lei

Asomator Somon Shakespeare Sigma Salmon Priest Stick

Asomator Somon Shakespeare Sigma Salmon Priest Stick

1294094
Livrare 7-14 zile

108,78Lei

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

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

1581057
Livrare 7-14 zile

17,27Lei

Cărucior Shakespeare Seat Box

Cărucior Shakespeare Seat Box

1155195
Livrare 7-14 zile

387,39Lei

Lanseta Shakespeare Salt Surfcasting 4.20m, 112-170g, 3seg

Lanseta Shakespeare Salt Surfcasting 4.20m, 112-170g, 3seg

1544307
Livrare 7-14 zile

408,74Lei

Waders Shakespeare Sigma Nylon Chest Wader, Marime 42

Waders Shakespeare Sigma Nylon Chest Wader, Marime 42

1280631
Livrare 7-14 zile

241,98Lei

Minciog pentru Copii Shakespeare Cosmic Net Pink

Minciog pentru Copii Shakespeare Cosmic Net Pink

1512027
Livrare imediată!

70,14Lei

Taparina SHAKESPEARE Flatfish Pro, Size 6, 40Lbs, 1buc/pac

Taparina SHAKESPEARE Flatfish Pro, Size 6, 40Lbs, 1buc/pac

1550459
Livrare 7-14 zile

15,25Lei

Set Muste Shakespeare Sigma Dry Flies

Set Muste Shakespeare Sigma Dry Flies

1155005
Livrare imediată!

49,82Lei

Afişare 141 - 160 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: 66.157 ms [By time] [By id] [By file]
1 (0.097)
SELECT data
FROM `oc_session`
WHERE session_id = 'd96415ba77b0f87a5c54c85a66'
/var/www/clients/client1/web1/web/system/library/session/db.php:24
2 (0.082)
SELECT `trigger`, `action`
FROM oc_event
/var/www/clients/client1/web1/web/index.php:453
3 (0.099)
SELECT *
FROM oc_url_alias
WHERE keyword = 'Shakespeare'
/var/www/clients/client1/web1/web/catalog/controller/common/seo_url.php:48
4 (0.121)
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 (33.473)
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 (32.093)
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 140,20
/var/www/clients/client1/web1/web/catalog/model/catalog/product.php:440
7 (0.192)
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