My Account  Cart Contents  Checkout  

  Top » Catalog » Oriental Beauty Tea My Account  |  Cart Contents  |  Checkout   
Free Shipping (4)
Lishan Oolong (8)
Alishan Oolong (4)
Alishan Jin Xuan (2)
Dong Ding Oolong (2)
Oriental Beauty Tea (4)
Formosa Native Camellia Tea (1)
Heavy Roasted Oolong Tea (3)
Green Tea (Bi Luo Chuen) (1)
Jasmine Tea (2)
Tie Guan Yin Tea (3)
Pu-erh Tea (5)
Taiwan Black tea (2)
Wholesale Tea (4)
The place of origin
About us
Shop Map
SGS Analysis Certificate
To brew a best cup of Tea
Origin organic farming
Formosa Natural Farming teas
Shinghwa Tea master
Payment by paypal & Fax
Contact Us
What's New? more
Better High Mountain Oolong TeaŚLight (Set of 6)
Better High Mountain Oolong TeaŚLight (Set of 6)
100%TAIWAN OOLONG TEA--Natural Farming teas
Category: Oriental Beauty Tea
100%TAIWAN OOLONG TEA--Natural Farming teas
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 final_price , pd.products_name limit 0, 20' at line 1

select p.products_image, pd.products_name, p.products_id, p.manufacturers_id, p.products_price, p.products_tax_class_id, 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, products_to_categories p2c )left join specials s on p.products_id = s.products_id 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 = '26' order by order by final_price , pd.products_name limit 0, 20