Untitled
public sql v1 · immutableSELECT 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_IDORDER BY ACCOUNTS.ACCT_COMMENT_DATE, INVOICES.INV_31_60 DESC LIMIT 0, 1;