Posts with broken breaks


Please login or register to vote for this query.

(click on this box to dismiss)

Drupal Answers Meta

Q&A about the site for Drupal developers and administrators

-- I caused this mess, sorry everyone

WITH LatestBodyRevision (PostId, PostHistoryId) AS (
     SELECT p.Id, ph.Id AS PostHistoryId
     FROM Posts p
     INNER JOIN PostHistory ph ON ph.PostId = p.Id
     WHERE ph.PostHistoryTypeId IN (2,5,8) 
           SELECT * FROM PostHistory phtwo
           WHERE phtwo.PostHistoryTypeId IN (2,5,8) AND 
                 phtwo.PostId = p.Id AND 
                 phtwo.CreationDate > ph.CreationDate

SELECT lbr.PostId AS [Post Link]
FROM LatestBodyRevision lbr 
INNER JOIN PostHistory ph ON lbr.PostHistoryId = ph.Id
INNER JOIN Posts p ON lbr.PostId = p.Id
WHERE ph.Text LIKE '%<\%break\%>%' ESCAPE '\'
   OR ph.Text LIKE '%<\%\%>%' ESCAPE '\'
ORDER BY p.LastActivityDate DESC

Enter Parameters

Switch sites:
loading Hold tight while we fetch your results