Delete old umbraco content.sql

TRUNCATE TABLE cmsPreviewXml

DECLARE @Counter INT 
SET @Counter=-48
WHILE ( @Counter < -1)
BEGIN
	DECLARE @createdDate Datetime = DATEADD(m, @counter, getdate())
	PRINT @createdDate
	DELETE FROM [cmsPropertyData] WHERE
		versionId NOT IN (SELECT versionId FROM cmsDocument WHERE updateDate > @createdDate OR published = 1 OR newest = 1) AND
		contentNodeId IN (SELECT DISTINCT nodeID FROM cmsDocument)
	DELETE FROM [cmsContentVersion] WHERE
	    versionId NOT IN (SELECT versionId FROM cmsDocument WHERE updateDate > @createdDate OR published = 1 OR newest = 1) AND
		ContentId  IN (SELECT DISTINCT nodeID FROM cmsDocument)
	DELETE FROM [cmsDocument] WHERE
		versionId NOT IN (SELECT versionId FROM cmsDocument WHERE updateDate > @createdDate OR published = 1 OR newest = 1) AND
		nodeId IN (SELECT DISTINCT nodeID FROM cmsDocument)
	
    SET @Counter  = @Counter + 1

	RAISERROR ('Done', 0, 1) WITH NOWAIT
END


--- Remove items in the recycle bin
DELETE FROM [cmsPropertyData] WHERE
		contentNodeId IN (
			SELECT id 
			FROM [umbracoNode]
			where parentId = -20
			OR path like '%-20%')

DELETE FROM [cmsContentVersion] WHERE
		contentId IN (
			SELECT id 
			FROM [umbracoNode]
			where parentId = -20
			OR path like '%-20%')

DELETE FROM [cmsDocument] WHERE NodeId IN (SELECT id 
			FROM [umbracoNode]
			where parentId = -20
			OR path like '%-20%')

DELETE FROM [cmsContentXml] WHERE NodeId IN (SELECT id 
			FROM [umbracoNode]
			where parentId = -20
			OR path like '%-20%')
					
DELETE FROM [cmsContent] WHERE NodeId IN (SELECT id 
			FROM [umbracoNode]
			where parentId = -20
			OR path like '%-20%')

DELETE FROM [umbracoRedirectUrl] WHERE contentKey IN (SELECT UniqueId 
			FROM [umbracoNode]
			where parentId = -20
			OR path like '%-20%')

DELETE FROM [umbracoRelation] WHERE parentId IN (SELECT id 
			FROM [umbracoNode]
			where parentId = -20
			OR path like '%-20%')
			OR ChildId IN (SELECT id 
			FROM [umbracoNode]
			where parentId = -20
			OR path like '%-20%')

DELETE FROM [umbracoUser2NodePermission] WHERE NodeId IN (SELECT id 
			FROM [umbracoNode]
			where parentId = -20
			OR path like '%-20%')

DELETE FROM [umbracoNode]
			where parentId = -20
			OR path like '%-20%'
			AND Id != -20
			
--- Remove media in the recycle bin
DELETE FROM [cmsPropertyData] WHERE
		contentNodeId IN (
			SELECT id 
			FROM [umbracoNode]
			where parentId = -21
			OR path like '%-21%')

DELETE FROM [cmsContentVersion] WHERE
		contentId IN (
			SELECT id 
			FROM [umbracoNode]
			where parentId = -21
			OR path like '%-21%')

DELETE FROM [cmsDocument] WHERE NodeId IN (SELECT id 
			FROM [umbracoNode]
			where parentId = -21
			OR path like '%-21%')

DELETE FROM [cmsContentXml] WHERE NodeId IN (SELECT id 
			FROM [umbracoNode]
			where parentId = -21
			OR path like '%-21%')
					
DELETE FROM [cmsContent] WHERE NodeId IN (SELECT id 
			FROM [umbracoNode]
			where parentId = -21
			OR path like '%-21%')

DELETE FROM [umbracoRedirectUrl] WHERE contentKey IN (SELECT UniqueId 
			FROM [umbracoNode]
			where parentId = -21
			OR path like '%-21%')

DELETE FROM [umbracoRelation] WHERE parentId IN (SELECT id 
			FROM [umbracoNode]
			where parentId = -21
			OR path like '%-21%')
			OR ChildId IN (SELECT id 
			FROM [umbracoNode]
			where parentId = -21
			OR path like '%-21%')

DELETE FROM [umbracoUser2NodePermission] WHERE NodeId IN (SELECT id 
			FROM [umbracoNode]
			where parentId = -21
			OR path like '%-21%')

DELETE FROM [umbracoNode]
			where parentId = -21
			OR path like '%-21%'
			AND Id != -21