Post #2041496
2026-04-18 16:38 UTC
SELECT
invited_accounts.username AS invited_user,
invited_users.created_at AS join_date
FROM users AS invited_users
JOIN accounts AS invited_accounts ON invited_users.account_id = invited_accounts.id
WHERE invited_users.invite_id IN (
SELECT id
FROM invites
WHERE user_id = (
SELECT id
FROM users
WHERE account_id = (
SELECT id
FROM accounts
WHERE username = 'USER'
AND domain IS NULL
)
)
);
Replies (3)
-
@tim@union.place 2026-04-18 16:39
That was very conveniently a 497 character query lol.
-
@tim@union.place 2026-04-18 16:53
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;
-
@stefan@gardenstate.social 2026-04-18 17:48
@tim nice! That would be a great feature request to the admin UI.