I've enabled flat tables. Now the new arrival products aren't appearing which is filtered by a particular category. Below code works when flat tables are disabled.
$cat = Mage::registry('current_category'); $catid = $cat->getId(); $_products = $this->getProductCollection() ->joinField('category_id', 'catalog/category_product', 'category_id', 'product_id = entity_id', null, 'left') ->addAttributeToFilter('category_id', $catid);
Is there a different way to get new arrivals product filtered by a particular category when flat tables are ON?