/** * Join url rewrite to select * * @param Varien_Db_Select $select * @param int $storeId * @return Mage_Catalog_Helper_Category_Url_Rewrite */ public function joinTableToSelect(Varien_Db_Select $select, $storeId) { if ($this->_helper()->OptimizeCategoriesLeftJoin($storeId)) { $select->joinLeft(array('url_rewrite' => $this->_resource->getTableName('urlindexer/url_rewrite')), 'url_rewrite.category_id=main_table.entity_id AND url_rewrite.is_system=1 AND ' . $this->_connection->quoteInto('url_rewrite.store_id = ? AND ', (int) $storeId) . $this->_connection->prepareSqlCondition('url_rewrite.id_path', array('like' => 'category/%')), array('request_path' => 'url_rewrite.request_path')); return $this; } return parent::joinTableToSelect($select, $storeId); }
/** * Join url rewrite to select * * @param Varien_Db_Select $select * @param int $storeId * * @return Mage_Catalog_Helper_Category_Url_Rewrite */ public function joinTableToSelect(Varien_Db_Select $select, $storeId) { if (false === Mage::helper('schumacherfm_fastindexer')->optimizeUrlRewriteFlatCategory()) { parent::joinTableToSelect($select, $storeId); } else { $select->columns('main_table.url_path as request_path'); } return $this; }