All pastes #110580 Raw Edit

Untitled

public sql v1 · immutable
#110580 ·published 2006-08-01 19:41 UTC
rendered paste body
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_IDORDER BY ACCOUNTS.ACCT_COMMENT_DATE, INVOICES.INV_31_60 DESC LIMIT 0, 1;