SELECT Data.Ranking, Data.Name, Data.XP, Data.Title, Data.Writeups FROM Data, Close WHERE Data.Ranking BETWEEN Close.Ranking AND Close.Ranking + 1 ORDER BY Data.Ranking;