Finding Attachment Location

-- Find Attachment Location
SELECT CONCAT(p.pkey,'-',ji.issuenum) AS "Issue", f.filename, f.id as "Stored as" 
FROM fileattachment f, jiraissue ji, project p 
WHERE ji.ID = f.issueid AND p.id = ji.project;