0

Please login or register to vote for this query.

(click on this box to dismiss)

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
);

fork query

edited dec 17 22

created may 24 21 Pppery