title: Sales by Category in Magento?
body: <p>We have a category called "Clearance" on our Magento website. Ideally it would be nice to be able to get a report of all orders sold in that category.</p>
  
  <p>Is there anyway I can join the orders collection with the products collection and filter by category id?</p>
  
  <p>Here is a similar thread:
  <a href="http://www.magentocommerce.com/boards/viewthread/44296/" rel="nofollow noreferrer">http://www.magentocommerce.com/boards/viewthread/44296/</a></p>
  
  <p>Any ideas, or am I crazy? It doesn't need to be pretty.</p>