Cressi Gringo Black

Name: Cressi Gringo Black
Brand: Cressi
SKU: 1084
Price: 10.0000 EUR
Availability: InStock

Κωδικός: 1084

Ένας εξαιρετικός και οικονομικός αναπνευστήρας από την Ιταλική εταιρεία cressi κατασκευασμένο από σιλικόνη

Δείτε τα όλα

Άμεσα Διαθέσιμο

10,00 € -10%

9,00 €

Δείτε όλα τα προϊόντα

Περιγραφή

Εξαιρετική επιλογή...

Ο αναπνευστήρας Gringo Black της Cressi είναι κατάλληλος για κολύμβηση αλλά και ελεύθερη κατάδυση.

Κατά την κολύμβηση ο Gringo, δεν φέρνει καμιά αντίσταση στο νερό λόγω της ελαφριάς κλίσης που έχει ο κορμός του.

Το υλικό του σωλήνα είναι μαλακό και έχει ένα ελαστικό σύνδεσμο για την σύνδεση με την μάσκα.

Προδιαγραφές προϊόντος

Βαλβίδα: Οχι

Χρώμα: Γκρί - Μαυρο

Κατασκευαστής: Cressi

Υλικό: Silicone

Διάλεξε τον τρόπο πληρωμής που σου ταιριάζει

Δωρεάν αποστολή για αγορές άνω των 70€

Παραλαβή από κατάστημά μας

Follow Us

Βοήθεια

Επικοινωνία

Συχνές Ερωτήσεις

Οδηγός αγοράς

Λογαριασμός

Πληροφορίες

Όροι χρήσης

Πολιτική απορρήτου

Πολιτική Coookies

Ασφάλεια συναλλαγών

Θα μας βρείτε

210 2400157

Εθνικής Αντιστάσεως 59,
Αχαρναί 13672,
Ελλάδα

Δευτ & Τετάρτ : 9:00 - 16:00
Τριτ & Πεμ& Παρ: 9:00 - 19:00
Σαβ : 9:00 - 16:00

fishingplanet.gr © 2026 - Created by onepixel

Queries: 115, Total time: 30.407 ms [By time] [By id] [By file]
1 (0.075)

SELECT *
FROM oc_setting
WHERE `key` = 'config_timezone' AND store_id = '0'
/home/fp2026/public_html/fishingplanet/system/framework.php:87
2 (0.076)

SET time_zone = '+03:00'
/home/fp2026/public_html/fishingplanet/system/framework.php:94
3 (0.331)

DELETE
FROM `oc_session`
WHERE `expire` < '2026-05-19 21:36:06'
/home/fp2026/public_html/fishingplanet/system/library/session/db.php:54
4 (0.092)

SELECT *
FROM oc_translation
WHERE store_id = '0' AND language_id = '0' AND (route = 'engb' OR route = '')
/home/fp2026/public_html/fishingplanet/catalog/model/design/translation.php:6
5 (0.227)

SELECT `data`
FROM `oc_session`
WHERE `session_id` = '5fc6bc5ad306f41e62f3c93411' AND `expire` > '2026-05-19 21:36:06'
/home/fp2026/public_html/fishingplanet/system/library/session/db.php:17
6 (0.066)

SELECT *
FROM oc_store
WHERE REPLACE(`url`, 'www.', '') = 'http://test.fishingplanet.gr/'
/home/fp2026/public_html/fishingplanet/catalog/controller/startup/startup.php:20
7 (0.275)

SELECT *
FROM `oc_setting`
WHERE store_id = '0' OR store_id = '0'
ORDER BY store_id ASC
/home/fp2026/public_html/fishingplanet/catalog/controller/startup/startup.php:37
8 (0.092)

SET time_zone = '+03:00'
/home/fp2026/public_html/fishingplanet/catalog/controller/startup/startup.php:52
9 (0.079)

SELECT *
FROM oc_currency
/home/fp2026/public_html/fishingplanet/system/library/cart/currency.php:16
10 (0.074)

SELECT tr1.tax_class_id, tr2.tax_rate_id, tr2.name, tr2.rate, tr2.type, tr1.priority
FROM oc_tax_rule tr1
LEFT JOIN oc_tax_rate tr2 ON (tr1.tax_rate_id = tr2.tax_rate_id)
INNER JOIN oc_tax_rate_to_customer_group tr2cg ON (tr2.tax_rate_id = tr2cg.tax_rate_id)
LEFT JOIN oc_zone_to_geo_zone z2gz ON (tr2.geo_zone_id = z2gz.geo_zone_id)
LEFT JOIN oc_geo_zone gz ON (tr2.geo_zone_id = gz.geo_zone_id)
WHERE tr1.based = 'shipping' AND tr2cg.customer_group_id = '8' AND z2gz.country_id = '84' AND (z2gz.zone_id = '0' OR z2gz.zone_id = '0')
ORDER BY tr1.priority ASC
/home/fp2026/public_html/fishingplanet/system/library/cart/tax.php:18
11 (0.057)

SELECT tr1.tax_class_id, tr2.tax_rate_id, tr2.name, tr2.rate, tr2.type, tr1.priority
FROM oc_tax_rule tr1
LEFT JOIN oc_tax_rate tr2 ON (tr1.tax_rate_id = tr2.tax_rate_id)
INNER JOIN oc_tax_rate_to_customer_group tr2cg ON (tr2.tax_rate_id = tr2cg.tax_rate_id)
LEFT JOIN oc_zone_to_geo_zone z2gz ON (tr2.geo_zone_id = z2gz.geo_zone_id)
LEFT JOIN oc_geo_zone gz ON (tr2.geo_zone_id = gz.geo_zone_id)
WHERE tr1.based = 'store' AND tr2cg.customer_group_id = '8' AND z2gz.country_id = '84' AND (z2gz.zone_id = '0' OR z2gz.zone_id = '0')
ORDER BY tr1.priority ASC
/home/fp2026/public_html/fishingplanet/system/library/cart/tax.php:46
12 (0.059)

