string(1365) "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, 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(1710) "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, 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, 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(1408) "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, 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, 48, 45, 44)))"
string(1419) "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, 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, 48, 45, 44))) AND p.date_add>'2026-02-06 00:00:00'"
string(2064) "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, 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:19' >= sp.from) AND
(sp.to = '0000-00-00 00:00:00' OR '2026-02-25 11:11:19' <= 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, 48, 45, 44)))"
Etusivulle | théhuone
Tämä Huangshanin keltaisilla vuorilla kasvava lajike on yksi Kiinan kauneimmista vihreistä teelaaduista. Taidolla valmistetun teen lehdet ovat poikkeuksellisen pitkiä ja ohuita. Juomana vaaleankeltainen, kevyt ja pehmeä. Maussa aavistus orkideaa. Haudutus: 75-80 °C 3-5 min.
Yerba Maté sisältää runsaasti erilaisia vitamiineja ja mineraaleja. Runsaan mateiinipitoisuutensa vuoksi se lisää keskittymiskykyä, virkistää ja vähentää ruokahalua. Aineenvaihduntaa edistävä. Haudutus: 70-80°C 4-7 min.
FI-EKO-201
Ainoastaan kultaisia kärkisilmuja on käytetty tämän pu’erh‐teen valmistukseen. Yunnanin Simaosta kotoisin oleva teelaatu on pehmeä ja aromaattinen. Haudutus: 85‐90 °C 1‐3 min. Useampi haudutus mahdollinen.
Tämä Ujin alueen luomu matcha omaa voimakkaan maun ja kauniin vihreän värin. Sopii erinomaisesti ruuanlaittoon ja leivontaan sekä esimerkiksi smoothien ja jäätelön sekaan.
Matcha Latten valmistus: Sekoita 2 dl maitoa ja puolikas teelusikallinen matcha jauhetta ja vaahdota kuohkeaksi...
Tämä tunnettu teetarha, "Silbung" perustettiin v. 1886. Toisen poiminnan sinensis-lehti sisältää runsaasti kärkisilmuja antaen mausteisen, aromaattisen, pehmeän ja kukkaisen, kuparinvärisen juoman. Haudutus: 97 °C 2-3 min.
FI-EKO-201
Hienosti rullattu lehti hierottuna ginseng‐uutteella on perinteinen kiinalainen oolong-tee. Pitkään kielellä viipyvä makea jälkimaku on herkullinen yllätys mihin aikaan päivästä tahansa. Haudutus: 85‐95 °C 1 min. Useampi haudutus mahdollista.
FI-EKO-201
