SELECT
AVG (dr.rating_value)
FROM
cscart_discussion_rating AS dr
LEFT JOIN cscart_discussion_posts AS dp ON dp.post_id = dr.post_id
LEFT JOIN cscart_discussion AS d ON d.thread_id = dp.thread_id
WHERE
d.object_id = 448
AND d.object_type = 'C'
AND type IN ('B', 'R')
AND d.company_id = 1
AND dp.status = 'A'
AND dr.rating_value > 0