select typename,typedir, count(*) as count from dede_arctype group by typedir order by count desc

本文转自 gutaotao1989 51CTO博客，原文链接:http://blog.51cto.com/taoyouth/1765409