Shakespeare


CAP MINCIOG SHAKESPEARE LANDING NET HEAD 72cm

CAP MINCIOG SHAKESPEARE LANDING NET HEAD 72cm

1550529
Livrare imediată!

89,96Lei

Scaun Modular Shakespeare Superteam Seatbox System

Scaun Modular Shakespeare Superteam Seatbox System

1564341
Livrare 7-14 zile

1.574,96Lei

Mulineta, Shakespeare, Superteam, FLX, 2500, 5+1rul, 1546261, Mulinete Rapitori, Mulinete Rapitori Shakespeare, Mulinete Shakespeare, Rapitori Shakespeare, Shakespeare
Combo, Shakespeare, Salt, Surf, Slayer, 4.20m,, 100-200g,, 3seg, 1560635, Combo Rapitori, Combo Rapitori Shakespeare, Shakespeare
Mulineta, Shakespeare, Mach, II, Spinning, Reel, 4000, 1537727, Mulinete Rapitori, Mulinete Rapitori Shakespeare, Mulinete Shakespeare, Rapitori Shakespeare, Shakespeare
Husa Lansete Shakespeare SKP 2 Rod Quiver 140cm

Husa Lansete Shakespeare SKP 2 Rod Quiver 140cm

1550335
Livrare 7-14 zile

148,46Lei

Lanseta, Shakespeare, Challenge, XT, Coarse, Rod, Feeder, 3,64m,, 3+2seg, 1551662, Lansete Feeder, Lansete Feeder Shakespeare, Shakespeare
Suport Shakespeare Superteam EVA Pole Support Bar

Suport Shakespeare Superteam EVA Pole Support Bar

1564332
Livrare 7-14 zile

224,96Lei

Mulineta Shakespeare Multiplicator Salt 20 LB LH

Mulineta Shakespeare Multiplicator Salt 20 LB LH

1545360
Livrare imediată!

269,96Lei

Juvelnic Shakespeare Superteam Carp Keepnet 2.5m

Juvelnic Shakespeare Superteam Carp Keepnet 2.5m

1550530
Livrare 7-14 zile

224,96Lei

Lanseta Shakespeare Superteam CX 10Ft Feeder 3.00m, 3-6lb

Lanseta Shakespeare Superteam CX 10Ft Feeder 3.00m, 3-6lb

1558439
Livrare 7-14 zile

292,46Lei

Lanseta Shakespeare Skp Concept Float 3.90m, 3seg

Lanseta Shakespeare Skp Concept Float 3.90m, 3seg

1550393
Livrare 7-14 zile

359,96Lei

Lanseta Shakespeare Superteam SFX Method Feeder, 3.90m, 200g, 3seg -30%

Lanseta Shakespeare Superteam SFX Method Feeder, 3.90m, 200g, 3seg

1558429
Livrare imediată!

360,00Lei(-30%) 251,00Lei

Cap, Minciog, Shakespeare, Superteam, Carp, Fast, Landing, Net, 40cm, 1550537, Capete de Minciog, Capete de Minciog Shakespeare, Shakespeare
Combo Shakespeare Salt Boat Basher 2.10m, 100-300g, 2seg

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

1558969
Livrare 7-14 zile

269,96Lei

Lanseta Shakespeare Skp Solitude Big Barbel 3.60m 2.50lb

Lanseta Shakespeare Skp Solitude Big Barbel 3.60m 2.50lb

1550408
Livrare 7-14 zile

449,96Lei

Mulineta Shakespeare Oracle 2 Fly 7/8

Mulineta Shakespeare Oracle 2 Fly 7/8

1542618
Livrare 7-14 zile

404,96Lei

Husa Lansete Shakespeare Padded Rod Holdall, 3 lansete

Husa Lansete Shakespeare Padded Rod Holdall, 3 lansete

1550333
Livrare 7-14 zile

494,96Lei

Lanseta Shakespeare Superteam SFX Plus Feeder, 3.60m, 120g, 3+2seg -15%

Lanseta Shakespeare Superteam SFX Plus Feeder, 3.60m, 120g, 3+2seg

1558418
Livrare 7-14 zile

495,00Lei(-15%) 420,00Lei

Mulineta Shakespeare Superteam FL 2000

Mulineta Shakespeare Superteam FL 2000

1546257
Livrare 7-14 zile

202,46Lei

Afişare 1 - 20 din 343 (18 pagini)
Queries: 9, Total time: 59.579 ms [By time] [By id] [By file]
1 (0.101)
SELECT data
FROM `oc_session`
WHERE session_id = '517552293d847e90822b5648bd'
/var/www/clients/client1/web1/web/system/library/session/db.php:23
2 (0.123)
SELECT *
FROM oc_platforma_promovari LIMIT 1
/var/www/clients/client1/web1/web/index.php:128
3 (0.070)
SELECT `trigger`, `action`
FROM oc_event
/var/www/clients/client1/web1/web/index.php:422
4 (0.087)
SELECT *
FROM oc_url_alias
WHERE keyword = 'Shakespeare'
/var/www/clients/client1/web1/web/catalog/controller/common/seo_url.php:48
5 (0.125)
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
6 (26.372)
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:1650
7 (32.413)
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:432
8 (0.150)
SELECT *
FROM oc_platforma_promovari
/var/www/clients/client1/web1/web/catalog/model/common/platforma.php:4
9 (0.138)
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