SELECT row_num 'Row #',u.Rating,t.`Trail Name`,t.`National Park`,t.`Trail Difficulty` FROM ( SELECT *, (SELECT COUNT(*) FROM `UserReview` u2 WHERE u2.Rating > u.Rating OR u2.Rating = u.Rating AND u2.Trail_ID <= u.Trail_ID ) AS row_num FROM `UserReview` u ) AS u INNER JOIN Trails t ON u.Trail_ID=t.ID WHERE row_num <= 10 ORDER BY row_num