[ENG-504] Modifying query in get_auth for optimization.

[corbinSanders]

Purpose

get_auth is slow. This PR modifies a query to try to improve performance, however there is more work to be done.

Changes

Breaking out one query into two queries to improve performance.

QA Notes

There should be no change in functionality.

Documentation

Side Effects

Ticket

https://openscience.atlassian.net/browse/ENG-504