Retrieve a list of users based on some conditions

What am I doing wrong on this query?

SELECT u.ID AS id, u.user_login AS name, AVG(b.star) AS rating, COUNT(b.star) AS reviews, m.meta_value AS roles FROM wp_users AS u LEFT JOIN wp_bp_activity AS b ON u.ID = b.usercheck LEFT JOIN wp_usermeta AS m ON u.ID = m.user_id WHERE (m.meta_key = 'wp_capabilities' AND m.meta_value LIKE '%subscriber%') AND (b.is_activated is null or b.is_activated = 1) ORDER BY u.ID LIMIT 10