SELECT *
FROM oc_weight_class wc
LEFT JOIN oc_weight_class_description wcd ON (wc.weight_class_id = wcd.weight_class_id)
WHERE wcd.language_id = '2'
/home/fp2026/public_html/fishingplanet/system/library/cart/weight.php:12
13 (0.057)

SELECT *
FROM oc_length_class mc
LEFT JOIN oc_length_class_description mcd ON (mc.length_class_id = mcd.length_class_id)
WHERE mcd.language_id = '2'
/home/fp2026/public_html/fishingplanet/system/library/cart/length.php:12
14 (0.171)

DELETE
FROM oc_cart
WHERE (api_id > '0' OR customer_id = '0') AND date_added < DATE_SUB(NOW(), INTERVAL 1 HOUR)
/home/fp2026/public_html/fishingplanet/system/library/cart/cart.php:21
15 (0.089)

SELECT *
FROM `oc_event`
WHERE `trigger` LIKE 'catalog/%' AND status = '1'
ORDER BY `sort_order` ASC
/home/fp2026/public_html/fishingplanet/catalog/model/setting/event.php:4
16 (0.071)

SELECT *
FROM oc_translation
WHERE store_id = '0' AND language_id = '2' AND (route = 'product/product' OR route = 'el-gr')
/home/fp2026/public_html/fishingplanet/catalog/model/design/translation.php:6
17 (1.112)

SELECT DISTINCT *, pd.name AS name, p.image, m.name AS manufacturer, (SELECT price
FROM oc_product_discount pd2
WHERE pd2.product_id = p.product_id AND pd2.customer_group_id = '8' 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 = '8' 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, (SELECT points
FROM oc_product_reward pr
WHERE pr.product_id = p.product_id AND pr.customer_group_id = '8') AS reward, (SELECT ss.name
FROM oc_stock_status ss
WHERE ss.stock_status_id = p.stock_status_id AND ss.language_id = '2') AS stock_status, (SELECT wcd.unit
FROM oc_weight_class_description wcd
WHERE p.weight_class_id = wcd.weight_class_id AND wcd.language_id = '2') AS weight_class, (SELECT lcd.unit
FROM oc_length_class_description lcd
WHERE p.length_class_id = lcd.length_class_id AND lcd.language_id = '2') AS length_class, (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 COUNT(*) AS total
FROM oc_review r2
WHERE r2.product_id = p.product_id AND r2.status = '1' GROUP BY r2.product_id) AS reviews, p.sort_order
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)
LEFT JOIN oc_manufacturer m ON (p.manufacturer_id = m.manufacturer_id)
WHERE p.product_id = '868' AND pd.language_id = '2' AND p.status = '1' AND p.date_available <= NOW() AND p2s.store_id = '0'
/home/fp2026/public_html/fishingplanet/system/storage/modification/catalog/model/catalog/product.php:22
18 (0.089)

SELECT *
FROM oc_product_newtabcontent
WHERE product_id = '868' AND language_id = '2'
/home/fp2026/public_html/fishingplanet/system/storage/modification/catalog/model/catalog/product.php:26
19 (0.101)

SELECT *
FROM oc_extension
WHERE `type` = 'module' AND `code` = 'recently_viewed'
/home/fp2026/public_html/fishingplanet/catalog/model/extension/module/recently_viewed.php:23
20 (0.144)

SELECT *
FROM oc_product_image
WHERE product_id = '868'
ORDER BY sort_order ASC
/home/fp2026/public_html/fishingplanet/system/storage/modification/catalog/model/catalog/product.php:527
21 (0.087)

SELECT *
FROM oc_manufacturer m
LEFT JOIN oc_manufacturer_to_store m2s ON (m.manufacturer_id = m2s.manufacturer_id)
WHERE m.manufacturer_id = '18' AND m2s.store_id = '0'
/home/fp2026/public_html/fishingplanet/system/storage/modification/catalog/model/catalog/manufacturer.php:4
22 (0.090)

SELECT *
FROM oc_product_tech po
LEFT JOIN `oc_tech` o ON (po.tech_id = o.tech_id)
LEFT JOIN oc_tech_description od ON (o.tech_id = od.tech_id)
WHERE po.product_id = '868' AND od.language_id = '2'
ORDER BY o.sort_order
/home/fp2026/public_html/fishingplanet/catalog/model/tool/onepixel.php:255
23 (0.073)

SELECT category_id
FROM oc_product_to_category
WHERE product_id = '868'
/home/fp2026/public_html/fishingplanet/catalog/model/tool/onepixel.php:45
24 (0.323)

SELECT *
FROM oc_product_discount
WHERE product_id = '868' AND customer_group_id = '8' AND quantity > 1 AND ((date_start = '0000-00-00' OR date_start < NOW()) AND (date_end = '0000-00-00' OR date_end > NOW()))
ORDER BY quantity ASC, priority ASC, price ASC
/home/fp2026/public_html/fishingplanet/system/storage/modification/catalog/model/catalog/product.php:507
25 (0.071)

SELECT *
FROM oc_product_option po
LEFT JOIN `oc_option` o ON (po.option_id = o.option_id)
LEFT JOIN oc_option_description od ON (o.option_id = od.option_id)
WHERE po.product_id = '868' AND od.language_id = '2'
ORDER BY o.sort_order
/home/fp2026/public_html/fishingplanet/system/storage/modification/catalog/model/catalog/product.php:452
26 (0.069)

