protected function getCategoryProductSelect($productIds, $storeId)
    {
        $select = $this->getConnection()->select()
            ->from(['cpi' => $this->getTable($this->getCategoryProductIndexTable($storeId))])
            ->where('cpi.store_id = ?', $storeId)
            ->where('cpi.product_id IN(?)', $productIds);

        return $select;
    }
protected function getCategoryProductSelect($productIds, $storeId)
    {
        $select = $this->getConnection()->select()
            ->from(['cpi' => $this->getTable($this->getCategoryProductIndexTable($storeId))])
            ->where('cpi.store_id = ?', $storeId)
            ->where('cpi.product_id IN(?)', $productIds);

        return $select;
    }
protected function getCategoryProductSelect ( $ productIds , $ storeId ) { $ select = $ this -> getConnection ( ) -> select ( ) -> from ( [ 'cpi' => $ this -> getTable ( $ this -> getCategoryProductIndexTable ( $ storeId ) ) ] ) -> where ( 'cpi.store_id = ?' , $ storeId ) -> where ( 'cpi.product_id IN(?)' , $ productIds ) ; return $ select ; }
Prepare indexed data select.

@param array   $productIds Product ids.
@param integer $storeId    Store id.

@return \Zend_Db_Select
Prepare indexed data select .