Posts with Possibly Malformed Markdown Headers

1

Please login or register to vote for this query.

(click on this box to dismiss)

Emacs

Q&A for those using, extending or developing Emacs

select 
  CONCAT('site://q/', q.id, '|', CASE
    WHEN q.ParentId IS NULL
    THEN q.title
    ELSE CONCAT('A: ', parent.title)
    END
  ) AS [Link],
  q.CreationDate
from Posts q
LEFT JOIN Posts parent ON parent.Id = q.ParentId
where 
(
  q.body like concat('%', nchar(10), '<p>###[^ ]%' , nchar(10), '%')
  or q.body like concat('%', nchar(10), '<p>##[^ ]%' , nchar(10), '%')
  or q.body like concat('%', nchar(10), '<p>#[^ ]%' , nchar(10), '%')
)
AND q.CreationDate < '20200620' -- Last site migrated to CommonMark

Enter Parameters

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