Page Comparison

select 
  i.key as"Issue",
  i.summary as "Summary",
  t.name as "Type", t.url as "TypeUrl",
  s.name as "Status",
  c.colorname as "Status Color"
from 
  ISSUES i
     join
  ISSUETYPEDEFINITIONS t on t.id = i.typeid
    join
  ISSUESTATUSDEFINITIONS s on s.id = i.statusid
    join
  ISSUESTATUSCATEGORYDEFINITIONS c on c.id = s.categoryid
where 
  i.jql = 'reporter = currentUser()'