Post #2041498

If you want to look at your top inviters, here's another query for you: SELECT inviter_accounts.username AS inviter_username, COUNT(invited_users.id) AS total_referrals FROM invites JOIN users AS inviter_users ON invites.user_id = inviter_users.id JOIN accounts AS inviter_accounts ON inviter_users.account_id = inviter_accounts.id JOIN users AS invited_users ON invited_users.invite_id = invites.id GROUP BY inviter_accounts.id, inviter_accounts.username ORDER BY total_referrals DESC;