string(1369) "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 (49, 40, 39, 34, 53, 41, 48, 45, 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(1718) "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 (49, 40, 39, 34, 53, 41, 48, 45, 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 (49, 40, 39, 34, 53, 41, 48, 45, 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(1416) "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 (49, 40, 39, 34, 53, 41, 48, 45, 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 (49, 40, 39, 34, 53, 41, 48, 45, 44)))"
string(1427) "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 (49, 40, 39, 34, 53, 41, 48, 45, 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 (49, 40, 39, 34, 53, 41, 48, 45, 44))) AND p.date_add>'2026-02-06 00:00:00'"
string(2072) "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 (49, 40, 39, 34, 53, 41, 48, 45, 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:11:24' >= sp.from) AND
(sp.to = '0000-00-00 00:00:00' OR '2026-02-25 11:11:24' <= 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 (49, 40, 39, 34, 53, 41, 48, 45, 44)))"
Etusivulle | théhuone
Kuuluisa Castletonin tila tuottaa kesän hienoimpia Darjeeling-laatuja, jotka rikkovat ennätyksiä Kalkutan markkinoilla. Sen muotoillut, kärkevät lehdet tuottavat pähkinänvärisen juoman. Castleton on tunnettu herkullisesta muskatellin vivahteestaan. Haudutus: 95 °C 2,5-3,5 min.
Korkealaatuinen sekoitus, jossa sakeutta antaa kevyesti paahdettu matcha. Erinomainen myös jääteen valmistamiseen: 1 teepussi/ 500-‐1000ml kylmää vettä. Ravista tai sekoita, tarjoile kylmänä. Kuumana 80 C 1 min. Veden määrä halutun voimakkuuden mukainen. Yksi pussi sisältää 10 kpl Kiyoshi...
Käsinpunotut suuret teekukat ovat kauneimmillaan haudutettuna lasipannussa tai suuressa lasimukissa. Vihreän ja valkoisen teen pitkät lehdet aukeavat haudutuksen aikana paljastaen sisältään kauniin kukkasen. Haudutus: 85-90 °C, kunnes teekukka on auennut, kuitenkin max. 10 min.
Pussi sisältää 2...
Pehmeänmausteinen, makeahko intialaistyyppinen teelaatu nautittavaksi maidon kera tai ilman. Aineksina intialainen musta tee, kardemumma, cassia, kaneli, inkivääri, neilikka ja mustapippuri. Haudutus: 97°C 8‐12 min.
FI-EKO-201
"Rautainen Guanyin" on Kiinan kuuluisimpia teelaatuja. Anxista, eteläisestä Fujianista peräisin olevassa Tie Guanyinissä on tälle teelaadulle tyypillinen sekoitus vaniljan ja miedon orkidean aromia. Haudutus: 90 °C 1‐3 min. Useampi haudutus mahdollista.
FI-EKO-201
Yrttisekoitus ihanan rentouttaviin hetkiin, aineksinaan vihreä tee, melissa, limepuun kukkaset, tulsi, appelsiininkuori, malvan- ja kehäkukan terälehdet, omena ja sitruunaverbena. Haudutus: 97 °C 6-10min.
Virkistävän lämmittävä, miedosti mausteinen ja hunajainen sekoitus. Vihreä ja valkea tee, inkivääri, omenanpalat, vadelmanlehdet, kehäkukanlehdet, sitruunamyrtti, kardemumma ja sitruunaruoho. Haudutus: 70-80 °C 2‐3 min.
