Ratings per Review Query

SELECT Site_Anime_Reviews.ID, Site_Anime_Reviews.AuthorID, Site_Anime_Reviews.Body, Site_Anime_Reviews.Date, Site_Anime_Reviews.Score,  RatingTable.TotalPositiveRatings, RatingTable_Negative.TotalNegativeRatings, ((
    CASE WHEN
        ISNULL(RatingTable.TotalPositiveRatings) THEN 0
    ELSE  RatingTable.TotalPositiveRatings
    END)/((
        CASE WHEN
            ISNULL(RatingTable_Negative.TotalNegativeRatings) THEN 0
        ELSE RatingTable_Negative.TotalNegativeRatings
        END) + 1)) As RatingRatio
FROM Site_Anime_Reviews
LEFT JOIN (
    SELECT ReviewID, Count(ReviewRating) As TotalPositiveRatings FROM Site_Anime_Review_Ratings WHERE ReviewRating = 1 GROUP BY ReviewID
) RatingTable ON Site_Anime_Reviews.ID = RatingTable.ReviewID
LEFT JOIN (
    SELECT ReviewID, Count(ReviewRating) As TotalNegativeRatings FROM Site_Anime_Review_Ratings WHERE ReviewRating = 0 GROUP BY ReviewID
) RatingTable_Negative ON Site_Anime_Reviews.ID = RatingTable_Negative.ReviewID
WHERE (Site_Anime_Reviews.Hidden = 0) AND (Site_Anime_Reviews.AnimeID = 53)
GROUP BY Site_Anime_Reviews.ID
ORDER BY RatingRatio DESC, RatingTable_Negative.TotalNegativeRatings ASC
LIMIT #VARIABLE, #VARIABLE