$modelContracts = CkJModel::getInstance('contracts', 'MyComponentModel');
$modelContracts->setState('context', 'contracts.monetize');
switch ($this->item->type) {
    case "1":
        $modelContracts->addWhere('a.films = 1');
        break;
    case "2":
        $modelContracts->addWhere('a.shorts = 1');
        break;
    case "3":
        $modelContracts->addWhere('a.series = 1');
        break;
    default:
        break;
}

$modelContracts->addSelect('(select count(*) FROM #__mycomponent_xtitlecontracts WHERE contract=a.id AND title=' . $_GET['id'] . ') as count');
$modelContracts->addSelect('(select b.id FROM #__mycomponent_xtitlecontracts AS b WHERE b.contract=a.id AND b.title=' . $_GET['id'] . ' LIMIT 1) as linkID');
$modelContracts->addSelect('(select c.payment_status FROM #__mycomponent_xtitlecontracts AS c WHERE c.contract=a.id AND c.title=' . $_GET['id'] . ' LIMIT 1) as paymentStatus');
$modelContracts->addWhere('a.published = 1');
$modelContracts->addOrder('a.contract_name');

$contracts = $modelContracts->getItems();

$modelContracts->orm(array(
            'context' => 'contracts.monetize'
        ));

$modelContracts = CkJModel::getInstance('contracts', 'MyComponentModel');

$filter = array(
    'published' => array(
        'value' => 1
    )
);
switch ($this->item->type) {
    case "1":
        $filter['films'] = array('value' => 1);
        break;
    case "2":
        $filter['shorts'] = array('value' => 1);
        break;
    case "3":
        $filter['series'] = array('value' => 1);
        break;
    default:
        break;
}

$contracts = MyComponentHelper::getData('contracts',
  array(
    'context' => 'contracts.monetize',
    'filter' => array(
        $filter
    ),
    'order' => array(
        'contract_name' => ASC
    )
));