Specifying the user:<id> option to the search string allows you to search for posts written by specified user. That also includes the wiki posts, which are considered community owned (almost everyone could modify them). But I was surprised that searching by user doesn't work for deleted users, despite of the fact that user id is still visible on the user card:

deleted user

Could the searching for posts made by currently deleted user be possible? Is there a reason to don't allow it?

One possible usecase is when the user with a lot of useful posts decides to delete your account, and you will be able to search for they posts though.

  • Oh ... somebody doesn't want this feature, but why? Too hard to implement? I see you lazy developer! Jan 23, 2019 at 15:45
  • Somewhat tangential, but see also my argument on MSO that CW posts aren't community-owned. Jan 23, 2019 at 18:48
  • @SonictheIntrovertedHedgehog it seems that real reason to decline is posted in this comment: "none of that is pulled into the search index, and even that is partial string searching, not an efficient int match. – Nick Craver♦" Jan 24, 2019 at 10:57
  • Your request doesn't bring in any new counter-arguments to the declining reason to implement this, and it's declined for technical reasons. Jan 24, 2019 at 10:59
  • @SonictheIntrovertedHedgehog I no longer believe that I will hear on SE: "Yes, we need this feature, it is worth it to implement" ... "despite of our imperfect architecture" Jan 24, 2019 at 11:06

1 Answer 1


Until this gets implemented you can use this SEDE Query

select p.id as [Post Link]
     , p.score
     , q.viewcount
     , p.creationdate
     , case p.posttypeid 
       when 1 then 
               , case 
                 when q.closeddate is not null then ' [closed]' 
                 else '' 
       when 2 then
         , case 
           when q.acceptedanswerid = p.id then ' [accepted]' 
           else ''
       else '?' 
       end [Question/Answer]
from posts p
inner join posts q on q.id = coalesce(p.parentid, p.id) 
where p.ownerdisplayname = ##displayname:string?user218976##

When run today your result will look this:

sql result for posts based on displayname

SEDE is updated once a week, on Sunday around 03:00 UTC.

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