public function getByAppID__300_applinks($app_id, $activeonly = true) { $query = new Query('SELECT'); $query->where('lnk.app_id = ?', $app_id); if ($activeonly) { $query->where('lnk.active = ?', 1); } $query->orderby('lnk_ver.intversion', 'DESC'); $query->orderBy('lnk.date_added', 'DESC'); return AppLinkBean::select($query, array('version' => false, 'submitter' => false)); }