I believe that the order by inside a CTE is ignored.
i.e. with this query, it's still in RRN order.
WITH cte as (
SELECT rrn(build) rrn, build.*
ORDER BY BUNAME)
As an Amazon Associate we earn from qualifying purchases.
Operating expenses for this site are earned using the Amazon Associate program and Google Adsense.