SELECT A.bno as bno, A.bid as bid, A.title as title, A.location as location, B.shortName as locationString, A.functionName as functionName, C.shortName as functionNameString, A.browser as browser, D.shortName as browserString, A.os as os, E.shortName as osString, A.tid as tid, A.appVersion as appVersion, F.shortName as appVersionString, A.dbVersion as dbVersion, G.shortName as dbVersionString, A.htmlVersion as htmlVersion, H.shortName as htmlVersionString, A.specVersion as specVersion, I.shortName as specVersionString, A.issuer as issuer, J.nickName as issuerName, A.issuDate as issuDate, A.registDate as registDate, A.severity as severity, K.shortName as severityString, A.priority as priority, L.shortName as priorityString, A.status as status, A.statusWhitebord as statusWhitebord, A.resolution as resolution, M.shortName as resolutionString, A.milestone as milestone, N.shortName as milestoneString, A.keyword1 as keyword1, A.keyword2 as keyword2, A.keyword3 as keyword3, A.cpid1 as cpid1, A.cpid2 as cpid2, A.cpid3 as cpid3, A.cpid4 as cpid4, A.cpid5 as cpid5, A.reletedDoc as reletedDoc, A.auther as auther, O.nickName as autherName, A.authDate as authDate, A.errorType as errorType, P.shortName as errorTypeString, A.errorCause as errorCause, Q.shortName as errorCauseString, A.issuPno as issuPno, R.shortName as issuPnoString, A.trainPno as trainPno, S.shortName as trainPnoString, A.shouldFindPno as shouldFindPno, T.shortName as shouldFindPnoString, A.errorDelayReason as errorDelayReason, U.shortName as errorDelayReasonString, A.releaseSchDate as releaseSchDate, A.analyst as analyst, V.nickName as analystName, A.analizeDate as analizeDate, A.updateSrc as updateSrc, A.updateDoc as updateDoc, A.updater as updater, W.nickName as updaterName, A.bugUpdateDate as bugUpdateDate, A.releaseDate as releaseDate, A.comfirmer as comfirmer, X.nickName as comfirmerName, A.comfirmDate as comfirmDate, A.updateUno as updateUno, Y.nickName as updateUnoName, A.updateDate as updateDate FROM   bug AS A LEFT JOIN location AS B ON A.location = B.code  LEFT JOIN functionName AS C ON A.functionName = C.code  LEFT JOIN browser AS D ON A.browser = D.code  LEFT JOIN os AS E ON A.os = E.code  LEFT JOIN appVersion AS F ON A.appVersion = F.code  LEFT JOIN dbVersion AS G ON A.dbVersion = G.code  LEFT JOIN htmlVersion AS H ON A.htmlVersion = H.code  LEFT JOIN specVersion AS I ON A.specVersion = I.code  LEFT JOIN UserInfo AS J ON A.issuer = J.uno  LEFT JOIN severity AS K ON A.severity = K.code  LEFT JOIN priority AS L ON A.priority = L.code  LEFT JOIN resolution AS M ON A.resolution = C.code  LEFT JOIN milestone AS N ON A.milestone = N.code  LEFT JOIN userinfo AS O ON A.auther = O.uno  LEFT JOIN errorType AS P ON A.errorType = P.code  LEFT JOIN errorCause AS Q ON A.errorCause = Q.code  LEFT JOIN processName AS R ON A.issuPno = R.code  LEFT JOIN processName AS S ON A.trainPno = S.code  LEFT JOIN processName AS T ON A.shouldFindPno = T.code  LEFT JOIN errorDelayReason AS U ON A.errorDelayReason = U.code  LEFT JOIN userinfo AS V ON A.analyst = V.uno  LEFT JOIN userinfo AS W ON A.updater = W.uno  LEFT JOIN userinfo AS X ON A.comfirmer = X.uno  LEFT JOIN userinfo AS Y ON A.updateUno = Y.uno  where A.bno = 5