SELECT *
FROM oc_translation
WHERE store_id = '0' AND language_id = '2' AND (route = 'extension/captcha/recaptcha' OR route = 'el-gr')
/home/fp2026/public_html/fishingplanet/catalog/model/design/translation.php:6
27 (0.092)

SELECT *
FROM oc_theme
WHERE store_id = '0' AND theme = 'tackle' AND route = 'extension/captcha/recaptcha'
/home/fp2026/public_html/fishingplanet/catalog/model/design/theme.php:4
28 (0.114)

SELECT ag.attribute_group_id, agd.name
FROM oc_product_attribute pa
LEFT JOIN oc_attribute a ON (pa.attribute_id = a.attribute_id)
LEFT JOIN oc_attribute_group ag ON (a.attribute_group_id = ag.attribute_group_id)
LEFT JOIN oc_attribute_group_description agd ON (ag.attribute_group_id = agd.attribute_group_id)
WHERE pa.product_id = '868' AND agd.language_id = '2' GROUP BY ag.attribute_group_id
ORDER BY ag.sort_order, agd.name
/home/fp2026/public_html/fishingplanet/system/storage/modification/catalog/model/catalog/product.php:424
29 (0.076)

SELECT a.attribute_id, ad.name, pa.text
FROM oc_product_attribute pa
LEFT JOIN oc_attribute a ON (pa.attribute_id = a.attribute_id)
LEFT JOIN oc_attribute_description ad ON (a.attribute_id = ad.attribute_id)
WHERE pa.product_id = '868' AND a.attribute_group_id = '20' AND ad.language_id = '2' AND pa.language_id = '2'
ORDER BY a.sort_order, ad.name
/home/fp2026/public_html/fishingplanet/system/storage/modification/catalog/model/catalog/product.php:429
30 (0.060)

SELECT ag.attribute_group_id, agd.name
FROM oc_product_attribute pa
LEFT JOIN oc_attribute a ON (pa.attribute_id = a.attribute_id)
LEFT JOIN oc_attribute_group ag ON (a.attribute_group_id = ag.attribute_group_id)
LEFT JOIN oc_attribute_group_description agd ON (ag.attribute_group_id = agd.attribute_group_id)
WHERE pa.product_id = '868' AND agd.language_id = '2' GROUP BY ag.attribute_group_id
ORDER BY ag.sort_order, agd.name
/home/fp2026/public_html/fishingplanet/catalog/model/tool/onepixel.php:308
31 (0.055)

SELECT a.attribute_id, ad.name, pa.text
FROM oc_product_attribute pa
LEFT JOIN oc_attribute a ON (pa.attribute_id = a.attribute_id)
LEFT JOIN oc_attribute_description ad ON (a.attribute_id = ad.attribute_id)
WHERE pa.product_id = '868' AND a.attribute_group_id = '20' AND a.featured = '1' AND ad.language_id = '2' AND pa.language_id = '2'
ORDER BY a.sort_order, ad.name
/home/fp2026/public_html/fishingplanet/catalog/model/tool/onepixel.php:313
32 (0.486)

SELECT *
FROM oc_product_related pr
LEFT JOIN oc_product p ON (pr.related_id = p.product_id)
LEFT JOIN oc_product_to_store p2s ON (p.product_id = p2s.product_id)
WHERE pr.product_id = '868' AND p.status = '1' AND p.date_available <= NOW() AND p2s.store_id = '0'
/home/fp2026/public_html/fishingplanet/system/storage/modification/catalog/model/catalog/product.php:549
33 (0.907)

SELECT DISTINCT *, pd.name AS name, p.image, m.name AS manufacturer, (SELECT price
FROM oc_product_discount pd2
WHERE pd2.product_id = p.product_id AND pd2.customer_group_id = '8' 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 = '8' 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, (SELECT points
FROM oc_product_reward pr
WHERE pr.product_id = p.product_id AND pr.customer_group_id = '8') AS reward, (SELECT ss.name
FROM oc_stock_status ss
WHERE ss.stock_status_id = p.stock_status_id AND ss.language_id = '2') AS stock_status, (SELECT wcd.unit
FROM oc_weight_class_description wcd
WHERE p.weight_class_id = wcd.weight_class_id AND wcd.language_id = '2') AS weight_class, (SELECT lcd.unit
FROM oc_length_class_description lcd
WHERE p.length_class_id = lcd.length_class_id AND lcd.language_id = '2') AS length_class, (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 COUNT(*) AS total
FROM oc_review r2
WHERE r2.product_id = p.product_id AND r2.status = '1' GROUP BY r2.product_id) AS reviews, p.sort_order
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)
LEFT JOIN oc_manufacturer m ON (p.manufacturer_id = m.manufacturer_id)
WHERE p.product_id = '3154' AND pd.language_id = '2' AND p.status = '1' AND p.date_available <= NOW() AND p2s.store_id = '0'
/home/fp2026/public_html/fishingplanet/system/storage/modification/catalog/model/catalog/product.php:22
34 (0.099)

SELECT *
FROM oc_product_newtabcontent
WHERE product_id = '3154' AND language_id = '2'
/home/fp2026/public_html/fishingplanet/system/storage/modification/catalog/model/catalog/product.php:26
35 (0.082)

SELECT rd.*
FROM oc_product_recurring pr JOIN oc_recurring_description rd ON (rd.language_id = 2 AND rd.recurring_id = pr.recurring_id) JOIN oc_recurring r ON r.recurring_id = rd.recurring_id
WHERE pr.product_id = 868 AND status = '1' AND pr.customer_group_id = '8'
ORDER BY sort_order ASC
/home/fp2026/public_html/fishingplanet/system/storage/modification/catalog/model/catalog/product.php:804
36 (15.354)

UPDATE oc_product SET viewed = (viewed + 1)
WHERE product_id = '868'
/home/fp2026/public_html/fishingplanet/system/storage/modification/catalog/model/catalog/product.php:4
37 (0.126)

