3065 - Expression #1 of ORDER BY clause is not in SELECT list, references column 'heinemann_shop.pn.sortierung' which is not in SELECT list; this is incompatible with DISTINCT

select distinct p.products_id, p.products_fsk18, pd.products_name, pd.products_short_description, pd.products_mini_description, pd.products_midi_description, pd.products_maxi_description, p.products_image, p.products_price, p.products_vpe, p.products_vpe_status, p.products_vpe_value, p.products_tax_class_id, p.products_date_added, m.manufacturers_name, m.manufacturers_image from products p left join manufacturers m on p.manufacturers_id = m.manufacturers_id left join products_description pd on p.products_id = pd.products_id, categories c, products_to_categories p2c, products_new AS pn WHERE pd.language_id = '2' and c.categories_status=1 and c.shop_typ = 'schwimmsport' and p.products_id = p2c.products_id and c.categories_id = p2c.categories_id and products_status = '1' and pn.products_id = p.products_id order by pn.sortierung ASC

[XT SQL Error]