public function getSlides()
{
$slides = parent::getSlides();
$tableName = Mage::getSingleton('core/resource')->getTableName('auguria_sliders/pages');
$slides->getSelect()->join(array('sp' => $tableName), 'main_table.slider_id = sp.slider_id', array('sp.*'))->where('sp.page_id = ?', $this->getPageId());
return $slides;
}
public function getSlides()
{
$slides = parent::getSlides();
/* Join auguria_sliders_pages and filter by page id */
$tableName = Mage::getSingleton('core/resource')->getTableName('auguria_sliders/categories');
$slides->getSelect()->join(array('sc' => $tableName), 'main_table.slider_id = sc.slider_id', array('sc.*'))->where('sc.category_id = ?', $this->getCategoryId());
return $slides;
}
