Posts with possible code formatting issues

2

Please login or register to vote for this query.

(click on this box to dismiss)

Finds posts containing a line feed followed by `}</p>`. This is usually a telltale sign of improperly formatted code in posts. Thanks to Arjan for helping with this query on Meta Stack Overflow: http://meta.stackoverflow.com/questions/110706/is-there-a-way-to-prevent-data-explorer-from-ignoring-whitespace-in-query-parame/110743#110743

Emacs

Q&A for those using, extending or developing Emacs

-- Posts with possible code formatting issues
-- Finds posts containing a line feed followed by `}</p>`.
-- 
-- This is usually a telltale sign of improperly formatted code in posts.
-- 
-- Thanks to Arjan for helping with this query on Meta Stack Overflow:
-- 
-- http://meta.stackoverflow.com/questions/110706/is-there-a-way-to-prevent-data-explorer-from-ignoring-whitespace-in-query-parame/110743#110743

select

--count(id), --oh god there are so many D:
top 50 id as [Post Link], creationdate

from posts
where Body like '%' + char(10) + '}</p>%'
and creationdate >= '2009-07-01' --current progress
and creationdate <= '2009-08-01'

Enter Parameters

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