Finds instances of "<pre>[line feed character]<code>" (the result of using hacky HTML instead of Markdown)
Q&A for professional and enthusiast programmers
-- Posts with possibly misformatted code -- finds instances of "<pre><code>" (the result of using hacky HTML instead of Markdown) select top 500 id as [Post Link], creationdate from posts where (body like '%<pre>' + CHAR(10) + '<code>%')