$splitRatings = $this->app()->db()->fetchAllKeyed("
SELECT rating,
COUNT(*) AS total,
(COUNT(*) / ?) * 100 AS percentage
FROM xf_rm_resource_rating
WHERE resource_id = ?
AND rating_state = 'visible'
GROUP BY rating
", 'rating', [$resource->review_count, $resource->resource_id]);