CAllGuest::GetByID

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

	$res = $DB->Query("
		SELECT
			G.*,
			".$DB->DateToCharFunction("G.FIRST_DATE")." FIRST_DATE,
			".$DB->DateToCharFunction("G.LAST_DATE")." LAST_DATE,
			".CStatistics::DBDateDiff("FS.DATE_LAST","FS.DATE_FIRST")." FSESSION_TIME,
			".CStatistics::DBDateDiff("LS.DATE_LAST","LS.DATE_FIRST")." LSESSION_TIME,
			FS.HITS FSESSION_HITS,
			LS.HITS LSESSION_HITS,
			C.NAME COUNTRY_NAME,
			CITY.REGION REGION_NAME,
			CITY.NAME CITY_NAME,
			G.LAST_CITY_INFO
		FROM
			b_stat_guest G
			INNER JOIN b_stat_country C ON (C.ID = G.LAST_COUNTRY_ID)
			LEFT JOIN b_stat_session FS ON (FS.ID = G.FIRST_SESSION_ID)
			LEFT JOIN b_stat_session LS ON (LS.ID = G.LAST_SESSION_ID)
			LEFT JOIN b_stat_city CITY ON (CITY.ID = G.LAST_CITY_ID)
		WHERE
			G.ID = '$ID'
	", false, "File: ".__FILE__."
Line: ".__LINE__);

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