Application database error: [Expression #1 of ORDER BY clause is not in SELECT list, references column 'bce_bcedb.b.sortorder' which is not in SELECT list; this is incompatible with DISTINCT]
SELECT DISTINCT a.catid, b.catname, b.units FROM pricelist_rates a, categories b WHERE listid = 5086 AND a.catid = b.catid order by b.sortorder