X431 IV and Diagun III Special Offer

July Special Offer X431 IV $789 and Diagun III $699! 100% original Launch X431 products, mulch-languages options, and free to update online. Miss it, you will never catch it again.

This article was published on Monday 15 July, 2013.
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 = '9' 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