Posts with potentially unescaped HTML tags

0

Please login or register to vote for this query.

(click on this box to dismiss)

The Workplace Meta

Q&A about the site for members of the workforce navigating the professional setting

SELECT top 384 'https://stackoverflow.com/posts/'+cast(PostId as varchar(11))+'/edit'
FROM PostHistory
WHERE (PostHistoryTypeId=2 or PostHistoryTypeId=5)
-- // The newest (since this week)
and PostID>=32006933
-- // These are older ones we haven't done yet
-- and PostID<=39280632 and PostID>=37447535
-- and UserId=4820542
-- and PostID>=5157596 and UserId=22656
-- and Text like N'% <%'
-- and (Text like N'%[a-z0-9/]> tag%'
 --or Text like N'%[a-z0-9/]> element%'
 --or Text like N'%[a-z0-9/]> start tag%'
 -- Text like N'%[a-z0-9/]> end tag%'
 -- Text like N'%[a-z0-9/]> or %'
 -- Text like N'%[a-z,;:][ (]<[a-z]>[.,;?! ):]%'
 --or Text like N'%[a-z,;:][ (]<[a-z][a-z0-9/]>[.,;?! ):]%'
 --or Text like N'%[a-z,;:][ (]<[a-z][a-z ][a-z0-9/]>[.,;?! ):]%'
 --or Text like N'%[a-z,;:][ (]<[a-z][a-z][a-z ][a-z0-9/]>[.,;?! ):]%'
 --or Text like N'%[a-z,;:][ (]<[a-z][a-z][a-z][a-z ][a-z0-9/]>[.,;?! ):]%'
 --or Text like N'%[a-z,;:][ (]<[a-z][a-z][a-z][a-z][a-z ][a-z0-9/]>[.,;?! ):]%'
 --or Text like N'%[a-z,;:][ (]<[a-z][a-z][a-z][a-z][a-z][a-z ][a-z0-9/]>[.,;?! ):]%'
 --or Text like N'%[a-z,;:][ (]<[a-z][a-z][a-z][a-z][a-z][a-z][a-z ][a-z0-9/]>[.,;?! ):]%'
 --or Text like N'%[a-z,;:][ (]<[a-z][a-z][a-z][a-z][a-z][a-z][a-z][a-z ][a-z0-9/]>[.,;?! ):]%'
 --or Text like N'%[a-z,;:][ (]<[a-z][a-z][a-z][a-z][a-z][a-z][a-z][a-z][a-z ][a-z0-9/]>[.,;?! ):]%'
--)
GROUP BY PostId
ORDER BY PostId desc

Enter Parameters

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