Umbraco Scripts

Corrupt Vorto Documents.sql

SELECT contentNodeId
FROM cmsPropertyData AS PD

INNER JOIN cmsPropertyType AS PT
ON PD.propertytypeid = PT.id

WHERE PD.versionId IN (
  SELECT versionId
  FROM [cmsDocument] AS D

  INNER JOIN [cmsContent] AS C
  ON D.nodeId = C.nodeId

  INNER JOIN [cmsContentType] AS CT
  ON C.contentType = CT.nodeId

  --where CT.alias = 'textPage'
  AND newest = 1
)
AND dataNText IS NOT NULL
AND dataNText LIKE '%dtdGuid":"00000000-0000-0000-0000-000000000000%'

GROUP BY contentNodeId

Joined Content.sql

  SELECT TOP 100
	CT.alias, D.*
  FROM [cmsDocument] AS D

  INNER JOIN [cmsContent] AS C
  ON D.nodeId = C.nodeId

  INNER JOIN [cmsContentType] AS CT
  ON C.contentType = CT.nodeId

Latest properties of type.sql

SELECT TOP 1000 PT.Alias, PD.*
FROM cmsPropertyData AS PD

INNER JOIN cmsPropertyType AS PT
ON PD.propertytypeid = PT.id

WHERE PD.versionId IN (
  SELECT versionId
  FROM [cmsDocument] AS D

  INNER JOIN [cmsContent] AS C
  ON D.nodeId = C.nodeId

  INNER JOIN [cmsContentType] AS CT
  ON C.contentType = CT.nodeId

  where CT.alias = 'textPage'
  AND newest = 1
)