DB Error: unknown errorSELECT DISTINCT ct.country_id, ct.title,ct.flag FROM fsp_travel_countries as ct INNER JOIN fsp_travel_countries_menu_ids as cmi ON ct.country_id = cmi.country_id WHERE cmi.menu_country_id = 4 and ct.is_published =1 ORDER by view_order ASC [nativecode=3065 ** Expression #1 of ORDER BY clause is not in SELECT list, references column 'host1028_1.ct.view_order' which is not in SELECT list; this is incompatible with DISTINCT]