I am trying to write a query to get all property data of a published content version, so I am trying this first:

SELECT cd.*, cd.[text], cv.id, cv.VersionDate
FROM cmsDocument as cd
    inner join cmsContentVersion as cv on cd.versionId = cv.VersionId
WHERE
    cv.ContentId = 12270 and cd.newest = 1 and cd.published = 1

and it returns one record of the published version correctly.

Then I am extending it like this:

SELECT pd.id, pt.alias, cd.*, cd.[text], cv.id, cv.VersionDate
FROM cmsDocument as cd
    inner join cmsContentVersion as cv on cd.versionId = cv.VersionId
    inner join cmsPropertyData as pd **on pd.contentNodeId = cd.nodeId**
    inner join cmsPropertyType as pt  on pd.propertyTypeiD = pt.id
WHERE
    cv.ContentId = 12270 and cd.newest = 1 and cd.published = 1

and it returns the correct document but all the properties are multiplied (different number of times, depending on the property), plus it returns also properties that already have been deleted and are not present in the published version.

This does not return anything

SELECT pd.id, pt.alias, cd.*, cd.[text], cv.id, cv.VersionDate
FROM cmsDocument as cd
    inner join cmsContentVersion as cv on cd.versionId = cv.VersionId
    inner join cmsPropertyData as pd **on cd.versionId = pd.versionId**
    inner join cmsPropertyType as pt  on pd.propertyTypeiD = pt.id
WHERE
    cv.ContentId = 12270 and cd.newest = 1 and cd.published = 1

and it seems that versionId of a document is something else than the versionId of the property data.

How to write the correct query that returns the property of of the currently published content?