Set what field the query will count() on for paging.
public function setCountField($table, $field, $alias = NULL) { if (empty($alias)) { $alias = $table . '_' . $field; } $this->count_field = [ 'table' => $table, 'field' => $field, 'alias' => $alias, 'count' => TRUE, ]; }