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