[Konstantinos]

Do you want to retrieve the name of the rank according to player's rank number and their faction with a query? If so, can you post the structure of those tables?

And from what I see from the code above, you load each rank data separately when you can do that with just one query.