select distinct users always
fix 'just the counts' to work with list-of-json-entries result
fix 'raw sql' view to work with new api-based search approach (bonus feature: this view is much much faster now since we don't actually need to run the remote query)
fix 'search - just akids' view