Welcome to our table tennis equipment web shop for professionals and amateurs. We are offering wide assortment of table tennis equipment and articles made by a number of well known European and Asiatic producers. You are welcomed to choose articles which you are interested in through online orders or E-mail.
This article was published on Saturday 11 February, 2012.
3065 - Expression #1 of ORDER BY clause is not in SELECT list, references column 'pingpong_shop.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 = '8' 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