SQLite User Forum

Should SQLite be able to optimize this query?
Login
As a really safe alternative, how about if the ignore-order-by only took place for a specific list of aggregations (or even just `count`)?