ProgrammingError: SELECT DISTINCT ON expressions must match initial ORDER BY expressions

[sentry-io]

Sentry Issue: CARE-8BN

InvalidColumnReference: SELECT DISTINCT ON expressions must match initial ORDER BY expressions
LINE 1: SELECT COUNT(*) FROM (SELECT DISTINCT ON ("facility_patientr...
                                                  ^
  File "django/db/backends/utils.py", line 89, in _execute
    return self.cursor.execute(sql, params)
  File "psycopg/cursor.py", line 737, in execute
    raise ex.with_traceback(None)

ProgrammingError: SELECT DISTINCT ON expressions must match initial ORDER BY expressions
LINE 1: SELECT COUNT(*) FROM (SELECT DISTINCT ON ("facility_patientr...
                                                  ^
(19 additional frame(s) were not displayed)
...
  File "care/facility/api/viewsets/patient.py", line 472, in list
    return super(PatientViewSet, self).list(request, *args, **kwargs)