SELECT * FROM	(
	(
		SELECT * FROM (
			SELECT
				CONCAT(customers.LASTNAME,', ',customers.FIRSTNAME,' ',customers.MIDDLENAME) AS NAME,
				CONVERT (Sum(invoices.AMOUNT),DECIMAL (10, 2)) AS Balance
			FROM
				invoices
			INNER JOIN customers ON customers.CUSTOMER_ID = invoices.CHARGETO_CUSTOMER_ID
			WHERE
				invoices.VOIDEDINVOICE = 0
			AND invoices.PAYMENT_ID < 1
			AND (
				DATEDIFF(CURDATE(),invoices.POSTDATE) > 365
				OR customers.CURRENT_STATUS = 'TERMINATED'
				OR (
					customers.CUSTOMER_TYPE = 'PUNCH CARD'
					AND customers.IS_BILLABLE = 0
				)
				OR (
					customers.LASTNAME = 'GUEST'
					AND customers.FIRSTNAME = 'User'
				)
				OR (
					customers.CUSTOMER_TYPE = 'GUEST'
					AND customers.MANUAL_BILLING = 0
				)
			)
			GROUP BY
				invoices.CHARGETO_CUSTOMER_ID
		) a
		WHERE
			a.Balance <> 0
	)

	UNION

	(
		SELECT * FROM (
			SELECT
				CONCAT(', ',customers.FIRSTNAME,' ',customers.MIDDLENAME) AS NAME,
				CONVERT (Sum(invoices.AMOUNT),DECIMAL (10, 2)) AS Balance
			FROM
				invoices
			INNER JOIN customers ON customers.CUSTOMER_ID = invoices.CUSTOMER_ID
			WHERE
				invoices.VOIDEDINVOICE = 0
			AND invoices.PAYMENT_ID < 1
			AND invoices.CHARGETO_CUSTOMER_ID = customers.CUSTOMER_ID
			AND customers.RESPONSIBLE_PARTY_ID <> 0
			GROUP BY
				invoices.CHARGETO_CUSTOMER_ID
		) a
		WHERE
			a.Balance <> 0
	)
) b
ORDER BY
	b.balance