Posts with potentially unescaped HTML tags

0

Please login or register to vote for this query.

(click on this box to dismiss)

Cardano Meta

Q&A for users and developers of the Cardano cryptocurrency ecosystem

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 main site
loading Hold tight while we fetch your results