Subversion Repositories DevTools

SELECT *
  FROM
       (
        SELECT  /*enumCLEARQUEST_DEVI_ID*/ AS iss_db,
                si.dbid AS iss_id,
                si.new_num AS iss_num,
            si.headline AS summary,
                sdef.name AS status,
                si.priority AS priority,
                si.issue_type AS issue_type
    FROM  CQ_DEVI.admin.software_issue si INNER JOIN CQ_DEVI.admin.statedef sdef ON si.state = sdef.id
        WHERE  si.dbid IN (/*DEVIiss*/)

        ) AS issues
ORDER BY iss_num ASC