1-xbyk-basic-content-item-query.sql

SELECT *
FROM CMS_ContentItem ci
LEFT JOIN CMS_ContentItemCommonData cicd
    ON cicd.ContentItemCommonDataContentItemID = ci.ContentItemID
LEFT JOIN CMS_ContentItemLanguageMetadata cilm
    ON cicd.ContentItemCommonDataContentLanguageID = cilm.ContentItemLanguageMetadataContentLanguageID
    AND cicd.ContentItemCommonDataContentItemID = cilm.ContentItemLanguageMetadataContentItemID
LEFT JOIN CMS_ContentLanguage cl
    ON cl.ContentLanguageID = cilm.ContentItemLanguageMetadataContentLanguageID
LEFT JOIN CMS_Class c
    ON ci.ContentItemContentTypeID = c.ClassID
WHERE ci.ContentItemName = 'ElSalvadorFincaSanJose-nr6bglxm'