하이버네이트 서브쿼리

import org.hibernate.annotations.Formula;

@Formula(value = "(SELECT REPLACE(CONCAT(T.FILE_PATH,T.FILE_NM,'.',T.FILE_EXT,'|',T.SNS_FILE_ID), '\\\\', '/' ) "

+ " FROM SNS_FILE T"

+ " INNER JOIN SNS X ON T.SNS_ID = X.SNS_ID"

+ " WHERE X.USER_ID = USER_ID"

+ " AND X.SNS_TP = 'PROFILE'"

+ " AND X.PROFILE_Fl = 'Y'"

+ " ORDER BY T.SNS_FILE_ID DESC LIMIT 1)");