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
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?