SELECT  A.bno as bno,
        B.name as severityString,
        A.title as title,
        A.status as status,
        A.issuer as issuer,
        A.auther as auther,
        A.analyst as analyst,
        A.updater as updater,
        A.comfirmer as comfirmer,
        C.name as milestoneString
FROM   bug AS A
       LEFT JOIN severity AS B ON A.severity = B.code
       LEFT JOIN milestone AS C ON A.milestone = C.code
where (A.issuer = 8 or
       A.auther = 8 or
       A.analyst = 8 or
       A.updater = 8 or
       A.comfirmer = 8 ) and
      (A.status <> 7 and
       A.status <> 8)
