Added TeX markup

0

Please login or register to vote for this query.

(click on this box to dismiss)

Identify edits which add $…$ to a post which didn't contain them before. The assumption is that many of these edits will be adding TeX-style math formatting (for the sites which support this). The JSON links can be used to get a look at the data representation one can get from the API. Crawling them will exhaust API quotas quickly, and in terms of performance it would be better to fetch them in bunches of 20 per request.

Mathematics

Q&A for people studying math at any level and professionals in related fields

-- Site: Name of site (domain or abbreviated) "used for JSON API links"
-- see https://api.stackexchange.com/docs/sites#pagesize=9999&filter=!*L1-8Dpi4jedaam(
declare @site varchar = ##Site:string?math##

declare @begin datetime = dateadd(day, -14, sysdatetime())

select
  B.CreationDate as Date,
  concat('site://posts/', B.PostId, '/revisions#rev-arrow-',
         lower(B.RevisionGUID), '|', B.Comment) as Revision,
  -- see https://api.stackexchange.com/docs/revisions-by-guids#filter=!)Q.zgYBzk8thF*IUUYCw8H*j&site=math
  concat('http://api.stackexchange.com/2.2/revisions/',
         B.RevisionGUID, '?site=math&filter=%21%29Q.zgYBzk8thF%2AIUUYCw8H%2Aj',
         '|JSON') as API
from PostHistory A, PostHistory B,
 (select max(A.Id) as a, B.Id as b
  from PostHistory A, PostHistory B
  where A.PostId = B.PostId
    and A.Id < B.Id
    and A.CreationDate > @begin
    and B.CreationDate > @begin
    and A.PostHistoryTypeId in (2, 5, 8)
    and B.PostHistoryTypeId = 5
  group by B.Id) E
where A.Id = E.a
  and B.Id = E.b
  and A.Text not like '%$%'
  and B.Text like '%$%$%'
order by B.CreationDate desc

Enter Parameters

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