Shakespeare


Lanseta, feeder, Shakespeare, SKP, Concept, Feeder, 3.60m, 2+3buc, 1550398, Lansete Feeder, Lansete Feeder Shakespeare, Shakespeare
Lanseta Shakespeare Skp B1 12Ft 1.75Lb

Lanseta Shakespeare Skp B1 12Ft 1.75Lb

1564322
Livrare 7-14 zile

494,96Lei

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

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, 1551664, Lansete Feeder, Lansete Feeder Shakespeare, Lansete Shakespeare, Feeder Shakespeare, Shakespeare
Suport Shakespeare Superteam Pole Roost Bar

Suport Shakespeare Superteam Pole Roost Bar

1564333
Livrare 7-14 zile

157,46Lei

Mulineta Shakespeare Cypry 60FS -21%

Mulineta Shakespeare Cypry 60FS

1381052
Livrare imediată!

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

Juvelnic Shakespeare Superteam Carp Keepnet 3m

Juvelnic Shakespeare Superteam Carp Keepnet 3m

1550531
Livrare imediată!

247,46Lei

Lanseta Shakespeare Superteam CX 9Ft Feeder 2.70m, 3-6lb

Lanseta Shakespeare Superteam CX 9Ft Feeder 2.70m, 3-6lb

1558438
Livrare 7-14 zile

269,96Lei

Lanseta, Shakespeare, Skp, Concept, Power, Float, 3.90m,, 3seg, 1550394, Lansete Match, Lansete Match Shakespeare, Shakespeare
Lanseta, Shakespeare, Superteam, SC-1, Commercial, Feeder,, 3.30m,, 2+1seg, 1558432, Lansete Feeder, Lansete Feeder Shakespeare, Shakespeare
Geanta Shakespeare All Rounder Carryall M

Geanta Shakespeare All Rounder Carryall M

1550314
Livrare 7-14 zile

269,96Lei

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, Salt, Spin, 40, FD, 1544319, Mulinete Rapitori, Mulinete Rapitori Shakespeare, Mulinete Shakespeare, Rapitori Shakespeare, Shakespeare
Lanseta, Shakespeare, Skp, Solitude, Feeder, 3.65m,, 2+1, Seg, 1550417, Lansete Feeder, Lansete Feeder Shakespeare, Shakespeare
Mulineta Shakespeare Oracle 2 Fly 8/9

Mulineta Shakespeare Oracle 2 Fly 8/9

1542619
Livrare 7-14 zile

494,96Lei

Husa Lansete Shakespeare Rod Sling, 2 lansete

Husa Lansete Shakespeare Rod Sling, 2 lansete

1550337
Livrare 7-14 zile

247,46Lei

Afişare 121 - 140 din 343 (18 pagini)
Queries: 7, Total time: 57.756 ms [By time] [By id] [By file]
1 (0.107)
SELECT data
FROM `oc_session`
WHERE session_id = '9ca472eacf0b3465fd8aa4beb2'
/var/www/clients/client1/web1/web/system/library/session/db.php:23
2 (0.121)
SELECT `trigger`, `action`
FROM oc_event
/var/www/clients/client1/web1/web/index.php:427
3 (0.145)
SELECT *
FROM oc_url_alias
WHERE keyword = 'Shakespeare'
/var/www/clients/client1/web1/web/catalog/controller/common/seo_url.php:48
4 (0.140)
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 (26.333)
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:1667
6 (30.806)
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 = '0' AND p.manufacturer_id = '191' GROUP BY p.product_id
ORDER BY p.sort_order ASC LIMIT 120,20
/var/www/clients/client1/web1/web/catalog/model/catalog/product.php:438
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:38