string(1357) "SELECT p.id_product FROM (SELECT p.id_product, p.id_manufacturer, SUM(sa.quantity) as quantity, p.condition, p.weight, p.price, psales.quantity as sales, p.on_sale, p.date_add, cp.position FROM a39e_product p LEFT JOIN a39e_product_attribute pa ON (p.id_product = pa.id_product) LEFT JOIN a39e_product_attribute_combination pac ON (pa.id_product_attribute = pac.id_product_attribute) LEFT JOIN a39e_stock_available sa ON (p.id_product = sa.id_product AND IFNULL(pac.id_product_attribute, 0) = sa.id_product_attribute AND sa.id_shop = 1 AND sa.id_shop_group = 0 ) LEFT JOIN a39e_product_sale psales ON (psales.id_product = p.id_product) INNER JOIN a39e_category_product cp ON (p.id_product = cp.id_product) INNER JOIN a39e_product_shop ps ON (p.id_product = ps.id_product AND ps.id_shop = 1 AND ps.active = TRUE) INNER JOIN a39e_category c ON (cp.id_category = c.id_category AND c.active=1) LEFT JOIN a39e_category_group cg ON (cg.id_category = c.id_category) LEFT JOIN a39e_feature_product fp ON (p.id_product = fp.id_product) WHERE ((fp.id_feature_value IN (38, 49, 50, 34, 41, 44))) AND ps.id_shop='1' AND ps.visibility IN ('both', 'catalog') AND cg.id_group='1' AND c.nleft>=2 AND c.nright<=89 GROUP BY p.id_product) p INNER JOIN a39e_category_product cp ON (p.id_product = cp.id_product) GROUP BY p.id_product ORDER BY p.position ASC, p.id_product DESC"
string(1694) "SELECT cp.id_category, COUNT(DISTINCT p.id_product) c FROM (SELECT p.id_product, p.id_manufacturer, SUM(sa.quantity) as quantity, p.condition, p.weight, p.price, psales.quantity as sales, p.on_sale, p.date_add, cp.position FROM a39e_product p LEFT JOIN a39e_product_attribute pa ON (p.id_product = pa.id_product) LEFT JOIN a39e_product_attribute_combination pac ON (pa.id_product_attribute = pac.id_product_attribute) LEFT JOIN a39e_stock_available sa ON (p.id_product = sa.id_product AND IFNULL(pac.id_product_attribute, 0) = sa.id_product_attribute AND sa.id_shop = 1 AND sa.id_shop_group = 0 ) LEFT JOIN a39e_product_sale psales ON (psales.id_product = p.id_product) INNER JOIN a39e_category_product cp ON (p.id_product = cp.id_product) INNER JOIN a39e_product_shop ps ON (p.id_product = ps.id_product AND ps.id_shop = 1 AND ps.active = TRUE) INNER JOIN a39e_category c ON (cp.id_category = c.id_category AND c.active=1) LEFT JOIN a39e_category_group cg ON (cg.id_category = c.id_category) LEFT JOIN a39e_feature_product fp ON (p.id_product = fp.id_product) WHERE ((fp.id_feature_value IN (38, 49, 50, 34, 41, 44))) AND ps.id_shop='1' AND ps.visibility IN ('both', 'catalog') AND cg.id_group='1' AND c.nleft>=2 AND c.nright<=89 GROUP BY p.id_product) p INNER JOIN a39e_category_product cp ON (p.id_product = cp.id_product) INNER JOIN a39e_category c ON (cp.id_category = c.id_category AND c.active=1) LEFT JOIN a39e_category_group cg ON (cg.id_category = c.id_category) LEFT JOIN a39e_feature_product fp ON (p.id_product = fp.id_product) WHERE ((fp.id_feature_value IN (38, 49, 50, 34, 41, 44))) AND cg.id_group='1' AND c.level_depth<=2 AND c.nleft>2 AND c.nright<89 GROUP BY cp.id_category"
string(1276) "SELECT fp.id_feature, fp.id_feature_value, COUNT(DISTINCT p.id_product) c FROM (SELECT p.id_product, p.id_manufacturer, SUM(sa.quantity) as quantity, p.condition, p.weight, p.price, psales.quantity as sales, p.on_sale, p.date_add, cp.position FROM a39e_product p LEFT JOIN a39e_product_attribute pa ON (p.id_product = pa.id_product) LEFT JOIN a39e_product_attribute_combination pac ON (pa.id_product_attribute = pac.id_product_attribute) LEFT JOIN a39e_stock_available sa ON (p.id_product = sa.id_product AND IFNULL(pac.id_product_attribute, 0) = sa.id_product_attribute AND sa.id_shop = 1 AND sa.id_shop_group = 0 ) LEFT JOIN a39e_product_sale psales ON (psales.id_product = p.id_product) INNER JOIN a39e_category_product cp ON (p.id_product = cp.id_product) INNER JOIN a39e_product_shop ps ON (p.id_product = ps.id_product AND ps.id_shop = 1 AND ps.active = TRUE) INNER JOIN a39e_category c ON (cp.id_category = c.id_category AND c.active=1) LEFT JOIN a39e_category_group cg ON (cg.id_category = c.id_category) WHERE ps.id_shop='1' AND ps.visibility IN ('both', 'catalog') AND cg.id_group='1' AND c.nleft>=2 AND c.nright<=89 GROUP BY p.id_product) p INNER JOIN a39e_feature_product fp ON (p.id_product = fp.id_product) WHERE ((fp.id_feature=8)) GROUP BY fp.id_feature_value"
string(1392) "SELECT COUNT(DISTINCT p.id_product) c FROM (SELECT p.id_product, p.id_manufacturer, SUM(sa.quantity) as quantity, p.condition, p.weight, p.price, psales.quantity as sales, p.on_sale, p.date_add, cp.position FROM a39e_product p LEFT JOIN a39e_product_attribute pa ON (p.id_product = pa.id_product) LEFT JOIN a39e_product_attribute_combination pac ON (pa.id_product_attribute = pac.id_product_attribute) LEFT JOIN a39e_stock_available sa ON (p.id_product = sa.id_product AND IFNULL(pac.id_product_attribute, 0) = sa.id_product_attribute AND sa.id_shop = 1 AND sa.id_shop_group = 0 ) LEFT JOIN a39e_product_sale psales ON (psales.id_product = p.id_product) INNER JOIN a39e_category_product cp ON (p.id_product = cp.id_product) INNER JOIN a39e_product_shop ps ON (p.id_product = ps.id_product AND ps.id_shop = 1 AND ps.active = TRUE) INNER JOIN a39e_category c ON (cp.id_category = c.id_category AND c.active=1) LEFT JOIN a39e_category_group cg ON (cg.id_category = c.id_category) LEFT JOIN a39e_feature_product fp ON (p.id_product = fp.id_product) WHERE ((fp.id_feature_value IN (38, 49, 50, 34, 41, 44))) AND ps.id_shop='1' AND ps.visibility IN ('both', 'catalog') AND cg.id_group='1' AND c.nleft>=2 AND c.nright<=89 GROUP BY p.id_product) p LEFT JOIN a39e_feature_product fp_1 ON (p.id_product = fp_1.id_product) WHERE ((p.on_sale=1)) AND ((fp_1.id_feature_value IN (38, 49, 50, 34, 41, 44)))"
string(1403) "SELECT COUNT(DISTINCT p.id_product) c FROM (SELECT p.id_product, p.id_manufacturer, SUM(sa.quantity) as quantity, p.condition, p.weight, p.price, psales.quantity as sales, p.on_sale, p.date_add, cp.position FROM a39e_product p LEFT JOIN a39e_product_attribute pa ON (p.id_product = pa.id_product) LEFT JOIN a39e_product_attribute_combination pac ON (pa.id_product_attribute = pac.id_product_attribute) LEFT JOIN a39e_stock_available sa ON (p.id_product = sa.id_product AND IFNULL(pac.id_product_attribute, 0) = sa.id_product_attribute AND sa.id_shop = 1 AND sa.id_shop_group = 0 ) LEFT JOIN a39e_product_sale psales ON (psales.id_product = p.id_product) INNER JOIN a39e_category_product cp ON (p.id_product = cp.id_product) INNER JOIN a39e_product_shop ps ON (p.id_product = ps.id_product AND ps.id_shop = 1 AND ps.active = TRUE) INNER JOIN a39e_category c ON (cp.id_category = c.id_category AND c.active=1) LEFT JOIN a39e_category_group cg ON (cg.id_category = c.id_category) LEFT JOIN a39e_feature_product fp ON (p.id_product = fp.id_product) WHERE ((fp.id_feature_value IN (38, 49, 50, 34, 41, 44))) AND ps.id_shop='1' AND ps.visibility IN ('both', 'catalog') AND cg.id_group='1' AND c.nleft>=2 AND c.nright<=89 GROUP BY p.id_product) p LEFT JOIN a39e_feature_product fp ON (p.id_product = fp.id_product) WHERE ((fp.id_feature_value IN (38, 49, 50, 34, 41, 44))) AND p.date_add>'2026-02-06 00:00:00'"
string(2048) "SELECT COUNT(DISTINCT p.id_product) c FROM (SELECT p.id_product, p.id_manufacturer, SUM(sa.quantity) as quantity, p.condition, p.weight, p.price, psales.quantity as sales, p.on_sale, p.date_add, cp.position FROM a39e_product p LEFT JOIN a39e_product_attribute pa ON (p.id_product = pa.id_product) LEFT JOIN a39e_product_attribute_combination pac ON (pa.id_product_attribute = pac.id_product_attribute) LEFT JOIN a39e_stock_available sa ON (p.id_product = sa.id_product AND IFNULL(pac.id_product_attribute, 0) = sa.id_product_attribute AND sa.id_shop = 1 AND sa.id_shop_group = 0 ) LEFT JOIN a39e_product_sale psales ON (psales.id_product = p.id_product) INNER JOIN a39e_category_product cp ON (p.id_product = cp.id_product) INNER JOIN a39e_product_shop ps ON (p.id_product = ps.id_product AND ps.id_shop = 1 AND ps.active = TRUE) INNER JOIN a39e_category c ON (cp.id_category = c.id_category AND c.active=1) LEFT JOIN a39e_category_group cg ON (cg.id_category = c.id_category) LEFT JOIN a39e_feature_product fp ON (p.id_product = fp.id_product) WHERE ((fp.id_feature_value IN (38, 49, 50, 34, 41, 44))) AND ps.id_shop='1' AND ps.visibility IN ('both', 'catalog') AND cg.id_group='1' AND c.nleft>=2 AND c.nright<=89 GROUP BY p.id_product) p LEFT JOIN a39e_specific_price sp ON (
sp.id_product = p.id_product AND
sp.id_shop IN (0, 1) AND
sp.id_currency IN (0, 2) AND
sp.id_country IN (0, 7) AND
sp.id_group IN (0, 1) AND
sp.from_quantity = 1 AND
sp.reduction > 0 AND
sp.id_customer = 0 AND
sp.id_cart = 0 AND
(sp.from = '0000-00-00 00:00:00' OR '2026-02-25 11:13:10' >= sp.from) AND
(sp.to = '0000-00-00 00:00:00' OR '2026-02-25 11:13:10' <= sp.to)
) LEFT JOIN a39e_feature_product fp_1 ON (p.id_product = fp_1.id_product) WHERE ((sp.reduction>0)) AND ((fp_1.id_feature_value IN (38, 49, 50, 34, 41, 44)))"
Etusivulle | théhuone
Kesäsateen raikastamat hedelmät maistuvat tässä viehkeässä mustassa teelaadussa, joka on maustettu mangolla ja cantaloupe melonilla. Mukana makoisaa persikkaa sekä kukkien terälehtiä. Haudutus: 97 °C 3 min.
Metsäinen valkoinen santelipuu teesekoitus rauhoittaa mieltä ja rentouttaa kehoa. Ainekset: valkoinen tee, kaneli, kardemumma, muskottipähkinä, vanilja, kehäkukan ja jasmiinin terälehdet. Haudutus: 80 °C 3 min.
Lempeän mantelinen valkoinen tee mausteenaan: omenaa, mantelilastuja, sitruunaruohoa, appelsiinia, mustaherukan lehtiä, kehäkukan ja saflorin terälehtiä. Haudutus: 80 °C 4 min.
Suussasulava, pehmeä karamellitee mausteenaan ripaus Afrikan helmisuolaa. Helposti erottuvat suolakiteet voi annostella makunsa mukaan. Aineksina: musta tee, karamellinpalat, manteli, luontainen uute sekä helmisuola. Haudutus: 97 °C 3 min.
Pirskahteleva teelaatu vihreän ja valkoisen teen lehdistä mausteinaan: mustaherukat, sitruunaverbena, sitruuna myrtti, viikunan palaset, ruiskaunokin terälehdet sekä malvan kukat. Haudutus: 75 °C 3-4 min.
Hedelmillä ja marjoilla maustettu lempeän mausteinen valkoinen tee. Premium laatuinen valkoinen Pai Mu Tan mausteenaan mansikan ja papayan palaset. Tämä ihastuttava, matalakofeiininen tee sopii nautittavaksi myös iltaisin. Ainekset: valkoinen tee, papaya, mansikka sekä kukkien terälehdet....
Appelsiinilla ja neilikalla maustettu afrikkalainen musta teesekoitus. Herkät mausteet tekevät tästä hienosta teelaadusta lämmittävän ja elegantin. Haudutus: 97°C 2,5 min.
Perinteinen kiinalainen Pu’erh-teestä puristettu 357g teekakku. Annostus: kakusta murretaan palanen, n. 4-6g / pannullinen tai 3g / kupillinen, huuhtelu kuumalla vedellä n. 10 s. Haudutus: 90°C 1,5-3 min.
Tämä pu’erh on kunnianosoitus poikkeukselliselle tapahtumalle: Vuonna 2021 16 villielefanttia kulki ensimmäistä kertaa Xishuangbannasta Pu-Erhiin ja takaisin. Tee on ylistys luonnon ja teeperinteen harmonialle ja sen huolellisesti valitut lehdet antavat pehmeän makean ja tasapainoisen...
Sekoitus Intian mustista teelaaduista sekä Darjeeling-laaduista, lisänä orgaanisesti viljeltyä, kuivattua appelsiinin kuorta ja luontaista aromia. Haudutus: 97 °C 3-4 min.
FI-EKO-201
