Missing indices on ranking views

[Brutus5000]

global_rating_rank_view and ladder1v1_rating_rank_view are joined by the api for filtering games with players rating above X.

Missing a foreign key to the login table as well as missing an index on the rating the query result in a nested loop with terrible performance (sometimes >60s) potentially cascading into server being unresponsive.