Is there a way to get hold of a parsable list of links (or if that's not possible, IDs)

  • to all my questions

  • to all my answers

preferably without using the data dump?

  • isn't this something the api can do? stackapps.com Commented Feb 2, 2011 at 11:42
  • @Jeff I'm looking for a end-user tool for one-time use. Maybe stackapps has something, I'll check it out, thanks
    – Pekka
    Commented Feb 2, 2011 at 11:45
  • Not parsable, but the default search queries would be (1) user:me is:question and (2) user:me is:answer.
    – Werner
    Commented Aug 27, 2014 at 5:37

1 Answer 1


I have created a query on SEDE, which creates a list of parsable links to all your questions and answers on all supported Stack Exchange sites. You just have to input your Stack Exchange Account ID (not User ID) and you can download the links in a CSV file.

How it works

The idea is fairly simple. The query loops through all available databases available on SEDE and fetches any posts created by you, as your Account ID is identical for all databases. It then uses the database name, post type, and post ID to create a link for every post.


declare @AccountId int = ##AccountId:int##

-- Select all valid databases.
select dbid, name
into #dbs
from master..sysdatabases
where name not in ('Data.StackExchange', 'master', 'model', 'msdb', 'tempdb')

-- Loop through databases.
create table #posts (db varchar(40), site varchar(40), PostTypeId int, Id int)
declare @id int, @db varchar(40), @site varchar(50), @sql nvarchar(max),
        @tmp varchar(40), @start int, @end int
while (select count(*) from #dbs) > 0
  select top 1 @id = dbid, @db = name from #dbs

  -- Database name to host url (e.g. StackExchange.Stats.Meta to meta.stats.stackexchange)
  set @tmp = lower(@db)
  set @site = ''
  while len(@tmp) > 0
    set @start = 0
    while charindex('.', @tmp, @start+1) <> 0
      set @start = charindex('.', @tmp, @start+1)
    set @site += '.' + substring(@tmp, @start+1, len(@tmp))
    set @tmp = left(@tmp, case @start when 0 then 0 else @start - 1 end)
  -- Fetch each post in database by user.
  set @sql = '
    insert into #posts
      ''' + @db + ''' as db,
      substring(''' + @site + ''', 2, len(''' + @site + ''')) as site,
    from [' + @db + ']..[Posts] p
    inner join [' + @db + ']..[Users] u 
    on p.OwnerUserId = u.Id and u.AccountId = ' + cast(@AccountId as varchar(20)) + '
    where PostTypeId in (1, 2)
  delete from #dbs where dbid = @id

-- Print out list of links.
  'http://' + site + case when db in ('MathOverflow') then '.net/' else '.com/' end +
  case when PostTypeId=1 then 'q/' else 'a/' end +
  cast(Id as varchar(20)) + 
from #posts
order by PostTypeId, db

You must log in to answer this question.

Not the answer you're looking for? Browse other questions tagged .