Top 100 shortest post lengths

0

Please login or register to vote for this query.

(click on this box to dismiss)

(questions or answers only) shows the latest creation date for each length ordered by count of posts for each length

Drupal Answers Meta

Q&A about the site for Drupal developers and administrators

-- Top 100 shortest post lengths
-- (questions or answers only)
-- shows the latest creation date for each length
-- ordered by count of posts for each length

select top 100
count(id) as "Count",
len(body) as "Length",
max(creationdate) as "As recently as"
from posts
where posttypeid = 1 or posttypeid = 2
group by len(body)
order by len(body) asc

Enter Parameters

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