2048 Bit SSL Certificate
Tea for One (from different manufacturers)
HOME
Welcome to HotTeapots.com. ..... Visit our store in Doetinchem, Netherlands.... In our store more than 165 tea-varieties..... Online: Try Dilmah, Piramide, Original First or Revolution tea....
HotTeapots.com HotTeapots.com - everything for a nice cup ot tea...
black tea Black
tea
green tea White
Green
& Oolong
tea
Fruit tea Fruit
tea
rooibos tea Rooibos
 tea
Herbal tea Herbal
 tea
  Tea for One My Account  |  Cart Contents  |  Checkout   
Categories
Tea enjoyment
Tea Cosies
Accessories
Books & Gifts
Bredemeijer insulated teapots
Bodum
Le Creuset Tea Kettles
Trendglas Jena
Round Bellied Teapots
Tableware
Tea for One
Water Filters
Porcelain / Bone China
Ceramics
Collectible teapots
Scandinavian Design
Glass Products
Oriental
Stoneware
Sale Items
Specials
Newest Products
Select a category
from this list

What's New? more
Qdo Cylinder Glass Teapot with clip handle, turqoise, 1,0 Liter
Qdo Cylinder Glass Teapot with clip handle, turqoise, 1,0 Liter
34.95EUR (incl VAT)
28.88EUR (excl VAT)
Top 5 Countries & Cities
Top 5 Countries:
Netherlands
Germany
United Kingdom
United States
Belgium

Top 5 Cities:
Amsterdam
Berlin
London
Hamburg
DEN HAAG

Tea for One (from different manufacturers)
Show: 
Displaying 13 to 16 (of 16 products) Result Pages: [<< Prev]   1  2 
1064 - You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'order by pd.products_name limit 12, 12' at line 1

select p.products_image, pd.products_name, p.products_quantity, p.products_id, p.manufacturers_id, p.products_price, p.products_tax_class_id, p.products_sort_order, IF(s.status, s.specials_new_products_price, NULL) as specials_new_products_price, IF(s.status, s.specials_new_products_price, p.products_price) as final_price from products_description pd, products p left join manufacturers m on p.manufacturers_id = m.manufacturers_id left join specials s on p.products_id = s.products_id, products_to_categories p2c where p.products_status = '1' and p.products_id = p2c.products_id and pd.products_id = p2c.products_id and pd.language_id = '1' and p2c.categories_id = '124' order by order by pd.products_name limit 12, 12

[TEP STOP]