I have been using this SQL query in 9.6 and 9.7
SELECT
(Finder),
COUNT(1),
LAST(Timestamp)
FROM Results
WHERE (Finder IS NOT NULL) AND (Finder <>"R")
GROUP BY (Finder)
ORDER BY COUNT(1) DESC
When I started using 9.8 the ORDER BY COUNT(1) DESC is ignored. The page works OK but the default presentation sorts to the (Finder) field. I can click on the header of COUNT to get the result but this is not how it worked before. I checked using 9.7 to make sure. Is there some new control, or is this query type no longer supported?
I should point out the results returned on the Query page in 9.8 are correctly sorted by COUNT but when the project is built, it sorts by Finder alphabetical.
Here is the page http://tbird.info/registry/Spotters_list.php