Unresolved pending duplicate comments


Please login or register to vote for this query.

(click on this box to dismiss)

Stack Overflow

Q&A for professional and enthusiast programmers

select Comments.Id as [Comment Link] from Comments 
join Posts on Posts.Id =Comments.PostId
where Text like concat('%',##why:string##,'%')
and Text like '%gaming.stackexchange.com%'
and Posts.PostTypeId = 1
and ClosedDate is null
and not exists (select 1 from ReviewTasks where ReviewTasks.PostId=Posts.Id
 and ReviewTaskTypeId = 2 -- and ReviewTaskStateId=3

Enter Parameters

Switch to meta site
loading Hold tight while we fetch your results