/** * Prepare select for load * * @param Varien_Db_Select $select * @return string */ public function _prepareSelect(Varien_Db_Select $select) { $allowedProductTypes = array(); foreach ($this->_configurationHelper->getConfigurableAllowedTypes() as $type) { $allowedProductTypes[] = $type->getName(); } $this->addAttributeToSelect('name')->addAttributeToSelect('price')->addAttributeToSelect('sku')->addAttributeToSelect('weight')->addFieldToFilter('type_id', $allowedProductTypes)->addFieldToFilter('entity_id', array('neq' => $this->getProduct()->getId()))->addFilterByRequiredOptions()->joinAttribute('name', 'catalog_product/name', 'entity_id', null, 'inner'); return parent::_prepareSelect($select); }