0

Please login or register to vote for this query.

(click on this box to dismiss)

Q&A for professional and enthusiast programmers

select Id as [Comment Link], UserId as [User Link] from Comments where text like '%invalid%' and (select PostTypeId from Posts where Id=PostId)=2 order by CreationDate desc;
select Id as [Comment Link], UserId as [User Link] from Comments where text like '%delet%' and (select PostTypeId from Posts where Id=PostId)=2 order by CreationDate desc;
select Id as [Comment Link], UserId as [User Link] from Comments where text like '%wrong%' and (select PostTypeId from Posts where Id=PostId)=2 order by CreationDate desc;
select Id as [Comment Link], UserId as [User Link] from Comments where text like '%incorrect%' and (select PostTypeId from Posts where Id=PostId)=2 order by CreationDate desc;
select Id as [Comment Link], UserId as [User Link] from Comments where text like '%fail%' and (select PostTypeId from Posts where Id=PostId)=2 order by CreationDate desc;
select Id as [Comment Link], UserId as [User Link] from Comments where text like '%serious contender%' and (select PostTypeId from Posts where Id=PostId)=2 order by CreationDate desc;
select Id as [Comment Link], UserId as [User Link] from Comments where text like '%allowed%' and (select PostTypeId from Posts where Id=PostId)=2 order by CreationDate desc;

fork query

edited nov 22 21

created jun 17 20 Pppery