This topic is locked

SQL stopped working in 9.8

7/5/2017 2:11:24 PM
PHPRunner General questions
John Rotella author

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