Posts with <code> or <pre> tags

0

Please login or register to vote for this query.

(click on this box to dismiss)

finds posts that currently contain <code> or <pre> in raw markdown ideally indenting or backticks should be used instead

Ask Ubuntu

Q&A for Ubuntu users and developers

SELECT p.Title AS [Title],
       p.Id AS [Post Link]
       --,c.Text AS [HTML]
FROM Posts p
     JOIN Comments c ON c.PostId = p.Id
WHERE (
       PostTypeId = 1 OR
       PostTypeID = 2
      )
      AND (
           p.Body LIKE '%<code>%' OR
           c.Text LIKE '%<code>%'
          )
ORDER BY p.ViewCount ASC

Enter Parameters

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