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