Skip to content

Instantly share code, notes, and snippets.

View diger74's full-sized avatar

Dmitry Bastron diger74

11 followers · 1 following
View GitHub Profile
@diger74
diger74 / 6-xbyk-web-page-query.sql
Created November 28, 2024 14:34
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
@diger74
diger74 / 5-xbyk-content-hub-with-taxonomy-query.sql
Last active November 28, 2024 14:16
SELECT cl.ContentLanguageName
,coffee.*
,cicd.ProductFieldsName
,cicd.ProductFieldsDescription
,cicd.ProductFieldsShortDescription
,cicd.ProductFieldsImage
,processingTags.TagTitle
FROM CMS_ContentItem ci
LEFT JOIN CMS_ContentItemCommonData cicd
ON cicd.ContentItemCommonDataContentItemID = ci.ContentItemID
@diger74
diger74 / 4-xbyk-content-hub-asset-query.sql
Last active November 28, 2024 13:20
SELECT JSON_VALUE(ImageFile, '$.Identifier') AS Identifier
,JSON_VALUE(ImageFile, '$.Name') AS Name
,JSON_VALUE(ImageFile, '$.Extension') AS Extension
,JSON_VALUE(ImageFile, '$.Size') AS Size
,JSON_VALUE(ImageFile, '$.LastModified') AS LastModified
,LOWER(CONCAT(
'/assets/ContentItems/',
LEFT(ci.ContentItemGUID, 2),
'/',
ci.ContentItemGUID,
@diger74
diger74 / 3-xbyk-reusable-fields-query.sql
Last active November 28, 2024 12:05
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
@diger74
diger74 / 2-xbyk-custom-content-item-fields-query.sql
Last active November 28, 2024 10:09
SELECT cl.ContentLanguageName, coffee.*
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
@diger74
diger74 / 1-xbyk-basic-content-item-query.sql
Last active November 28, 2024 14:46
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