CStatEventType::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.COUNTER,
			D.MONEY,
			D.EVENT_ID,
			E.NAME,
			E.EVENT1,
			E.EVENT2
		FROM
			b_stat_event_day D
		INNER JOIN b_stat_event E ON (E.ID = D.EVENT_ID)
		WHERE
			$strSqlSearch
		ORDER BY
			D.DATE_STAT, D.EVENT_ID
		";
	return $strSql;
}