Find the # of items in SharePoint lists

SELECT TOP (10) tp_DirName, COUNT(tp_DirName) AS FolderItemsCount FROM AllUserData
GROUP BY tp_DirName
ORDER BY FolderItemsCount DESC