3-xbyk-reusable-fields-query.sql

SELECT cl.ContentLanguageName
    ,coffee.*
    ,cicd.ProductFieldsName
    ,cicd.ProductFieldsDescription
    ,cicd.ProductFieldsShortDescription
    ,cicd.ProductFieldsImage
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
LEFT JOIN DancingGoat_Coffee coffee
    ON c.ClassName = 'DancingGoat.Coffee'
    AND cicd.ContentItemCommonDataID = coffee.ContentItemDataCommonDataID
WHERE ci.ContentItemName = 'ElSalvadorFincaSanJose-nr6bglxm'