A very clean solution to sorting when you can't do it in your query is to use multirow_cols in your -orderby
See here: https://openacs.org/api-doc/proc-view?proc=template%3a%3alist%3a%3aorderby%3a%3acreate
Brian