public static function getList() { $db = Loader::db(); $r = $db->query("select Pages.cID from Pages inner join Collections on Pages.cID = Collections.cID where cFilename is not null and ctID = 0 order by cDateModified desc"); $pages = array(); while ($row = $r->fetchRow()) { $p = new SinglePage; $p->populatePage($row['cID'], 'where Pages.cID = ?', 'RECENT'); $pages[] = $p; } return $pages; }