Top 100 shortest posts

0

Please login or register to vote for this query.

(click on this box to dismiss)

(questions or answers only)

Drupal Answers Meta

Q&A about the site for Drupal developers and administrators

-- Top 100 shortest posts
-- (questions or answers only)

select top 100
len(body) as "Length",
id as [Post Link],
body as "Body",
creationdate as "Creation Date"
from posts
where posttypeid = 1 or posttypeid = 2
order by len(body) asc

Enter Parameters

Options:
Switch to main site
loading Hold tight while we fetch your results