CSearcher::GetGraphArray_SQL

static function GetGraphArray_SQL($strSqlSearch)
{
	$DB = CDatabase::GetModuleConnection('statistic');
	$strSql = "
		SELECT
			".$DB->DateToCharFunction("D.DATE_STAT","SHORT")." DATE_STAT,
			DAYOFMONTH(D.DATE_STAT) DAY,
			MONTH(D.DATE_STAT) MONTH,
			YEAR(D.DATE_STAT) YEAR,
			D.SEARCHER_ID,
			D.TOTAL_HITS,
			C.NAME
		FROM
			b_stat_searcher_day D
		INNER JOIN b_stat_searcher C ON (C.ID = D.SEARCHER_ID)
		WHERE
			$strSqlSearch
		ORDER BY
			D.DATE_STAT, D.SEARCHER_ID
		";
	return $strSql;
}