Shortest posts

0

Please login or register to vote for this query.

(click on this box to dismiss)

Music Fans Meta

Q&A about the site for music historians, critics, and fans

select u.id, u.displayname, p.id, p.body, p.creationdate
  from ( select top 10 id, body, creationdate, owneruserid
           from posts
          where posttypeid = 2
           order by len(body) asc ) p
  join users u
    on p.owneruserid = u.id

Enter Parameters

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