* feat: move ordering after filtering to avoid ORDER BY using expressions not in SELECT DISTINCT list
* feat: add multiple schemes so tests will fail if this bug appears again
* feat: include schemes and locations with nil confirmed values in incomplete scopes
* refactor: lint