/**
* get a limitted amount of search results for a requested page
* @return array Array containing a limitted (one page) amount of search results
*/
public function getSearchResultByMySQL()
{
$queryParts = $this->getQueryParts();
// log query
if ($this->conf['logQuery']) {
$query = $GLOBALS['TYPO3_DB']->SELECTquery($queryParts['SELECT'], $queryParts['FROM'], $queryParts['WHERE'], $queryParts['GROUPBY'], $queryParts['ORDERBY'], $queryParts['LIMIT']);
TYPO3\CMS\Core\Utility\GeneralUtility::devLog('Search result query', $this->pObj->extKey, 0, array($query));
}
$this->searchResults = $GLOBALS['TYPO3_DB']->exec_SELECTgetRows($queryParts['SELECT'], $queryParts['FROM'], $queryParts['WHERE'], $queryParts['GROUPBY'], $queryParts['ORDERBY'], $queryParts['LIMIT'], 'uid');
$result = $GLOBALS['TYPO3_DB']->sql_query('SELECT FOUND_ROWS();');
if ($result) {
$data = $GLOBALS['TYPO3_DB']->sql_fetch_row($result);
$GLOBALS['TYPO3_DB']->sql_free_result($result);
$this->numberOfResults = $data[0];
}
}
