SELECT DISTINCT BIB_TEXT.BIB_ID, TITLE_BRIEF AS TITLE, FUND.FUND_NAME AS CATEGORY
FROM (LINE_ITEM_STATUS INNER JOIN (FUND INNER JOIN (LINE_ITEM_FUNDS INNER JOIN ((LINE_ITEM INNER JOIN BIB_TEXT ON LINE_ITEM.BIB_ID = BIB_TEXT.BIB_ID) INNER JOIN LINE_ITEM_COPY_STATUS ON LINE_ITEM.LINE_ITEM_ID = LINE_ITEM_COPY_STATUS.LINE_ITEM_ID) ON LINE_ITEM_FUNDS.COPY_ID = LINE_ITEM_COPY_STATUS.COPY_ID) ON FUND.FUND_ID = LINE_ITEM_FUNDS.FUND_ID) ON LINE_ITEM_STATUS.LINE_ITEM_STATUS = LINE_ITEM_COPY_STATUS.LINE_ITEM_STATUS) INNER JOIN LEDGER ON FUND.LEDGER_ID = LEDGER.LEDGER_ID
WHERE ((LINE_ITEM_COPY_STATUS.STATUS_DATE) Between SYSDATE-30 And SYSDATE) AND ((LEDGER.LEDGER_NAME)='2007 BKS') AND LINE_ITEM_COPY_STATUS.LINE_ITEM_STATUS=7
