0

Please login or register to vote for this query.

(click on this box to dismiss)

Q&A for Ubuntu users and developers

select q.Id as [Post Link], q.Score as [Question Score], a.Score as [Answer Score] from Posts q
inner join Posts a on a.ParentId = q.Id
where q.ClosedDate is not null
and a.OwnerUserId = ##UserId##
and q.AcceptedAnswerId is null
and q.Score <= 0 
and q.Id not in (select PostId from PostLinks) 
order by q.ClosedDate desc

fork query

created jun 28 22 anonymous