SELECT *
FROM oc_product_to_layout
WHERE product_id = '868' AND store_id = '0'
/home/fp2026/public_html/fishingplanet/system/storage/modification/catalog/model/catalog/product.php:573
38 (0.079)

SELECT *
FROM oc_layout_route
WHERE 'product/product' LIKE route AND store_id = '0'
ORDER BY route DESC LIMIT 1
/home/fp2026/public_html/fishingplanet/catalog/model/design/layout.php:4
39 (0.074)

SELECT *
FROM oc_layout_module
WHERE layout_id = '2' AND position = 'column_left'
ORDER BY sort_order
/home/fp2026/public_html/fishingplanet/catalog/model/design/layout.php:14
40 (0.067)

SELECT *
FROM oc_theme
WHERE store_id = '0' AND theme = 'tackle' AND route = 'common/column_left'
/home/fp2026/public_html/fishingplanet/catalog/model/design/theme.php:4
41 (0.086)

SELECT *
FROM oc_product_to_layout
WHERE product_id = '868' AND store_id = '0'
/home/fp2026/public_html/fishingplanet/system/storage/modification/catalog/model/catalog/product.php:573
42 (0.056)

SELECT *
FROM oc_layout_route
WHERE 'product/product' LIKE route AND store_id = '0'
ORDER BY route DESC LIMIT 1
/home/fp2026/public_html/fishingplanet/catalog/model/design/layout.php:4
43 (0.052)

SELECT *
FROM oc_layout_module
WHERE layout_id = '2' AND position = 'column_right'
ORDER BY sort_order
/home/fp2026/public_html/fishingplanet/catalog/model/design/layout.php:14
44 (0.074)

SELECT *
FROM oc_theme
WHERE store_id = '0' AND theme = 'tackle' AND route = 'common/column_right'
/home/fp2026/public_html/fishingplanet/catalog/model/design/theme.php:4
45 (0.079)

SELECT *
FROM oc_product_to_layout
WHERE product_id = '868' AND store_id = '0'
/home/fp2026/public_html/fishingplanet/system/storage/modification/catalog/model/catalog/product.php:573
46 (0.056)

SELECT *
FROM oc_layout_route
WHERE 'product/product' LIKE route AND store_id = '0'
ORDER BY route DESC LIMIT 1
/home/fp2026/public_html/fishingplanet/catalog/model/design/layout.php:4
47 (0.052)

SELECT *
FROM oc_layout_module
WHERE layout_id = '2' AND position = 'content_top'
ORDER BY sort_order
/home/fp2026/public_html/fishingplanet/catalog/model/design/layout.php:14
48 (0.055)

SELECT *
FROM oc_theme
WHERE store_id = '0' AND theme = 'tackle' AND route = 'common/content_top'
/home/fp2026/public_html/fishingplanet/catalog/model/design/theme.php:4
49 (0.081)

SELECT *
FROM oc_product_to_layout
WHERE product_id = '868' AND store_id = '0'
/home/fp2026/public_html/fishingplanet/system/storage/modification/catalog/model/catalog/product.php:573
50 (0.057)

SELECT *
FROM oc_layout_route
WHERE 'product/product' LIKE route AND store_id = '0'
ORDER BY route DESC LIMIT 1
/home/fp2026/public_html/fishingplanet/catalog/model/design/layout.php:4
51 (0.052)

SELECT *
FROM oc_layout_module
WHERE layout_id = '2' AND position = 'content_bottom'
ORDER BY sort_order
/home/fp2026/public_html/fishingplanet/catalog/model/design/layout.php:14
52 (0.064)

SELECT *
FROM oc_theme
WHERE store_id = '0' AND theme = 'tackle' AND route = 'common/content_bottom'
/home/fp2026/public_html/fishingplanet/catalog/model/design/theme.php:4
53 (0.109)

SELECT *
FROM oc_translation
WHERE store_id = '0' AND language_id = '2' AND (route = 'common/footer' OR route = 'el-gr')
/home/fp2026/public_html/fishingplanet/catalog/model/design/translation.php:6
54 (0.097)

SELECT *
FROM oc_translation
WHERE store_id = '0' AND language_id = '2' AND (route = 'extension/module/gconsent' OR route = 'el-gr')
/home/fp2026/public_html/fishingplanet/catalog/model/design/translation.php:6
55 (0.257)

SELECT *
FROM oc_information i
LEFT JOIN oc_information_description id ON (i.information_id = id.information_id)
LEFT JOIN oc_information_to_store i2s ON (i.information_id = i2s.information_id)
WHERE id.language_id = '2' AND i2s.store_id = '0' AND i.status = '1'
ORDER BY i.sort_order, LCASE(id.title) ASC
/home/fp2026/public_html/fishingplanet/catalog/model/catalog/information.php:10
56 (0.096)

SELECT *
FROM oc_theme
WHERE store_id = '0' AND theme = 'tackle' AND route = 'common/footer'
/home/fp2026/public_html/fishingplanet/catalog/model/design/theme.php:4
57 (0.097)

SELECT *
FROM oc_extension
WHERE `type` = 'analytics'
/home/fp2026/public_html/fishingplanet/system/storage/modification/catalog/model/setting/extension.php:4
58 (0.101)

SELECT *
FROM oc_translation
WHERE store_id = '0' AND language_id = '2' AND (route = 'common/header' OR route = 'el-gr')
/home/fp2026/public_html/fishingplanet/catalog/model/design/translation.php:6
59 (1.175)

