Now In Your Cart 0 Items
Sign Up Now!
Advanced Search

  • ToxOut 多奥

    An essential substance needed by human body - Dietary Fiber Dietary Fiber is an essential content of health food; its benefits human body in the following ways: 1. Maintain healthy digestives system. 2. Clean wall of digestive tract and improve digestive function.

    Read More

  • Hai-O Original Ginger Liqueur

    Hai-O Original Ginger Liqueur uses 100% fresh matured Bentong ginger, it can be used as cooking cuisine. Traditionally a good post-natal remedy for women.

    Read More

  • HaiZhiLan (Oceanic Blue) 海之蓝

    Yanghe spirit Classic series is our mid end products. We employ centuries-old fermentation techniques to create the traditional sweet, mild, soft, clean and fragrant Yanghe flavors, upon which they build a unique mellowness and quiet elegance.

    Read More

  • MengZhiLan (Dream Blue) M3 梦之蓝M3

    MengZhiLan is strong but not overpowering, gentle but not weak. The taste, bountiful and harmonious, unfolds slowly and ends with a clean finish. The flavor is exquisite and mellow with a long aftertaste. It is truly a masterpiece of Chinese mellow liquor.

    Read More
3065 - Expression #1 of ORDER BY clause is not in SELECT list, references column 'mallhaio_osstore.p.products_ordered' which is not in SELECT list; this is incompatible with DISTINCT

select distinct p.products_id, p.products_image, p.products_min_quantity, p.products_tax_class_id, p.products_price, SUBSTRING_INDEX(pd.products_name,' ',6) as products_name from products p, products_description pd where p.products_status = '1' and p.products_ordered > 0 and p.products_id = pd.products_id and pd.language_id = '1' order by p.products_ordered desc limit 3