Jira查询问题所关联的文件信息及创建时间

今天调试SQL，顺手重写了一个SQL，特此记录！

select pj.pname,concat(pj.pkey,'-',ji.issuenum) AS issue_key,ji.SUMMARY,ft.MIMETYPE,ft.CREATED,ft.FILENAME,cast(ft.FILESIZE AS unsigned) / (1024 * 1024 *1024) AS 'GB'
from fileattachment as ft
join jiraissue as ji on ji.ID = ft.issueid 
join project as pj on pj.ID = ji.PROJECT;