string(1364) "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 (34, 50, 51, 53, 41, 48, 46, 45))) AND ps.id_shop='1' AND ps.visibility IN ('both', 'catalog') AND cg.id_group='1' AND c.nleft>=8 AND c.nright<=9 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" Black tea
Black tea

Black tea

Vanilla Black
3

Vanilla Black

A full-bodied and soft, sweet vanilla black tea. Real bourbon vanilla and natural vanilla flavouring added to Chinese black tea. Recommended brewing: 97°C 3-4 min.

Price €0.10
Black Mango
3

Black Mango

A delicious black mango tea flavoured with mango pieces and extract. Recommended brewing: 97°C 3-4 min.

Price €0.10
Golden Nepal
3

Golden Nepal

Fine quality, soft aromatic loose leaf tea with a light, slightly smoky sweetness. The smell is loaded with spiciness. Recommended brewing: 97°C 3-5 min.

Price €0.08
Bloob Orange
4

Bloob Orange

Sweet and fresh Italian blood orange mixed in with a delicate blend of Chinese and Ceylon black teas, garnished with safflowers bring to mind warm, fragrant summer evenings. Recommended brewing: 97°C 3-4 min.

Price €0.10
Blueberry
6

Blueberry

A sweet and tangy black tea flavoured with blueberries, mallow flowers, blackcurrant leaves and blueberry extract. Recommended brewing: 97°C 3-4 min.

Price €0.10
Kanchanjancha T.G.F.O.P.1, Organic
1

Kanchanjancha T.G.F.O.P.1,...

Black organically grown tea from Nepal. The taste is full-bodied, the scent refined and balanced. Recommended brewing: 95°C 2.5-3 min.

Price €0.08
Thé Champagne Black
5

Thé Champanja Black

A delightfully bubbly black tea blend flavoured with champagne grapes, strawberry pieces, jasmine flowers and cornflower petals. Recommended brewing: 97°C 3-4 min.

Price €0.10
Black Rhubarb
3

Black Rhubarb

A sweet, slightly tart yet delicately fresh taste experience, with pink, freeze-dried rhubarb pieces to seduce the taste buds. A fine black tea blend. The ingredients are black tea, pieces of rhubarb and a creamy flavouring. Recommended brewing: 97°C 3-4 min.

Price €0.10
Ceylon Peach
5

Ceylon Peach

A full-bodied and nuanced Ceylon tea with colourful flower petals, not to mention a charming peach scent. The ingredients are black tea, and bursting with flower petals including: sunflower, rose, safflower and cornflower. Recommended brewing: 97°C 3-4 min.

Price €0.10
Black Cranberry
3

Black Cranberry

Fresh and attractive cranberry combined with deliciously sweet raspberry give this lush black tea a very berry soul. The ingredients are black tea, cranberries, raspberries and natural flavourings. Recommended brewing: 97°C 3-4 min.

Price €0.10
Apricot Peach
3

Apricot Peach

A luxurious tea blend of Ceylon and Chinese black teas flavoured with apricot and peach, decorated with sunflower and mallow petals. Recommended brewing: 97°C 3-4 min.

Price €0.10
Pommegranate Cranberry
4

Pommegranate Cranberry

A unique tea blend of black tea, pomegranate seeds, peony petals, natural flavourings and pieces of raspberry and cranberry. Recommended brewing: 97°C 3-4 min.

Price €0.10
Back to top