6-xbyk-web-page-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
LEFT JOIN DancingGoat_CoffeePage coffeePage
    ON c.ClassName = 'DancingGoat.CoffeePage'
    AND cicd.ContentItemCommonDataID = coffeePage.ContentItemDataCommonDataID
LEFT JOIN CMS_WebPageItem wp
    ON wp.WebPageItemContentItemID = ci.ContentItemID
LEFT JOIN CMS_WebPageUrlPath wpu
    ON wpu.WebPageUrlPathContentLanguageID = cicd.ContentItemCommonDataContentLanguageID
    AND wpu.WebPageUrlPathWebPageItemID = wp.WebPageItemID
WHERE ci.ContentItemName = 'ElSalvadorFincaSanJose-ttfjisz3'