Stuff

 SELECT INVOICES.ACCT_ID, SUM( INV_31_60 ) AS INV_31_60, ACCOUNTS.ACCT_COMMENT_DATEFROM INVOICESLEFT OUTER JOIN ACCOUNTS ON ( INVOICES.COLLECTOR_ID = ACCOUNTS.COLLECTOR_IDAND INVOICES.ACCT_ID = ACCOUNTS.ACCT_ID )WHERE INVOICES.COLLECTOR_ID =2AND ACCOUNTS.ACCT_AUTO_DATE =20060818GROUP BY ACCT_IDHAVING (ACCOUNTS.ACCT_COMMENT_DATE > (SELECT ACCOUNTS.ACCT_COMMENT_DATEFROM ACCOUNTSWHERE ACCT_ID = 'DT672620' ))OR (ACCOUNTS.ACCT_COMMENT_DATE = (SELECT ACCT_COMMENT_DATEFROM ACCOUNTSWHERE ACCT_ID = 'DT672620' )AND SUM( INV_31_60 ) < (SELECT INVOICES.ACCT_ID, SUM( INV_31_60 ) AS INV_31_60FROM INVOICESLEFT OUTER JOIN ACCOUNTS ON ( INVOICES.COLLECTOR_ID = ACCOUNTS.COLLECTOR_IDAND INVOICES.ACCT_ID = ACCOUNTS.ACCT_ID )WHERE INVOICES.COLLECTOR_ID =2AND ACCOUNTS.ACCT_ID = 'DT672620'GROUP BY ACCT_ID ))OR (ACCOUNTS.ACCT_COMMENT_DATE = (SELECT ACCT_COMMENT_DATEFROM ACCOUNTSWHERE ACCT_ID = 'DT672620' )AND SUM( INV_31_60 ) < (SELECT INVOICES.ACCT_ID, SUM( INV_31_60 ) AS INV_31_60FROM INVOICESLEFT OUTER JOIN ACCOUNTS ON ( INVOICES.COLLECTOR_ID = ACCOUNTS.COLLECTOR_IDAND INVOICES.ACCT_ID = ACCOUNTS.ACCT_ID )WHERE INVOICES.COLLECTOR_ID =2AND ACCOUNTS.ACCT_ID = 'DT672620'GROUP BY ACCT_ID ))AND SUM( INV_31_60 ) >25AND SUM( INV_61_90 ) =0AND SUM( INV_91 ) =0ORDER BY ACCOUNTS.ACCT_COMMENT_DATE DESC , INV_31_60LIMIT 0 , 30