select CUSTS.CUST_ID, CUSTS.CUST_NAME, P_RELEASES.P_RELEASE_ID, P_RELEASES.P_RELEASE_TITLE_EN, P_RELEASE_DATE, P_RELEASE_ABSTRACT_EN from P_RELEASES, CUSTS where P_RELEASE_ISALIVE = 1 and P_RELEASES.P_RELEASE_CUST_ID = CUSTS.CUST_ID and CUSTS.CUST_ISALIVE = 1 order by P_RELEASE_DATE DESC #dateformat(P_RELEASE_DATE, "dd-mm-yyyy")# | #CUST_NAME#
#P_RELEASE_TITLE_EN#
#P_RELEASE_ABSTRACT_EN#