What is the best way to fetch the 10 mostly newly updated pages?
I know I can probably run a SQL statement against the table:
SELECT ID FROM sf_pagecontentbase ORDER BY DateModified DESC LIMIT 10
I'm guessing there is a better way to do this though. I also thought about doing a:
|CmsManager manager = new CmsManager(); |
|IList ourPages = manager.GetPages(); |
And then sorting that IList.
Any advice would be welcome.