/**
* 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;
}
