SELECT blogname,count(postid) AS p FROM posts GROUP BY blogname ORDER BY  p