Login
You're viewing the techdon.dev public feed.
  • Apr 18, 2026, 4:38 PM

    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
    )
    )
    );

    💬 1🔄 0⭐ 0

Replies

  • 💬 0🔄 0⭐ 1
  • Apr 18, 2026, 4:53 PM

    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;

    💬 1🔄 0⭐ 0
  • Apr 18, 2026, 4:53 PM

    Outliers here aren't necessarily abusers, but accounts you might want to take a look at.

    💬 0🔄 0⭐ 2