CartThrob sales by product within a date range

query.sql

SELECT
	products.entry_id,
	products.title,
	order_items.price,
	SUM(order_items.quantity) AS total_sold,
	SUM(order_items.quantity) * order_items.price AS total_price
FROM
	exp_cartthrob_order_items AS order_items
		INNER JOIN exp_channel_titles AS products
			USING(entry_id)
		INNER JOIN exp_channel_titles AS orders
			ON (orders.entry_id = order_items.order_id)
WHERE
	orders.entry_date < UNIX_TIMESTAMP('2015-09-14')
	AND orders.entry_date > UNIX_TIMESTAMP('2015-08-14')
	AND orders.status = 'Open'
GROUP BY
	order_items.entry_id,
	products.title
ORDER BY
	total_price DESC