select article.id, titie, (select count(*) from comment where article.id = comment.id) as pl from article order by pl desc;