Cacher is the code snippet organizer for pro developers

Select 
	PageTemplateID,
	PageTemplateDisplayName,
	PageTemplateCodeName, *
From
	CMS_PageTemplate
Where
	PageTemplateWebParts like '%WebPart Code%'

Select * From CMS_SettingsKey Where KeyName = 'CMSDataVersion' OR KeyName = 'CMSDBVersion' OR KeyName = 'CMSHotfixVersion'

SELECT 
	*
FROM 
	[View_CMS_Tree_Joined] as [Tree] 
WHERE
	([DocumentCanBePublished] = 1 
		AND ([DocumentPublishFrom] IS NULL OR [DocumentPublishFrom] <= GETDATE())
		AND ([DocumentPublishTo] IS NULL OR [DocumentPublishTo] >= GETDATE()))