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