CIBlockSectionRights::GetList

function GetList($arFilter)
{
	global $DB;

	$obQueryWhere = new CSQLWhere;
	$obQueryWhere->SetFields(array(
		"IBLOCK_ID" => array(
			"TABLE_ALIAS" => "SR",
			"FIELD_NAME" => "SR.IBLOCK_ID",
			"MULTIPLE" => "N",
			"FIELD_TYPE" => "int",
			"JOIN" => false,
		),
		"ITEM_ID" => array(
			"TABLE_ALIAS" => "SR",
			"FIELD_NAME" => "SR.SECTION_ID",
			"MULTIPLE" => "N",
			"FIELD_TYPE" => "int",
			"JOIN" => false,
		),
	));

	$strWhere = $obQueryWhere->GetQuery($arFilter);

	return $DB->Query("
		SELECT
			SR.SECTION_ID ITEM_ID
			,BR.ID RIGHT_ID
			,BR.GROUP_CODE
			,BR.TASK_ID
			,BR.DO_INHERIT
			,SR.IS_INHERITED
			,BR.XML_ID
		FROM
			b_iblock_section_right SR
			INNER JOIN b_iblock_right BR ON BR.ID = SR.RIGHT_ID
		".($strWhere? "WHERE ".$strWhere: "")."
		ORDER BY
			BR.ID
	");
}