How would I do something like this using DataObject::get() ?
SELECT category.title, COUNT(article_categories.ArticleID) as totalArticles FROM article_categories, category WHERE article_categories.CategoryID = category.ID GROUP BY category.title
The purpose of this is to display the categories and the amount of related articles to them.
I know how to do it in normal php & mysql but I'm a bit stuck in how to go with it the ss-way...
thnx