Online Computer Price list:hardware Parts Nehru Place Market Shop - HelpingIndia

3065 Expression #1 of ORDER BY clause is not in SELECT list, references column 'helpingi_zenshop139.p.products_sort_order' which is not in SELECT list; this is incompatible with DISTINCT
in:
[select distinct p.products_id, p.products_image, p.products_tax_class_id, pd.products_viewed, pd.products_name, pd.products_description, p.products_date_added, p.products_price, p.products_type, p.master_categories_id from products p, products_description pd where p.products_id = pd.products_id and pd.language_id = '1' and p.products_status = 1 and p.product_is_call = 0 order by p.products_sort_order, p.products_last_modified DESC, p.products_date_added DESC, p.products_ordered DESC, RAND() LIMIT 0, 48]