Skip to content

Instantly share code, notes, and snippets.

@ECHibiki

ECHibiki/Nice Vichan SQL Query

Last active November 1, 2020 21:02
Show Gist options
  • Star 0 You must be signed in to star a gist
  • Fork 0 You must be signed in to fork a gist
  • Save ECHibiki/628f3459c20e932bbd3ff5e3bb5d08c9 to your computer and use it in GitHub Desktop.
Save ECHibiki/628f3459c20e932bbd3ff5e3bb5d08c9 to your computer and use it in GitHub Desktop.
Download ZIP
Search for password similarities
Raw
Nice Vichan SQL Query
SELECT * FROM (SELECT id, thread, body, ip, password FROM posts_qa UNION SELECT id, thread, body, ip, password FROM posts_jp) as union_subset where password in (SELECT password FROM posts_trans where id=1681);
--This checks for same users across the posts_qa and posts_jp table using the password stored in posts_trans
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment