I'm looking for a particular question that I answered myself, because I want to find a meta-discussion in the comments about whether that's okay (spoiler: it is).
Has anyone written a query that will find those questions for me?
Meta Stack Exchange is a question and answer site for meta-discussion of the Stack Exchange family of Q&A websites. It only takes a minute to sign up.Sign up to join this community
I join here the posts table with itself as it holds both questions and answers. The parentid on an answer act as the foreignkey for the question it belongs to. To select posts that belong to a specific user we limit the results to a specific owneruserid. As you're only interested in self-answers we apply that condition to both questions and answers.
select q.id as [Post Link] from posts q inner join posts a on a.parentid = q.id where q.owneruserid = ##userid## and a.owneruserid = ##userid##
You can switch the query to any site (main or meta) and enter your userid for that specific site.
Keep in mind that SEDE is only updated once a week, on Sunday.