2015 Spring Festival Notice Feb 14-25

From February 14 to February 25 is the biggest holiday Spring Festival for all Chinese people all over the world in a year. Please kindly understand we are not able to arrange new shipment and provide technical support during the festival. New orders can still be accepted and pre-sale question still be replied via email.

Let's welcome a brand new year of sheep and make best wishes. 

This article was published on Saturday 14 February, 2015.
Print This Article
3065 - Expression #1 of ORDER BY clause is not in SELECT list, references column 'ats.ax.sort_order' which is not in SELECT list; this is incompatible with DISTINCT

select distinct a.products_id, a.products_image, ad.products_name from articles_xsell ax, products a, products_description ad where ax.articles_id = '22' and ax.xsell_id = a.products_id and a.products_id = ad.products_id and ad.language_id = '1' and a.products_status = '1' order by ax.sort_order asc limit 6