Delete Umbraco nodes from recycle bin

Umbraco - Delete nodes from recycle bin

BEGIN TRANSACTION

SET NOCOUNT ON
DECLARE @Nodes TABLE (NodeId int)
 
INSERT INTO @Nodes (NodeId)
	SELECT n.id
	FROM umbracoNode n
	WHERE n.path like '%-20%' and id!=-20

DECLARE @nodesCount INT  
SET @nodesCount = (select count(1) from umbracoNode where id in (select NodeId from @Nodes))

SET NOCOUNT OFF

print CAST(@nodesCount AS varchar(50)) + ' nodes to delete'

delete from cmsPreviewXml where nodeId in (select NodeId from @Nodes)
delete from cmsContentVersion where contentId in (select NodeId from @Nodes)
delete from cmsDocument where nodeId in (select NodeId from @Nodes)
delete from cmsContentXML where nodeId in (select NodeId from @Nodes)
delete from cmsContent where nodeId in (select NodeId from @Nodes)
delete from cmsPropertyData where contentNodeId in (select NodeId from @Nodes)
delete from umbracoRelation where parentId in (select NodeId from @Nodes) OR childId in (select NodeId from @Nodes)
delete from cmsTagRelationship where nodeId in (select NodeId from @Nodes)
delete from umbracoNode where id in (select NodeId from @Nodes)

DELETE FROM @Nodes

IF @@ERROR <> 0
	IF @@TRANCOUNT = 1 ROLLBACK TRANSACTION
GO

IF @@TRANCOUNT = 1
	BEGIN
	   PRINT 'nodes deleted'
	   COMMIT TRANSACTION
	END
ELSE
	BEGIN
	   PRINT 'error deleting nodes, rollback transaciton.'
	END
GO