CHit::GetByID

static function GetByID($ID)
{
	$err_mess = "File: ".__FILE__."
Line: ";
	$DB = CDatabase::GetModuleConnection('statistic');
	$ID = intval($ID);
	$res = $DB->Query("
		SELECT
			H.*,
			".$DB->DateToCharFunction("H.DATE_HIT")." DATE_HIT,
			C.NAME COUNTRY_NAME,
			CITY.REGION REGION_NAME,
			CITY.NAME CITY_NAME
		FROM
			b_stat_hit H
			INNER JOIN b_stat_country C ON (C.ID = H.COUNTRY_ID)
			LEFT JOIN b_stat_city CITY ON (CITY.ID = H.CITY_ID)
		WHERE
			H.ID = '$ID'
	", false, $err_mess.__LINE__);

	$res = new CStatResult($res);
	return $res;
}