Shakespeare


Lanseta Shakespeare Skp Concept Specialist 3.60m, 1.25lb, 2seg

Lanseta Shakespeare Skp Concept Specialist 3.60m, 1.25lb, 2seg

1550385
Livrare 7-14 zile

314,96Lei

Cap Minciog Shakespeare Challenge XT Match Net Head Medium 50x40cm -18%

Cap Minciog Shakespeare Challenge XT Match Net Head Medium 50x40cm

1551679
Livrare 7-14 zile

42,50Lei(-18%) 35,00Lei

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

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

1155127
Livrare imediată!

123,17Lei

Lanseta Shakespeare Superteam SFX Plus Method, 3.96m, 180g, 3+3buc -17%

Lanseta Shakespeare Superteam SFX Plus Method, 3.96m, 180g, 3+3buc

1558416
Livrare imediată!

540,00Lei(-17%) 450,00Lei

Lanseta, Shakespeare, Skp, Solitude, Super, Float, 3.36m, 1550409, Lansete Match, Lansete Match Shakespeare, Shakespeare
Lanseta, Shakespeare, Superteam, Sc-3, Method-Feeder, Rod, 3.30m,, 60g,, 2+2seg, 1558412, Lansete Feeder, Lansete Feeder Shakespeare, Shakespeare
Mulineta, Shakespeare, Mach, III, Spinning, Reel, 1000, 1537728, Mulinete Rapitori, Mulinete Rapitori Shakespeare, Mulinete Shakespeare, Rapitori Shakespeare, Shakespeare
Husa Shakespeare Superteam pentru Mulinete

Husa Shakespeare Superteam pentru Mulinete

1550353
Livrare 7-14 zile

134,96Lei

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

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

1551664
Livrare 7-14 zile

220,96Lei

Suport Shakespeare Superteam Pole Roost Bar

Suport Shakespeare Superteam Pole Roost Bar

1564333
Livrare 7-14 zile

157,46Lei

Scaun Shakespeare Compact Folding Stool Verde/Maro 60km -21%

Scaun Shakespeare Compact Folding Stool Verde/Maro 60km

1154481
Livrare imediată!

112,46Lei(-21%) 88,90Lei

Lanseta, feeder, Shakespeare, SKP, Concept, Feeder, 3.60m, 2+3buc, 1550398, Lansete Feeder, Lansete Feeder Shakespeare, Shakespeare
Lanseta, Shakespeare, Skp, B1, 12Ft, 1.75Lb, 1564322, Lansete Crap, Lansete Crap Shakespeare, Shakespeare
Mulineta, Shakespeare, Superteam, FLX, 3000, 5+1rul, 1546262, Mulinete Rapitori, Mulinete Rapitori Shakespeare, Mulinete Shakespeare, Rapitori Shakespeare, Shakespeare
Mulineta Shakespeare SKP FS 6500

Mulineta Shakespeare SKP FS 6500

1564320
Livrare 7-14 zile

314,96Lei

Geanta, Shakespeare, All, Rounder, Carryall, M, 1550314, Genti Universale, Genti Universale Shakespeare, Shakespeare
Cap Minciog Shakespeare Superteam Silvers Fast Landing Net 45cm

Cap Minciog Shakespeare Superteam Silvers Fast Landing Net 45cm

1550538
Livrare 7-14 zile

89,96Lei

Combo Shakespeare Salt Boat Basher 2.40m, 100-300g, 2seg

Combo Shakespeare Salt Boat Basher 2.40m, 100-300g, 2seg

1558970
Livrare 7-14 zile

292,46Lei

Mulineta Shakespeare Cypry 60FS -21%

Mulineta Shakespeare Cypry 60FS

1381052
Livrare imediată!

179,96Lei(-21%) 141,90Lei

Juvelnic, Shakespeare, Superteam, Carp, Keepnet, 3m, 1550531, Juvelnice, Juvelnice Shakespeare, Juvelnice Shakespeare, Juvelnice Feeder, Juvelnice Feeder Shakespeare, Juvelnice Shakespeare, Feeder Shakespeare, Juvelnice Stationar, Juvelnice Stationar Shakespeare, Juvelnice Shakespeare, Stationar Shakespeare, Shakespeare
Afişare 1 - 20 din 343 (18 pagini)
Queries: 7, Total time: 62.850 ms [By time] [By id] [By file]
1 (0.165)
SELECT data
FROM `oc_session`
WHERE session_id = 'af71b3c242472dcf0093123369'
/var/www/clients/client1/web1/web/system/library/session/db.php:23
2 (0.139)
SELECT `trigger`, `action`
FROM oc_event
/var/www/clients/client1/web1/web/index.php:427
3 (0.134)
SELECT *
FROM oc_url_alias
WHERE keyword = 'Shakespeare'
/var/www/clients/client1/web1/web/catalog/controller/common/seo_url.php:48
4 (0.145)
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 (31.120)
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:1667
6 (30.980)
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, (SELECT price
FROM oc_product_special ps
WHERE ps.product_id = p.product_id AND ps.customer_group_id = '1' AND ((ps.date_start = '0000-00-00' OR ps.date_start < NOW()) AND (ps.date_end = '0000-00-00' OR ps.date_end > NOW()))
ORDER BY ps.priority ASC, ps.price ASC LIMIT 1) AS special, p.viewed, p.price
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' 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:438
7 (0.167)
SELECT *
FROM `oc_mxt_setting`
WHERE store_id = '2' AND name = 'lichidare_stoc'
/var/www/clients/client1/web1/web/catalog/model/catalog/category.php:38