SELECT DISTINCT *, pd.name AS name, p.image, m.name AS manufacturer, (SELECT price
FROM oc_product_discount pd2
WHERE pd2.product_id = p.product_id AND pd2.customer_group_id = '8' 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 = '8' 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, (SELECT points
FROM oc_product_reward pr
WHERE pr.product_id = p.product_id AND pr.customer_group_id = '8') AS reward, (SELECT ss.name
FROM oc_stock_status ss
WHERE ss.stock_status_id = p.stock_status_id AND ss.language_id = '2') AS stock_status, (SELECT wcd.unit
FROM oc_weight_class_description wcd
WHERE p.weight_class_id = wcd.weight_class_id AND wcd.language_id = '2') AS weight_class, (SELECT lcd.unit
FROM oc_length_class_description lcd
WHERE p.length_class_id = lcd.length_class_id AND lcd.language_id = '2') AS length_class, (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 COUNT(*) AS total
FROM oc_review r2
WHERE r2.product_id = p.product_id AND r2.status = '1' GROUP BY r2.product_id) AS reviews, p.sort_order
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)
LEFT JOIN oc_manufacturer m ON (p.manufacturer_id = m.manufacturer_id)
WHERE p.product_id = '868' AND pd.language_id = '2' AND p.status = '1' AND p.date_available <= NOW() AND p2s.store_id = '0'
/home/fp2026/public_html/fishingplanet/system/storage/modification/catalog/model/catalog/product.php:22
60 (0.079)

SELECT *
FROM oc_product_newtabcontent
WHERE product_id = '868' AND language_id = '2'
/home/fp2026/public_html/fishingplanet/system/storage/modification/catalog/model/catalog/product.php:26
61 (0.103)

SELECT *
FROM oc_theme
WHERE store_id = '0' AND theme = 'tackle' AND route = 'common/social_meta'
/home/fp2026/public_html/fishingplanet/catalog/model/design/theme.php:4
62 (0.157)

SELECT *
FROM oc_translation
WHERE store_id = '0' AND language_id = '2' AND (route = 'common/menu' OR route = 'el-gr')
/home/fp2026/public_html/fishingplanet/catalog/model/design/translation.php:6
63 (0.169)

SELECT *
FROM oc_category c
LEFT JOIN oc_category_description cd ON (c.category_id = cd.category_id)
LEFT JOIN oc_category_to_store c2s ON (c.category_id = c2s.category_id)
WHERE c.parent_id = '0' AND cd.language_id = '2' AND c2s.store_id = '0' AND c.status = '1'
ORDER BY c.sort_order, LCASE(cd.name)
/home/fp2026/public_html/fishingplanet/catalog/model/catalog/category.php:10
64 (0.209)

SELECT *
FROM oc_category c
LEFT JOIN oc_category_description cd ON (c.category_id = cd.category_id)
LEFT JOIN oc_category_to_store c2s ON (c.category_id = c2s.category_id)
WHERE c.parent_id = '188' AND cd.language_id = '2' AND c2s.store_id = '0' AND c.status = '1'
ORDER BY c.sort_order, LCASE(cd.name)
/home/fp2026/public_html/fishingplanet/catalog/model/catalog/category.php:10
65 (0.096)

SELECT *
FROM oc_category c
LEFT JOIN oc_category_description cd ON (c.category_id = cd.category_id)
LEFT JOIN oc_category_to_store c2s ON (c.category_id = c2s.category_id)
WHERE c.parent_id = '154' AND cd.language_id = '2' AND c2s.store_id = '0' AND c.status = '1'
ORDER BY c.sort_order, LCASE(cd.name)
/home/fp2026/public_html/fishingplanet/catalog/model/catalog/category.php:10
66 (0.192)

SELECT *
FROM oc_category c
LEFT JOIN oc_category_description cd ON (c.category_id = cd.category_id)
LEFT JOIN oc_category_to_store c2s ON (c.category_id = c2s.category_id)
WHERE c.parent_id = '70' AND cd.language_id = '2' AND c2s.store_id = '0' AND c.status = '1'
ORDER BY c.sort_order, LCASE(cd.name)
/home/fp2026/public_html/fishingplanet/catalog/model/catalog/category.php:10
67 (0.090)

SELECT *
FROM oc_category c
LEFT JOIN oc_category_description cd ON (c.category_id = cd.category_id)
LEFT JOIN oc_category_to_store c2s ON (c.category_id = c2s.category_id)
WHERE c.parent_id = '110' AND cd.language_id = '2' AND c2s.store_id = '0' AND c.status = '1'
ORDER BY c.sort_order, LCASE(cd.name)
/home/fp2026/public_html/fishingplanet/catalog/model/catalog/category.php:10
68 (0.084)

SELECT *
FROM oc_category c
LEFT JOIN oc_category_description cd ON (c.category_id = cd.category_id)
LEFT JOIN oc_category_to_store c2s ON (c.category_id = c2s.category_id)
WHERE c.parent_id = '91' AND cd.language_id = '2' AND c2s.store_id = '0' AND c.status = '1'
ORDER BY c.sort_order, LCASE(cd.name)
/home/fp2026/public_html/fishingplanet/catalog/model/catalog/category.php:10
69 (0.079)

SELECT *
FROM oc_category c
LEFT JOIN oc_category_description cd ON (c.category_id = cd.category_id)
LEFT JOIN oc_category_to_store c2s ON (c.category_id = c2s.category_id)
WHERE c.parent_id = '128' AND cd.language_id = '2' AND c2s.store_id = '0' AND c.status = '1'
ORDER BY c.sort_order, LCASE(cd.name)
/home/fp2026/public_html/fishingplanet/catalog/model/catalog/category.php:10
70 (0.074)

SELECT *
FROM oc_category c
LEFT JOIN oc_category_description cd ON (c.category_id = cd.category_id)
LEFT JOIN oc_category_to_store c2s ON (c.category_id = c2s.category_id)
WHERE c.parent_id = '288' AND cd.language_id = '2' AND c2s.store_id = '0' AND c.status = '1'
ORDER BY c.sort_order, LCASE(cd.name)
/home/fp2026/public_html/fishingplanet/catalog/model/catalog/category.php:10
71 (0.075)

