1

Please login or register to vote for this query.

(click on this box to dismiss)

Q&A for linguists, etymologists, and serious English language enthusiasts

Select Distinct I.PostId as [Post Link]
--, I.Text As originalTags, E.Text As editedTags 
From 
( Select *
From PostHistory
Where PostHistoryTypeId = 3
) I
Inner Join
(Select *
From PostHistory
Where PostHistoryTypeId = 6) E
On I.PostId = E.PostId
Where I.Text Like '%grammer%'
Or I.Text Like '%grammar%'
And E.Text Not Like '%grammar%';

fork query

edited jul 30 14 Andrew Leach

created jul 30 14 anonymous