http://www.magentocommerce.com/bug-tracking/ en MagentoCommerce Copyright {gmt_date format="%Y"} {gmt_date format="%Y-%m-%dT%H:%i:%s%Q"} http://www.magentocommerce.com/bug-tracking/issue?issue=5044 Posted: 2009-01-31 10:58:32
Category: Search
Version: 1.2.0.2
Priority: urgent
Status: closed
Reported By: jshpro2

http://demo.magentocommerce.com/catalog/category/view/s/laptops/id/15/?___store=default&cat=27&order=price&dir=asc

When viewing items in layered navigation, if price is selected as sort by, and sort option is descending, then magento mis-calculates product counts. This appears to be due to getSelectCountSql() method in Mage_Catalog_Model_Resource_Eav_Mysql4_Product_Collection.

Debugging SQL shows it is pulling back N rows each with a value of 1, where N should be the total aggregate count. This appears to because they over abstracted the SQL generation / don't know the effects of the joins and aggregate functions.

---

]]> #1 / Comment by jshpro2

appears to be duplicate of http://www.magentocommerce.com/bug-tracking/issue?issue=5052]]> #2 / Comment by Magento Team

Hello jshpro2,

This issue was fixed. Please check the latest Magento release at http://www.magentocommerce.com/download/

Thank you.]]>