select DISTINCT a.WFR_ID , a.TOPIC_FUND ,a.FUND_DETAIL,a.TOPIC_EFUND,a.FUND_EDETAIL,FUND_VIEWS,a.WFR_TIMESTAMP,b.FILE_SAVE_NAME from
WFR_FUND_PUBLIC a
LEFT JOIN WF_FILE b ON a.WFR_ID = b.WFR_ID
LEFT JOIN M_FUND c ON a.FUND_NAME = c.FUND_ID
LEFT JOIN USR_MAIN d ON a.WFR_UID = d.USR_ID
LEFT JOIN WF_CHECKBOX e ON c.FUND_ID = e.WFR_ID
LEFT JOIN M_COUNTRY MC ON MC.COUNTRY_NAME = a.FUND_COUNTRY
LEFT JOIN M_INSTITUTE MI ON MI.INSTITUTE_NAME = a.FUND_INSTITUTE
where a.FUND_PUBLIC_RESULT = '1'
AND b.WFS_FIELD_NAME = 'FUND_PICTURE'
AND b.FILE_STATUS = 'Y'
AND e.WFS_FIELD_NAME IN ('IN_OUTBOUND', 'FUND_TYPE')
AND W_ID = '117'
and PUBLIC_LANGUAGE_TH = 'Y' ORDER BY a.WFR_ID DESC
Error Description: ORA-00018: maximum number of sessions exceeded
/
