Issue Versions

ISSUEVERSIONS

ISSUEVERSIONS
Column	ISSUEID	VERSIONID	RELATION
Type	BIGINT	VARCHAR	VARCHAR
Indexed	x	x

How to get all the versions and their issues of a given project (id=10000) and their release status

SELECT
  P.NAME AS PROJECT, 
  KEY(JQL.ISSUEID) AS ISSUE, 
  IV.RELATION,
  V.NAME AS VERSION, 
  V.RELEASED
FROM
    PROJECTS P
      INNER JOIN
    PROJECTVERSIONS V ON V.PROJECTID=P.ID
      INNER JOIN
    ISSUEVERSIONS IV ON IV.VERSIONID = V.ID
      INNER JOIN
    JQL ON JQL.ISSUEID = IV.ISSUEID
WHERE
   P.ID=10000