function getObjectInfo($sorting_fields, $inner_join = false, $relevance = false) { $searchSqlTranslator = new SJB_SearchSqlTranslator($this->table_prefix); $sql_string = $searchSqlTranslator->buildSqlQuery($this->criteria, $this->valid_criterion_number, array($this->sorting_field => $this->sorting_order), $this->inner_join); SJB_DB::query($sql_string); $this->affectedRows = SJB_DB::getAffectedRows(); if ($this->limit !== false) { if (isset($this->limit['limit'])) { $sql_string .= " limit " . $this->limit['limit'] . ", " . $this->limit['num_rows']; } else { $sql_string .= " limit " . $this->limit . ", 100"; } } return SJB_DB::query($sql_string); }