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