Smile\ElasticsuiteVirtualCategory\Model\ResourceModel\Product\Indexer\Fulltext\Datasource\CategoryData::getVirtualSelect PHP Метод

    private function getVirtualSelect($productIds)
    {
        $select = $this->getConnection()->select()->from(['cpi' => $this->getTable(ProductPositionResourceModel::TABLE_NAME)], [])->where('cpi.product_id IN(?)', $productIds)->columns(['category_id' => 'cpi.category_id', 'product_id' => 'cpi.product_id', 'is_parent' => new \Zend_Db_Expr('0'), 'is_virtual' => new \Zend_Db_Expr('1'), 'position' => 'cpi.position']);
        return $select;
    }