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