SELECT *
FROM oc_category c
LEFT JOIN oc_category_description cd ON (c.category_id = cd.category_id)
LEFT JOIN oc_category_to_store c2s ON (c.category_id = c2s.category_id)
WHERE c.parent_id = '531' AND cd.language_id = '2' AND c2s.store_id = '0' AND c.status = '1'
ORDER BY c.sort_order, LCASE(cd.name)
/home/fp2026/public_html/fishingplanet/catalog/model/catalog/category.php:10
72 (0.120)

SELECT *
FROM oc_category c
LEFT JOIN oc_category_description cd ON (c.category_id = cd.category_id)
LEFT JOIN oc_category_to_store c2s ON (c.category_id = c2s.category_id)
WHERE c.parent_id = '400' AND cd.language_id = '2' AND c2s.store_id = '0' AND c.status = '1'
ORDER BY c.sort_order, LCASE(cd.name)
/home/fp2026/public_html/fishingplanet/catalog/model/catalog/category.php:10
73 (0.141)

SELECT *
FROM oc_category c
LEFT JOIN oc_category_description cd ON (c.category_id = cd.category_id)
LEFT JOIN oc_category_to_store c2s ON (c.category_id = c2s.category_id)
WHERE c.parent_id = '86' AND cd.language_id = '2' AND c2s.store_id = '0' AND c.status = '1'
ORDER BY c.sort_order, LCASE(cd.name)
/home/fp2026/public_html/fishingplanet/catalog/model/catalog/category.php:10
74 (0.084)

SELECT *
FROM oc_category c
LEFT JOIN oc_category_description cd ON (c.category_id = cd.category_id)
LEFT JOIN oc_category_to_store c2s ON (c.category_id = c2s.category_id)
WHERE c.parent_id = '87' AND cd.language_id = '2' AND c2s.store_id = '0' AND c.status = '1'
ORDER BY c.sort_order, LCASE(cd.name)
/home/fp2026/public_html/fishingplanet/catalog/model/catalog/category.php:10
75 (0.081)

SELECT *
FROM oc_category c
LEFT JOIN oc_category_description cd ON (c.category_id = cd.category_id)
LEFT JOIN oc_category_to_store c2s ON (c.category_id = c2s.category_id)
WHERE c.parent_id = '113' AND cd.language_id = '2' AND c2s.store_id = '0' AND c.status = '1'
ORDER BY c.sort_order, LCASE(cd.name)
/home/fp2026/public_html/fishingplanet/catalog/model/catalog/category.php:10
76 (0.071)

SELECT *
FROM oc_category c
LEFT JOIN oc_category_description cd ON (c.category_id = cd.category_id)
LEFT JOIN oc_category_to_store c2s ON (c.category_id = c2s.category_id)
WHERE c.parent_id = '121' AND cd.language_id = '2' AND c2s.store_id = '0' AND c.status = '1'
ORDER BY c.sort_order, LCASE(cd.name)
/home/fp2026/public_html/fishingplanet/catalog/model/catalog/category.php:10
77 (0.091)

SELECT *
FROM oc_category c
LEFT JOIN oc_category_description cd ON (c.category_id = cd.category_id)
LEFT JOIN oc_category_to_store c2s ON (c.category_id = c2s.category_id)
WHERE c.parent_id = '557' AND cd.language_id = '2' AND c2s.store_id = '0' AND c.status = '1'
ORDER BY c.sort_order, LCASE(cd.name)
/home/fp2026/public_html/fishingplanet/catalog/model/catalog/category.php:10
78 (0.097)

SELECT *
FROM oc_category c
LEFT JOIN oc_category_description cd ON (c.category_id = cd.category_id)
LEFT JOIN oc_category_to_store c2s ON (c.category_id = c2s.category_id)
WHERE c.parent_id = '206' AND cd.language_id = '2' AND c2s.store_id = '0' AND c.status = '1'
ORDER BY c.sort_order, LCASE(cd.name)
/home/fp2026/public_html/fishingplanet/catalog/model/catalog/category.php:10
79 (0.075)

SELECT *
FROM oc_category c
LEFT JOIN oc_category_description cd ON (c.category_id = cd.category_id)
LEFT JOIN oc_category_to_store c2s ON (c.category_id = c2s.category_id)
WHERE c.parent_id = '350' AND cd.language_id = '2' AND c2s.store_id = '0' AND c.status = '1'
ORDER BY c.sort_order, LCASE(cd.name)
/home/fp2026/public_html/fishingplanet/catalog/model/catalog/category.php:10
80 (0.090)

SELECT *
FROM oc_category c
LEFT JOIN oc_category_description cd ON (c.category_id = cd.category_id)
LEFT JOIN oc_category_to_store c2s ON (c.category_id = c2s.category_id)
WHERE c.parent_id = '325' AND cd.language_id = '2' AND c2s.store_id = '0' AND c.status = '1'
ORDER BY c.sort_order, LCASE(cd.name)
/home/fp2026/public_html/fishingplanet/catalog/model/catalog/category.php:10
81 (0.091)

SELECT *
FROM oc_category c
LEFT JOIN oc_category_description cd ON (c.category_id = cd.category_id)
LEFT JOIN oc_category_to_store c2s ON (c.category_id = c2s.category_id)
WHERE c.parent_id = '633' AND cd.language_id = '2' AND c2s.store_id = '0' AND c.status = '1'
ORDER BY c.sort_order, LCASE(cd.name)
/home/fp2026/public_html/fishingplanet/catalog/model/catalog/category.php:10
82 (0.073)

