Anonymous

SELECT INVOICES.ACCT_ID 
FROM INVOICES, ACCOUNTS 
WHERE INVOICES.COLLECTOR_ID = 1 
	AND SUM(INVOICES.INV_31_60) < (SELECT SUM(INV_31_60) 
		FROM INVOICES
		WHERE COLLECTOR_ID = 1 
			AND ACCT_ID = 'OM101736'  LIMIT 0, 1) 
	AND INVOICES.INV_31_60 > 25
	AND INVOICES.INV_61_90 = 0 
	AND INVOICES.INV_91 = 0 
	AND INVOICES.COLLECTOR_ID = ACCOUNTS.COLLECTOR_ID
	AND INVOICES.ACCT_ID = ACCOUNTS.ACCT_ID
ORDER BY ACCOUNTS.ACCT_COMMENT_DATE, INVOICES.INV_31_60 DESC 
LIMIT 0, 1;