Pain point · Reliability & bugs · Blocks work
Ordering by an aggregate ignores the filter applied to that aggregate
1 source thread · first seen 2019-01
Summary
When sorting authors by an aggregated article count, the SQL does not apply the same filter used in the selected aggregate count, giving inconsistent results.
Evidence
Excerpts are copied word for word from the source; follow the link to read it in full.
“It looks like the SQL query doesn't apply the filter used in the aggregated count on the `order_by` count”