CAllSocNetLogCounter::GetList

static function GetList($arFilter = Array(), $arSelectFields = [])
{
	global $DB;

	if (count($arSelectFields) <= 0)
	{
		$arSelectFields = array("LAST_DATE", "PAGE_SIZE", "PAGE_LAST_DATE_1");
	}

	// FIELDS -->
	$arFields = array(
		"USER_ID" => Array("FIELD" => "SLC.USER_ID", "TYPE" => "int"),
		"SITE_ID" => Array("FIELD" => "SLC.SITE_ID", "TYPE" => "string"),
		"CODE" => Array("FIELD" => "SLC.CODE", "TYPE" => "string"),
		"LAST_DATE" => Array("FIELD" => "SLC.LAST_DATE", "TYPE" => "datetime"),
		"PAGE_SIZE" => array("FIELD" => "SLC.PAGE_SIZE", "TYPE" => "int"),
		"PAGE_LAST_DATE_1" => Array("FIELD" => "SLC.PAGE_LAST_DATE_1", "TYPE" => "datetime"),
	);
	// <-- FIELDS

	$arSqls = CSocNetGroup::PrepareSql($arFields, array(), $arFilter, false, $arSelectFields);

	$arSqls["SELECT"] = str_replace("%%_DISTINCT_%%", "", $arSqls["SELECT"]);

	$strSql =
		"SELECT ".$arSqls["SELECT"]." ".
		"FROM b_sonet_log_counter SLC ".
		"	".$arSqls["FROM"]." ";

	if ($arSqls["WHERE"] <> '')
	{
		$strSql .= "WHERE ".$arSqls["WHERE"]." ";
	}

	return $DB->Query($strSql, false, "File: ".__FILE__."
Line: ".__LINE__);
}