SELECT
					item.sku as sku,
					item.name as name,
					COUNT(sale_item.id) as item_count,
					SUM(sale_item.price) as item_price_total,
					refund
				FROM
					{{sale_item}} as sale_item,
					{{item}} as item,
					{{sale_instance}} as instance
					LEFT JOIN
						(SELECT
							COUNT(sale_item_status) as refund
						FROM
							{{sale_item}} as sale_item,
							{{item}} as item,
							{{sale_instance}} as instance
						WHERE
							item_id = item.id
							AND sale_id = instance.id
							AND sale_item_status = "refund"
							AND end_time BETWEEN "2011-09-06 16:45:24" AND "2012-09-08 16:45:24"
						GROUP BY item_id) as refund ON sale_item.item_id = item.id
				WHERE
					item_id = item.id
					AND sale_id = instance.id
					AND end_time BETWEEN "2011-09-06 16:45:24" AND "2012-09-08 16:45:24"
				GROUP BY item_id