Update DB Query for /Search with new schema

[aep7128]

For the API to interact with the new DB Schema, we'll need to update the database query in the /Search endpoint to call the correct tables