http://lomteqnxehqjdemqgzse7xchjlusgnpoxq2fpmz3yuukyfzc22t5gwyd.onion/jira_projects/browse/JILS-34.html
The issue list is generated with SELECT DISTINCT a.ID, a.SUMMARY, a.issuenum, a.REPORTER, b.pname, b.pkey, c.pname as status, d.pname as resolution, e.pname as issuetype, f.pname as priority,
a.CREATED, a.RESOLUTIONDATE, a.TIMESPENT, f.SEQUENCE as ptysequence, a.ASSIGNEE
FROM projectversion AS pv
LEFT JOIN nodeassociation as na ON pv.ID = na.SINK_NODE_ID
LEFT JOIN jiraissue AS a ON na.SOURCE_NODE_ID = a.ID
LEFT JOIN project AS b on a.PROJECT =...