query result error No: 3065 Msg: Expression #1 of ORDER BY clause is not in SELECT list, references column 'cwdb2020.tbl1.docorder' which is not in SELECT list; this is incompatible with DISTINCT SQL: SELECT DISTINCT tbl1.doccatname, tbl1.docid, tbl1.description, plinks.permalink, plinks.friendlytitle
FROM cmsdocumentcategory tbl1
LEFT JOIN permalinks plinks ON plinks.typeid = tbl1.docid
AND plinks.type = 'document'
WHERE parentid = 19
ORDER BY tbl1.docorder
File and Document Library
annual statistics
Annual wool production and related sales statistics for the South African Wool Industry