How I can get questions where the body is the same as the title?

Question

It is know that many questions have the same body and title, So I wanted to create a query to show them all, but this don't work :

select
   Posts.id as [Post Link], -- Question title.
   Count(PendingFlags.PostId) as [Number of pending flags], -- Number of pending flags per questions.
   Posts.OwnerUserId as [User Link],
   Reputation as [User Reputation], -- Interesting to see that such questions are sometimes asked by high rep users.
   Posts.Score as [Votes],
   Posts.ViewCount,
   Posts.AnswerCount as [Number of Answers],
   Posts.FavoriteCount as [Number of Stars], -- Some questions seems to be very helpfull :) .
   Posts.CreationDate as [Asked on], -- The older is the question, the more is the chance that flags on them can't get reviewed.
   Posts.LastActivityDate as [last activity], -- Similar effect as with Posts.CreationDate.
   Posts.LastEditDate as [modified on]
from posts 
   LEFT OUTER JOIN Users on Users.id = posts.OwnerUserId
   LEFT OUTER JOIN PendingFlags on PendingFlags.PostId = Posts.Id
where ClosedDate IS NULL -- The question is not closed.
   AND LOWER(body) = LOWER(Posts.title) -- This condition doesn't work : the query doesn't return any results...
group by Posts.id, Posts.OwnerUserId, body, Reputation, Posts.Score, Posts.FavoriteCount, Posts.AnswerCount, Posts.CreationDate, Posts.LastActivityDate, Posts.LastEditDate, Posts.ViewCount
order by Count(PendingFlags.PostId) desc; -- Questions with more flags have more chance to get them handled, and the higher is the probabilty that the question is off-topic (since several users already reviewed the question).

Answer 1

As said in the comments to animusons's answer, the rendered version of the body without tags can be found in the PostHistory table. You have to select the most recent entry with a postHistoryTypeId that is either 2 (initial body), 5 (edited body), or 8 (body rollback).

Here is a query that fetches the raw-text body using this approach to find all questions where the body is the same as the title (which returns a table of more than 3000 posts on Stack Overflow):

SELECT p.Id AS [Post Link], p.Body
FROM (
  SELECT * FROM Posts
  WHERE PostTypeId = 1
    AND LEN(Body) < LEN(Title) + 30
    AND LEN(Body) > LEN(Title)
) p
INNER JOIN (
  SELECT ph1.* FROM PostHistory ph1
  INNER JOIN (
    SELECT PostId, MAX(CreationDate) AS CreationDate
    FROM PostHistory
    WHERE PostHistoryTypeId IN (2,5,8)
    GROUP BY PostId
  ) ph2
  ON ph1.PostId = ph2.PostId AND ph1.CreationDate = ph2.CreationDate
  WHERE PostHistoryTypeId IN (2,5,8)
) ph
ON p.Id = ph.PostId
WHERE LOWER(p.Title) = LOWER(ph.Text)
ORDER BY Title

Answer 2

That's because the Body contains the rendered version of the text. So even if they copy-paste the Title into the Body, it is at minimum going to be surrounded in a paragraph and end up looking like <p>Body</p>. If there are some other formatting things in the Title that don't get rendered in the Title but do get rendered in the Body, those will also produce some differences.