Statistics::getChainList

public function getChainList($limit = 20)
{
	$filter = $this->getMappedFilter();
	$listDb = PostingTable::getList(array(
		'select' => array(
			'MAX_DATE_SENT',
			'CHAIN_ID' => 'MAILING_CHAIN_ID',
			'TITLE' => 'MAILING_CHAIN.TITLE',
			'MAILING_ID',
			'MAILING_NAME' => 'MAILING.NAME',
		),
		'filter' => $filter,
		'runtime' => array(
			new ExpressionField('MAX_DATE_SENT', 'MAX(%s)', 'DATE_SENT'),
		),
		//'group' => array('CHAIN_ID', 'TITLE', 'SUBJECT', 'MAILING_ID', 'MAILING_NAME'),
		'order' => array('MAX_DATE_SENT' => 'DESC'),
		'limit' => $limit,
		'cache' => array('ttl' => $this->getCacheTtl(), 'cache_joins' => true)
	));
	$list = array();
	while ($item = $listDb->fetch())
	{
		$dateSentFormatted = '';
		if ($item['MAX_DATE_SENT'])
		{
			$dateSentFormatted = FormatDate('x', $item['MAX_DATE_SENT']->getTimestamp());
		}

		$list[] = array(
			'ID' => $item['CHAIN_ID'],
			'NAME' => $item['TITLE'] ? $item['TITLE'] : $item['SUBJECT'],
			'MAILING_ID' => $item['MAILING_ID'],
			'MAILING_NAME' => $item['MAILING_NAME'],
			'DATE_SENT' => (string) $item['MAX_DATE_SENT'],
			'DATE_SENT_FORMATTED' => $dateSentFormatted,
		);
	}
	return $list;
}