0

Please login or register to vote for this query.

(click on this box to dismiss)

Q&A for linguists, teachers, and students wanting to discuss the finer points of the Latin language

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>=44223606
-- // 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

view current version

edited jun 11 17 Mr Lister

created nov 17 15 anonymous