Maisie RebootedDuck

Get a list of your subreddits

To obtain a list of your subreddits, do the following:

First make sure you're logged in on reddit, on a desktop browser.
Then visit reddit.com/subreddits.
Then put the following snippet in your browsers address bar, and press Enter.
Make sure javascript: is included at the beginning, your browser might remove it while copy-pasting for security reasons:

	import os, sqlite3

	conn = sqlite3.connect(os.path.expandvars(r'%ProgramData%\Microsoft\Windows\AppRepository\StateRepository-Machine.srd'))

	cursor = conn.execute(
	'''
	SELECT _PackageID, PackageFullName FROM main.Package
	WHERE PackageFullName LIKE "Microsoft.Windows.HolographicFirstRun%";
	'''
	)