$q->select('amount,title,status,order_id')
            ->join(new \Shop\Model\Orm\Order(), 'A.order_id=B.id', 'B')
            ->whereIn('status', array('2','3','6','14'))
            ->where(array('type' => "product"
                            ))
            ->orderby('title');

        $helper = parent::helperIndex();
        $edit_href = $this->router->getAdminPattern('edit', array(':id' => '@id'));
        $q = $this->api->queryObj();
        $q->select('SUM(amount) as amount')
            ->join(new \Shop\Model\Orm\Order(), 'A.order_id=B.id', 'B')
            ->where(array('status' => "2",
                          'type' => "product"
                            ))
            ->groupby('title');

new TableType\String('title', t('Название товара'), array('SearchType' => '%like%')), 

<?php
namespace Newpage\Controller\Admin;
use \RS\Html\Table\Type as TableType,            
    \RS\Controller\Admin\Helper,
    \RS\Html\Toolbar\Button as ToolbarButton,
    \RS\Html\Toolbar,
    \RS\Html\Filter,
    \RS\Html\Table,
    \RS\Html\Tree,
    \Shop\Model;
    
class RemainCtrl extends \RS\Controller\Admin\Crud
{
        function __construct()
    {
         parent::__construct(new \Newpage\Model\RemainApi());
    }
    
    function helperIndex()
    {
           
        
        $helper = parent::helperIndex();
        $edit_href = $this->router->getAdminPattern('edit', array(':id' => '@id'));
        $q = $this->api->queryObj();
        $q->join(new \Shop\Model\Orm\Order(), 'A.order_id=B.id', 'B')
            ->where(array('status' => "2",
                          'type' => "product"
                            ));
            
        $helper = parent::helperIndex();
        $helper->setTopTitle(t('Количество товаров в заказе'));
        $edit_pattern = $this->router->getAdminPattern('edit', array(':id' => '@id'));
        $helper->setTable(new Table\Element(array(
            'Columns' => array(         
                new TableType\Text('order_num', t('Номер'), array('Sortable' => SORTABLE_BOTH, 'href' => $edit_href) ),
                new TableType\String('title', t('Название товара')), 
                new TableType\Text('amount', t('Количество'), array('Sortable' => SORTABLE_BOTH, 'href' => $edit_href) ),           
        ))));

        $helper->setFilter(new Filter\Control( array(
             'Container' => new Filter\Container( array( 
                                'Lines' =>  array(
                                    new Filter\Line( array('Items' => array(
                                                            new Filter\Type\Text('order_num','№', array('attr' => array('class' => 'w50')))
                                                        )
                                    )),
                                    
                                ),
                                'SecContainer' => new Filter\Seccontainer( array(
                                    'Lines' => array(
                                        new Filter\Line( array('Items' => array(
                                                new \Shop\Model\HtmlFilterType\Product('PRODUCT.title', t('Наименование товара'), array('searchType' => '%like%')),
                                        ))),
                                    )
                                ))
                            )),
            'Caption' => t('Поиск по заказам')
        )));

        return $helper;
    }
    
}