SELECT
q_discussion.object_id AS product_id,
AVG(
q_discussion_rating.rating_value
) AS average_rating,
q_discussion.type AS discussion_type,
q_discussion.thread_id AS discussion_thread_id
FROM
q_discussion
LEFT JOIN q_discussion_posts ON q_discussion_posts.thread_id = q_discussion.thread_id
AND q_discussion_posts.status = "A"
LEFT JOIN q_discussion_rating ON q_discussion.thread_id = q_discussion_rating.thread_id
AND q_discussion_rating.post_id = q_discussion_posts.post_id
AND q_discussion_rating.rating_value != 0
WHERE
q_discussion.object_id IN (34565)
AND q_discussion.object_type = "P"
GROUP BY
q_discussion.object_id