Posts with possible code formatting issues

0

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

Startups Meta

Q&A for entrepreneurs faced with delivering a new product or service under conditions of significant uncertainty

-- 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>%'

Enter Parameters

Options:
Switch sites:
loading Hold tight while we fetch your results