SELECT *
FROM oc_category c
LEFT JOIN oc_category_description cd ON (c.category_id = cd.category_id)
LEFT JOIN oc_category_to_store c2s ON (c.category_id = c2s.category_id)
WHERE c.parent_id = '641' AND cd.language_id = '2' AND c2s.store_id = '0' AND c.status = '1'
ORDER BY c.sort_order, LCASE(cd.name)
/home/fp2026/public_html/fishingplanet/catalog/model/catalog/category.php:10
83 (0.081)

SELECT *
FROM oc_category c
LEFT JOIN oc_category_description cd ON (c.category_id = cd.category_id)
LEFT JOIN oc_category_to_store c2s ON (c.category_id = c2s.category_id)
WHERE c.parent_id = '671' AND cd.language_id = '2' AND c2s.store_id = '0' AND c.status = '1'
ORDER BY c.sort_order, LCASE(cd.name)
/home/fp2026/public_html/fishingplanet/catalog/model/catalog/category.php:10
84 (0.081)

SELECT *
FROM oc_category c
LEFT JOIN oc_category_description cd ON (c.category_id = cd.category_id)
LEFT JOIN oc_category_to_store c2s ON (c.category_id = c2s.category_id)
WHERE c.parent_id = '674' AND cd.language_id = '2' AND c2s.store_id = '0' AND c.status = '1'
ORDER BY c.sort_order, LCASE(cd.name)
/home/fp2026/public_html/fishingplanet/catalog/model/catalog/category.php:10
85 (0.088)

SELECT *
FROM oc_theme
WHERE store_id = '0' AND theme = 'tackle' AND route = 'common/menumega'
/home/fp2026/public_html/fishingplanet/catalog/model/design/theme.php:4
86 (0.174)

SELECT *
FROM oc_cart
WHERE api_id = '0' AND customer_id = '0' AND session_id = '5fc6bc5ad306f41e62f3c93411'
/home/fp2026/public_html/fishingplanet/system/library/cart/cart.php:42
87 (0.078)

SELECT *
FROM oc_theme
WHERE store_id = '0' AND theme = 'tackle' AND route = 'common/cart_items'
/home/fp2026/public_html/fishingplanet/catalog/model/design/theme.php:4
88 (0.132)

SELECT *
FROM oc_translation
WHERE store_id = '0' AND language_id = '2' AND (route = 'common/language' OR route = 'el-gr')
/home/fp2026/public_html/fishingplanet/catalog/model/design/translation.php:6
89 (0.240)

SELECT *
FROM oc_theme
WHERE store_id = '0' AND theme = 'tackle' AND route = 'common/language'
/home/fp2026/public_html/fishingplanet/catalog/model/design/theme.php:4
90 (0.109)

SELECT *
FROM oc_translation
WHERE store_id = '0' AND language_id = '2' AND (route = 'common/currency' OR route = 'el-gr')
/home/fp2026/public_html/fishingplanet/catalog/model/design/translation.php:6
91 (0.077)

SELECT *
FROM oc_theme
WHERE store_id = '0' AND theme = 'tackle' AND route = 'common/currency'
/home/fp2026/public_html/fishingplanet/catalog/model/design/theme.php:4
92 (0.173)

SELECT *
FROM oc_translation
WHERE store_id = '0' AND language_id = '2' AND (route = 'common/search' OR route = 'el-gr')
/home/fp2026/public_html/fishingplanet/catalog/model/design/translation.php:6
93 (0.098)

SELECT *
FROM oc_theme
WHERE store_id = '0' AND theme = 'tackle' AND route = 'common/search'
/home/fp2026/public_html/fishingplanet/catalog/model/design/theme.php:4
94 (0.095)

SELECT *
FROM oc_translation
WHERE store_id = '0' AND language_id = '2' AND (route = 'common/cart' OR route = 'el-gr')
/home/fp2026/public_html/fishingplanet/catalog/model/design/translation.php:6
95 (0.079)

SELECT *
FROM oc_cart
WHERE api_id = '0' AND customer_id = '0' AND session_id = '5fc6bc5ad306f41e62f3c93411'
/home/fp2026/public_html/fishingplanet/system/library/cart/cart.php:42
96 (0.072)

SELECT *
FROM oc_extension
WHERE `type` = 'total'
/home/fp2026/public_html/fishingplanet/system/storage/modification/catalog/model/setting/extension.php:4
97 (0.083)

SELECT *
FROM oc_translation
WHERE store_id = '0' AND language_id = '2' AND (route = 'extension/total/sub_total' OR route = 'el-gr')
/home/fp2026/public_html/fishingplanet/catalog/model/design/translation.php:6
98 (0.111)

SELECT *
FROM oc_cart
WHERE api_id = '0' AND customer_id = '0' AND session_id = '5fc6bc5ad306f41e62f3c93411'
/home/fp2026/public_html/fishingplanet/system/library/cart/cart.php:42
99 (0.081)

SELECT *
FROM oc_cart
WHERE api_id = '0' AND customer_id = '0' AND session_id = '5fc6bc5ad306f41e62f3c93411'
/home/fp2026/public_html/fishingplanet/system/library/cart/cart.php:42
100 (0.076)

SELECT *
FROM oc_translation
WHERE store_id = '0' AND language_id = '2' AND (route = 'extension/total/total' OR route = 'el-gr')
/home/fp2026/public_html/fishingplanet/catalog/model/design/translation.php:6
101 (0.061)

SELECT *
FROM oc_cart
WHERE api_id = '0' AND customer_id = '0' AND session_id = '5fc6bc5ad306f41e62f3c93411'
/home/fp2026/public_html/fishingplanet/system/library/cart/cart.php:42
102 (0.063)

