SELECT
	od.product_id,
	count(*) as cnt,
	sum(od.price) as price
FROM
	(
		SELECT
			order_id
		FROM
			dtb_order
		WHERE
			status = ? AND 
			create_date >= ? AND create_date <= ?
	) o INNER JOIN dtb_order_detail od ON(o.order_id = od.order_id) INNER JOIN
	dtb_products p ON(od.product_id = p.product_id) INNER JOIN
	dtb_product_categories pc ON (p.product_id = pc.product_id)
GROUP BY 
	od.product_id