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=10622 Posted: 2010-12-31 15:20:49
Category: Orders
Version: 1.4.1.1
Priority: high
Status: closed
Reported By: colinmollenhour

# Query_time: 94.249761 Lock_time: 0.000170 Rows_sent: 20 Rows_examined: 74682762
SET timestamp=1293761419;
SELECT `e`.*, (SELECT count(*) FROM `sales_flat_quote_item` AS `quote_items`
INNER JOIN `sales_flat_quote` AS `quotes` ON quotes.entity_id = quote_items.quote_id AND quotes.is_active = 1 WHERE (quote_items.product_id = e.entity_id)) AS `carts`, count(`order_items2`.item_id) AS `orders` FROM `catalog_product_entity` AS `e`
LEFT JOIN `sales_flat_order_item` AS `order_items` ON order_items.product_id = e.entity_id
LEFT JOIN `sales_flat_order_item` AS `order_items2` ON order_items2.item_id = order_items.item_id GROUP BY `e`.`entity_id`,
`e`.`entity_id` HAVING (carts > 0) LIMIT 20;

---

]]> #1 / Comment by Magento Team

Thanks for your issue.

Issue was confirmed but wouldn't fixed. This query doesn't use in current version of Magento. For getting information about products in shopping carts you may use Mage_Reports_Model_Mysql4_Quote_Collection.]]> #2 / Comment by Magento Team

This issue is fixed in Magento 1.5.1.0.
Thank you for the report.]]>