Subversion Repositories DevTools

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  release_manager.CQ_software_issue si INNER JOIN 
       release_manager.CQ_statedef sdef ON si.state = sdef.id
 WHERE  si.dbid IN (/*DEVIiss*/)
 ORDER BY iss_num ASC