- $term_condition = ["`term` = ? AND `otype` = ? AND `type` = ? AND `uid` = ?",
- $file, Term::OBJECT_TYPE_POST, Term::FILE, local_user()];
- $term_params = ['order' => ['tid' => true], 'limit' => [$pager->getStart(), $pager->getItemsPerPage()]];
- $result = DBA::select('term', ['oid'], $term_condition, $term_params);
+ $item_params = ['order' => ['uri-id' => true]];
+ $term_condition = ['name' => $file, 'type' => Category::FILE, 'uid' => local_user()];
+ $term_params = ['order' => ['uri-id' => true], 'limit' => [$pager->getStart(), $pager->getItemsPerPage()]];
+ $result = DBA::select('category-view', ['uri-id'], $term_condition, $term_params);