Mage::getResourceModel('catalog/product_collection') didn't calculate stock for configurable products.
I think, with MySQL, there is a way, to calculate configurable product stock from simple products stock.
- simple product = 1 cataloginventory_stock_item
- configurable product = 2 or more cataloginventory_stock_item
Can someone help us to create a SQL query to do this?