SELECT *
FROM oc_cart
WHERE api_id = '0' AND customer_id = '0' AND session_id = '5fc6bc5ad306f41e62f3c93411'
/home/fp2026/public_html/fishingplanet/system/library/cart/cart.php:42
103 (0.076)

SELECT *
FROM oc_theme
WHERE store_id = '0' AND theme = 'tackle' AND route = 'common/cart'
/home/fp2026/public_html/fishingplanet/catalog/model/design/theme.php:4
104 (0.089)

SELECT *
FROM oc_translation
WHERE store_id = '0' AND language_id = '2' AND (route = 'common/menu' OR route = 'el-gr')
/home/fp2026/public_html/fishingplanet/catalog/model/design/translation.php:6
105 (0.114)

SELECT *
FROM oc_category c
LEFT JOIN oc_category_description cd ON (c.category_id = cd.category_id)
LEFT JOIN oc_category_to_store c2s ON (c.category_id = c2s.category_id)
WHERE c.parent_id = '0' AND cd.language_id = '2' AND c2s.store_id = '0' AND c.status = '1'
ORDER BY c.sort_order, LCASE(cd.name)
/home/fp2026/public_html/fishingplanet/catalog/model/catalog/category.php:10
106 (0.154)

SELECT *
FROM oc_category c
LEFT JOIN oc_category_description cd ON (c.category_id = cd.category_id)
LEFT JOIN oc_category_to_store c2s ON (c.category_id = c2s.category_id)
WHERE c.parent_id = '188' AND cd.language_id = '2' AND c2s.store_id = '0' AND c.status = '1'
ORDER BY c.sort_order, LCASE(cd.name)
/home/fp2026/public_html/fishingplanet/catalog/model/catalog/category.php:10
107 (0.189)

SELECT *
FROM oc_category c
LEFT JOIN oc_category_description cd ON (c.category_id = cd.category_id)
LEFT JOIN oc_category_to_store c2s ON (c.category_id = c2s.category_id)
WHERE c.parent_id = '400' AND cd.language_id = '2' AND c2s.store_id = '0' AND c.status = '1'
ORDER BY c.sort_order, LCASE(cd.name)
/home/fp2026/public_html/fishingplanet/catalog/model/catalog/category.php:10
108 (0.152)

SELECT *
FROM oc_category c
LEFT JOIN oc_category_description cd ON (c.category_id = cd.category_id)
LEFT JOIN oc_category_to_store c2s ON (c.category_id = c2s.category_id)
WHERE c.parent_id = '86' AND cd.language_id = '2' AND c2s.store_id = '0' AND c.status = '1'
ORDER BY c.sort_order, LCASE(cd.name)
/home/fp2026/public_html/fishingplanet/catalog/model/catalog/category.php:10
109 (0.091)

SELECT *
FROM oc_category c
LEFT JOIN oc_category_description cd ON (c.category_id = cd.category_id)
LEFT JOIN oc_category_to_store c2s ON (c.category_id = c2s.category_id)
WHERE c.parent_id = '557' AND cd.language_id = '2' AND c2s.store_id = '0' AND c.status = '1'
ORDER BY c.sort_order, LCASE(cd.name)
/home/fp2026/public_html/fishingplanet/catalog/model/catalog/category.php:10
110 (0.088)

SELECT *
FROM oc_category c
LEFT JOIN oc_category_description cd ON (c.category_id = cd.category_id)
LEFT JOIN oc_category_to_store c2s ON (c.category_id = c2s.category_id)
WHERE c.parent_id = '206' AND cd.language_id = '2' AND c2s.store_id = '0' AND c.status = '1'
ORDER BY c.sort_order, LCASE(cd.name)
/home/fp2026/public_html/fishingplanet/catalog/model/catalog/category.php:10
111 (0.128)

SELECT *
FROM oc_category c
LEFT JOIN oc_category_description cd ON (c.category_id = cd.category_id)
LEFT JOIN oc_category_to_store c2s ON (c.category_id = c2s.category_id)
WHERE c.parent_id = '633' AND cd.language_id = '2' AND c2s.store_id = '0' AND c.status = '1'
ORDER BY c.sort_order, LCASE(cd.name)
/home/fp2026/public_html/fishingplanet/catalog/model/catalog/category.php:10
112 (0.082)

SELECT *
FROM oc_category c
LEFT JOIN oc_category_description cd ON (c.category_id = cd.category_id)
LEFT JOIN oc_category_to_store c2s ON (c.category_id = c2s.category_id)
WHERE c.parent_id = '671' AND cd.language_id = '2' AND c2s.store_id = '0' AND c.status = '1'
ORDER BY c.sort_order, LCASE(cd.name)
/home/fp2026/public_html/fishingplanet/catalog/model/catalog/category.php:10
113 (0.063)

SELECT *
FROM oc_theme
WHERE store_id = '0' AND theme = 'tackle' AND route = 'common/menu'
/home/fp2026/public_html/fishingplanet/catalog/model/design/theme.php:4
114 (0.207)

SELECT *
FROM oc_theme
WHERE store_id = '0' AND theme = 'tackle' AND route = 'common/header'
/home/fp2026/public_html/fishingplanet/catalog/model/design/theme.php:4
115 (0.082)

SELECT *
FROM oc_theme
WHERE store_id = '0' AND theme = 'tackle' AND route = 'product/product'
/home/fp2026/public_html/fishingplanet/catalog/model/design/theme.php:4

0

Cressi Gringo Black

9,00 €

Cressi Perla Green

22,00 €

Περιγραφή

Εξαιρετική επιλογή...

Προδιαγραφές προϊόντος

0

Cressi Gringo Black

9,00 €

Σχετικά Προϊόντα

Cressi Perla Green

22,00 €

Περιγραφή

Εξαιρετική επιλογή...

Προδιαγραφές προϊόντος