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