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]