Shakespeare


Saltea De Primire Shakespeare SKP Pop-Up Mat L

Saltea De Primire Shakespeare SKP Pop-Up Mat L

1550503
Livrare 7-14 zile

359,96Lei

Lanseta, Shakespeare, Skp, Solitude, Super, Float, 3.93m, 1550412, Lansete Match, Lansete Match Shakespeare, Shakespeare
Mulineta Shakespeare Salt Surf Long Cast 70 FD 7+1

Mulineta Shakespeare Salt Surf Long Cast 70 FD 7+1

1544321
Livrare 7-14 zile

269,96Lei

Geanta Shakespeare Superteam Bait Cooler

Geanta Shakespeare Superteam Bait Cooler

1550326
Livrare 7-14 zile

224,96Lei

Varga Shakespeare Superteam Xertion Margin Pole 4.5m

Varga Shakespeare Superteam Xertion Margin Pole 4.5m

1558414
Livrare 7-14 zile

269,96Lei

Rucsac Shakespeare Salt Rucksack

Rucsac Shakespeare Salt Rucksack

1545370
Livrare 7-14 zile

247,46Lei

Lanseta Shakespeare Skp Concept Float 3.30m, 2seg

Lanseta Shakespeare Skp Concept Float 3.30m, 2seg

1550390
Livrare 7-14 zile

292,46Lei

Cap Minciog Shakespeare Challenge XT Specimen Landing Net Head 90cm

Cap Minciog Shakespeare Challenge XT Specimen Landing Net Head 90cm

1551682
Livrare 7-14 zile

93,46Lei

Lanseta Shakespeare Superteam SFX Plus Method, 3.30m, 80g, 3+3buc -21%

Lanseta Shakespeare Superteam SFX Plus Method, 3.30m, 80g, 3+3buc

1573279
Livrare imediată!

449,96Lei(-21%) 353,89Lei

Lanseta, Shakespeare, Skp, Solitude, Barbel, 3.60m, 2.00lb, 1550406, Lansete Match, Lansete Match Shakespeare, Shakespeare
Mulineta Shakespeare Oracle 2 Fly 3/4 -33%

Mulineta Shakespeare Oracle 2 Fly 3/4

1542616
Livrare 7-14 zile

360,00Lei(-33%) 243,00Lei

Lanseta Shakespeare Superteam Sc-3 Pellet Waggler Rod 3.00m, 85-140g

Lanseta Shakespeare Superteam Sc-3 Pellet Waggler Rod 3.00m, 85-140g

1558405
Livrare 7-14 zile

359,96Lei

Mulineta Shakespeare Mach III Spinning Reel 4000

Mulineta Shakespeare Mach III Spinning Reel 4000

1537781
Livrare imediată!

206,96Lei

Mulineta Shakespeare Firebird 30 RD

Mulineta Shakespeare Firebird 30 RD

1550360
Livrare 7-14 zile

63,71Lei

Lanseta, Shakespeare, Challenge, XT, Coarse, Rod, Feeder, 2,43m,, 2+2seg, 1551666, Lansete Feeder, Lansete Feeder Shakespeare, Lansete Shakespeare, Feeder Shakespeare, Shakespeare
Lanseta Shakespeare Cypry 3.60m 3lb 2buc

Lanseta Shakespeare Cypry 3.60m 3lb 2buc

1381122
Livrare 7-14 zile

202,45Lei

Lanseta Shakespeare Skp B1 12Ft, 2.25Lb

Lanseta Shakespeare Skp B1 12Ft, 2.25Lb

1564324
Livrare 7-14 zile

494,96Lei

Lanseta Shakespeare Skp Concept Light Tip 3.30m, 3+2seg

Lanseta Shakespeare Skp Concept Light Tip 3.30m, 3+2seg

1550397
Livrare 7-14 zile

404,96Lei

Suport, Lansete, Shakespeare, Sand, Spike, 1207870, Picheti, Picheti Shakespeare, Picheti Shakespeare, Shakespeare
Geanta Shakespeare Short Session Bag

Geanta Shakespeare Short Session Bag

1550320
Livrare 7-14 zile

179,96Lei

Afişare 41 - 60 din 343 (18 pagini)
Queries: 7, Total time: 63.075 ms [By time] [By id] [By file]
1 (0.110)
SELECT data
FROM `oc_session`
WHERE session_id = '8ead45256e3c02927fc05615f0'
/var/www/clients/client1/web1/web/system/library/session/db.php:23
2 (0.091)
SELECT `trigger`, `action`
FROM oc_event
/var/www/clients/client1/web1/web/index.php:427
3 (0.112)
SELECT *
FROM oc_url_alias
WHERE keyword = 'Shakespeare'
/var/www/clients/client1/web1/web/catalog/controller/common/seo_url.php:48
4 (0.106)
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.387)
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 (32.158)
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 40,20
/var/www/clients/client1/web1/web/catalog/model/catalog/product.php:438
7 (0.110)
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