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