Subversion Repositories DevTools

/* DEVI Isseus List*/
SELECT 
           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 DEVI_PROD.admin.software_issue si INNER JOIN DEVI_PROD.admin.statedef sdef ON si.state = sdef.id
 WHERE si.dbid IN (/*DEVIiss*/)
 ORDER BY iss_num ASC