MYSQL QUERY ERROR REPORT - 17/10/2019 22:10:10 --------------------------------------- 3065 - Expression #1 of ORDER BY clause is not in SELECT list, references column 'domovik_solomono.p.products_sort_order' which is not in SELECT list; this is incompatible with DISTINCT select distinct p.products_id, pd.products_url, pd.products_name, p.products_image, p.products_model, p.lable_1, p.lable_2, p.lable_3, p.products_quantity, p.products_tax_class_id, p.products_price as products_price from products_description pd , products p left join manufacturers m on p.manufacturers_id = m.manufacturers_id, products_to_categories p2c where p.products_status = '1' and p.products_id = p2c.products_id and pd.products_id = p2c.products_id and pd.language_id = '5' and p2c.categories_id in(39) order by p.products_sort_order, pd.products_name limit 0, 20 --------------------------------------- Server Name : domovik.com Remote Address: 18.207.134.98 Referer : Requested : /hb/-/c-34-39.html