SQL::SELECT user_id, ROUND(SUM(1 /(1 - k_weight)), 2) AS weight FROM( SELECT receptor_id AS user_id, k_weight FROM kybchain JOIN ( SELECT giver_id AS k_giver, (1 -1 /(COUNT(*) + 1)) *(1 -1 /(COUNT(DISTINCT receptor_id) + 1)) AS k_weight FROM kybchain WHERE stamp > NOW() - INTERVAL INT::KYBCHAIN_BONIFICATION_INTERVAL DAY AND type = 'K' GROUP BY giver_id) user_weights ON kybchain.giver_id = k_giver WHERE stamp > NOW() - INTERVAL INT::KYBCHAIN_BONIFICATION_INTERVAL DAY AND type = "K" GROUP BY receptor_id, k_giver ) weighted GROUP BY user_id;