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.Id AS [Post Link]
FROM Posts p, PostHistory ph
     
WHERE ph.PostId = p.Id AND
      PostHistoryTypeId in (2,5)
      AND (ph.Text LIKE '%<code>%' OR
           ph.Text LIKE '%<pre>%')  
ORDER BY p.ViewCount DESC

Enter Parameters

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