CLAnswer::getMultiStats

static function getMultiStats($arIds)
{
	global $DB;

	if ( ! is_array($arIds) )
		return (false);

	$arResult = array();

	$arIds = array_filter($arIds);

	if ( ! empty($arIds) )
	{
		$arIds = array_map('intval', $arIds);

		$strSql = "SELECT QUESTION_ID, COUNT(*) AS ALL_CNT, SUM(CASE WHEN CORRECT = 'Y' THEN 1 ELSE 0 END) AS CORRECT_CNT 
			FROM b_learn_test_result 
			WHERE ANSWERED = 'Y' AND QUESTION_ID IN (" . implode(',', $arIds) . ")
			GROUP BY QUESTION_ID ";

		$rsStat = $DB->Query($strSql, false, "File: " . __FILE__ . "
Line: " . __LINE__);
		while ($arStat = $rsStat->fetch())
		{
			$arResult[$arStat['QUESTION_ID']] = array(
				'ALL_CNT'     => (int) $arStat['ALL_CNT'],
				'CORRECT_CNT' => (int) $arStat['CORRECT_CNT']
			);
		}
	}

	return ($arResult);
}