3

May be it is trivial, however I try to write query which find questions without my answers, and I fail (so question can already have other peoples answers but not my). This is what I try so far:

select
  q.Id,
  q.Id AS [Post Link],
  q.Tags,
  COUNT(*) as AnsCount2
from
    Posts q
  inner join
    Posts a
  on a.parentId = q.Id
where
      a.OwnerUserId != 860099
  and a.postTypeId = 2
  and q.ClosedDate IS NULL
GROUP BY q.Id, q.Tags
ORDER BY q.Id ASC offset 70 rows fetch next 10 rows only

My UserId=860099 When I run above query at offser(row) 72 I get this question (id=657) - which contains my answer... :( . How to fix it?

2
  • Are you talking about in the search bar on top - as a inverse of user: 346998 ?
    – Journeyman Geek Mod
    Dec 12, 2019 at 7:56
  • no I ask about query Dec 12, 2019 at 7:59

1 Answer 1

4

There's no search operator supporting this, so you have to resort to e.g. the Stack Exchange Data Explorer. This SEDE query is an attempt; since its output is limited to 50,000 records you won't find every Stack Overflow question you didn't answer.

enter image description here

Note that SEDE is updated once a week, on Sunday morning, so you might have already answered the question in the meantime. If you're interested, take the awesome tutorial and fork the query to filter e.g. on tags you're interested in.

You must log in to answer this question.

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