string(1349) "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, 34, 41, 46, 45))) AND ps.id_shop='1' AND ps.visibility IN ('both', 'catalog') AND cg.id_group='1' AND cp.id_category='12' 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(1662) "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, 34, 41, 46, 45))) AND ps.id_shop='1' AND ps.visibility IN ('both', 'catalog') AND cg.id_group='1' 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, 34, 41, 46, 45))) AND cg.id_group='1' AND c.level_depth<=2 AND c.nleft>2 AND c.nright<89 GROUP BY cp.id_category"
string(1268) "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 cp.id_category='12' 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(1384) "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, 34, 41, 46, 45))) AND ps.id_shop='1' AND ps.visibility IN ('both', 'catalog') AND cg.id_group='1' AND cp.id_category='12' 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, 34, 41, 46, 45)))"
string(1395) "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, 34, 41, 46, 45))) AND ps.id_shop='1' AND ps.visibility IN ('both', 'catalog') AND cg.id_group='1' AND cp.id_category='12' 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, 34, 41, 46, 45))) AND p.date_add>'2026-02-06 00:00:00'"
string(2040) "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, 34, 41, 46, 45))) AND ps.id_shop='1' AND ps.visibility IN ('both', 'catalog') AND cg.id_group='1' AND cp.id_category='12' 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:11:29' >= sp.from) AND
(sp.to = '0000-00-00 00:00:00' OR '2026-02-25 11:11:29' <= 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, 34, 41, 46, 45)))"
Etusivulle | théhuone
“Valkoinen pioni” Baimudan on kiinalainen Fujianin maakunnan valkoinen teelaatu. Siihen käytetään dabai- ja shuixian-pensaiden silmuja ja jo avautuneita lehtiä. Hautuessaan lehdet säilyttävät alkuperäisen muotonsa. Juoma on vaaleankellertävä, pehmeä, erityisen hieno ja aromaattinen. Alhainen...
Keltaisen teen historia ulottuu Ming- ja Qing‐dynastioiden ajoille. Tämä keltainen tee tuottaa miellyttävän paahteisen ja makeahkon aromin. Haudutus: 75‐80 °C 3 min.
Hienoimmat nuppulehdet kieritelty helmen muotoisiksi ja aromisoitu jasmiinin kukilla. Makean suloinen tee, jossa tuoreen jasmiinin ja pehmeän raikas vihreän teen maku. Haudutus: n. 5 helmeä/2dl, 80‐85 °C 7 min.
”Hopeaneulasia” pidetään yhtenä maailman upeimmista teelaaduista. dapai‐pensaan avautumattomat kärkisilmut ovat neulasmaisen pitkiä ja hopeaisen nukan peitossa. Juoma on vaaleankeltainen, hieman oranssiin vivahtava. Tuoksultaan raikas ja kukkainen tee on makeaa jättäen viipyvän, myöhäiseen kesään...
Karpaloiden raikkaus yhdistettynä lempeään vadelman makeuteen antaa tälle vihreälle sencha‐teelle omaleimaisen ja pehmeän maun. Aineksina karpalo, vadelma, ruusun terälehdet ja japanilainen vihreä tee. Haudutus: 75-80 °C 2‐3 min
Japanilaisella kirsikalla on oma asemansa japanilaisessa kulttuurissa. Aineksina japanilainen vihreä sencha‐tee, ruusunterälehdet ja sakurakirsikka-aromi. Hurmaavan makea teesekoitus. Haudutus: 75‐80 °C 2‐3 min.
Marokkolaistyyppinen voimakkaasti minttuinen tee. Kiinalaiseen vihreään Gunpowder-teehen on sekoitettuna makeahkon marokkolaisen Nana-mintun lehtiä. Haudutus: 75-‐80 °C 2-‐ 3 Marokkolaistyyppinen voimakkaasti minttuinen tee. Kiinalaiseen vihreään Gunpowder-‐ teehen on sekoitettuna makeahkon...
Senchaa, genmaichaa, karpaloa, punaisia ja keltaisia ruusunnuppuja, ruusun terälehtiä, aromia sekä krysanteeminkukkia sisältävä vihreä tee. Haudutus: 75-80 °C 2-3 min.
Pehmeän herkullinen ja raikas valkoisen ja vihreän teen sekoitus Kiinan arvokkaista teelaaduista. Vaaleanpunaiset ruusunnuput sekä vadelman ja punaherukan raikkaat palat herkistävät leikkisästi teen hienostunutta luonnetta. Aineksina China sencha, Lung Ching, Yunnan Green, Pai Mu Tan,...
Käsintuotettu teelaatu jonka sileä rakenne juontuu sen kasvualustasta. Kermainen aromi saadaan teen lehtiin erityisellä höyrytysmenetelmällä. Haudutus: 75-80 °C 2-3 min.
