I am adding a condition to product listing in magento, Mage_Catalog_Block_Product_List
But when I've added the condition using getSelect, its not returning as collection as some of functions are missing like setCurrPage().
Basically I want to join catalog stock table to the product collection. Is there any other way around for this?
Note:: I am trying to override the file Mage_Catalog_Block_Product_List so the collection
$products = parent::_getProductCollection()->getSelect()->joinLeft( array('css'=> 'cataloginventory_stock_status'), 'css.product_id = e.entity_id', array('css.stock_status')); return $products;