/** * Ensures that only posts and not pages are returned * WP stores posts and pages in the same DB table * */ protected function _initSelect() { parent::_initSelect(); $this->getSelect()->join(array('taxonomy' => $this->getTable('wordpress/term_taxonomy')), '`main_table`.`term_id` = `taxonomy`.`term_id`', array('term_taxonomy_id', 'taxonomy', 'description', 'count', 'parent')); // Reverse the order. This then matches the WP order $this->getSelect()->order('term_id DESC'); return $this; }
/** * Ensures that only posts and not pages are returned * WP stores posts and pages in the same DB table * */ protected function _initSelect() { parent::_initSelect(); $this->getSelect()->join(array('taxonomy' => $this->getTable('wordpress/term_taxonomy')), '`main_table`.`term_id` = `taxonomy`.`term_id`', array('term_taxonomy_id', 'taxonomy', 'description', 'count', 'parent')); // Reverse the order. This then matches the WP order if (Mage::getResourceSingleton('wordpress/term')->tableHasTermOrderField()) { $this->getSelect()->order('term_order ASC'); } $this->getSelect()->order('term_id DESC'); return $this; }
/** * Ensures that only posts and not pages are returned * WP stores posts and pages in the same DB table * */ protected function _initSelect() { parent::_initSelect(); $this->getSelect()->where("`main_table`.`post_type`=?", $this->_getPostType()); return $this; }
/** * Init collection select * * @return Mage_Core_Model_Resource_Db_Collection_Abstract */ protected function _initSelect() { parent::_initSelect(); return $this->setOrder('main_table.menu_order', 'ASC')->setOrder('main_table.post_date', 'DESC'); }