Posts with potentially unescaped HTML tags

0

Please login or register to vote for this query.

(click on this box to dismiss)

Computer Science Educators

Q&A for those involved in the field of teaching Computer Science

SELECT top 384 'https://stackoverflow.com/posts/'+cast([Posts].ID as varchar(11))+'/edit'
FROM PostHistory
JOIN [Posts] on [Posts].ID=PostHistory.PostID
WHERE (PostHistoryTypeId=2 or PostHistoryTypeId=5)
and PostID>=61567000
and Text like N'%orry for my english%'
GROUP BY [Posts].ID
ORDER BY [Posts].ID desc

Enter Parameters

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