Q&A for professional and enthusiast programmers
select top 100 p.id as [Post Link] from posts p inner join posts q on q.id = coalesce(p.parentid, p.id) inner join posthistory ph on ph.postid = p.id where text like '%```%' and ph.posthistorytypeid in (2,5,8) and p.creationdate between ##start:string## and ##end:string## and q.tags not like '%<r>%' and q.tags not like '%<rmarkdown>%'