public function findVariantsWithBase($arrIds, $objFilter)
{
if (!$arrIds) {
// Return an empty result.
return $this->getItemsWithId(array());
}
$objNewFilter = $this->copyFilter($objFilter);
$objRow = $this->getDatabase()->prepare(sprintf('SELECT id,vargroup FROM %1$s WHERE vargroup IN (SELECT vargroup FROM %1$s WHERE id IN (%2$s))', $this->getTableName(), $this->buildDatabaseParameterList($arrIds)))->execute($arrIds);
$objNewFilter->addFilterRule(new StaticIdList($objRow->fetchEach('id')));
return $this->findByFilter($objNewFilter);
}