CSession::GetByID

static function GetByID($ID)
{
	$statDB = CDatabase::GetModuleConnection('statistic');
	$ID = intval($ID);

	$res = $statDB->Query("
		SELECT
			S.*,
			UNIX_TIMESTAMP(S.DATE_LAST) - UNIX_TIMESTAMP(S.DATE_FIRST) SESSION_TIME,
			".$statDB->DateToCharFunction("S.DATE_FIRST")." DATE_FIRST,
			".$statDB->DateToCharFunction("S.DATE_LAST")." DATE_LAST,
			C.NAME COUNTRY_NAME,
			CITY.REGION REGION_NAME,
			CITY.NAME CITY_NAME
		FROM
			b_stat_session S
			INNER JOIN b_stat_country C ON (C.ID = S.COUNTRY_ID)
			LEFT JOIN b_stat_city CITY ON (CITY.ID = S.CITY_ID)
		WHERE
			S.ID = ".$ID."
	");

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