[linusoleander]

Så här kanske

SELECT users.id, SUM(users.attack + users.defence + items.extra_attack + items.extra_defence) AS total_power
INNER JOIN member_items ON users.id = member_items.user_id
INNER JOIN items ON member_items.item_id = items.id
FROM users
GROUP BY users.id