Select T.ZTITLE,T.ZNOTE,datetime(T.ZCOMPLETEDAT,'unixepoch','+31 year'),L.ZTITLE From ZRESOURCE AS T INNER JOIN ZRESOURCE AS L ON L.Z_PK = T.ZTASKLIST order by L.ZTITLE