Yes, I’ve been looking at that table.
Here’s the query I used to see the parent node the children I’d like to get rid of belong to:
SELECT * FROM neos.typo3_typo3cr_domain_model_nodedata where path = '/sites/doraphotography/node-5834e54a9ea72';
Here’s the results:
persistence_object_identifier,workspace,contentobjectproxy,path,identifier,sortingindex,properties,nodetype,removed,hidden,hiddenbeforedatetime,hiddenafterdatetime,hiddeninindex,accessroles,version,parentpath,pathhash,dimensionshash,dimensionvalues,parentpathhash,movedto,creationdatetime,lastmodificationdatetime,lastpublicationdatetime
22b36e64-10cc-4e5b-ba58-6e7255ff6678,live,NULL,/sites/doraphotography/node-5834e54a9ea72,d63811dc-7d77-4853-b3d1-6c54da31874d,891,"{
""uriPathSegment"": ""studiorental"",
""canonicalLink"": """",
""title"": ""studiorental"",
""titleOverride"": """",
""metaDescription"": """",
""metaKeywords"": """",
""metaRobotsNoindex"": false,
""metaRobotsNofollow"": false,
""twitterCardType"": """",
""twitterCardCreator"": """",
""twitterCardTitle"": """",
""twitterCardDescription"": """",
""twitterCardImage"": """",
""openGraphType"": """",
""openGraphTitle"": """",
""openGraphDescription"": """",
""openGraphImage"": """",
""xmlSitemapChangeFrequency"": """",
""xmlSitemapPriority"": """",
""layout"": ""studioRentalPage"",
""subpageLayout"": """"
}",TYPO3.Neos.NodeTypes:StudioRentalPage,0,0,NULL,NULL,0,{},4,/sites/doraphotography,dc36ed0dd52dec86b0e722e648500de1,d751713988987e9331980363e24189ce,{},6ba0ffd16634696ccc6d677c301e3494,NULL,"2016-11-22 19:39:38","2016-11-22 20:03:56","2016-11-22 20:03:55"
And this query lists all the nodes whose parent is the node above:
SELECT * FROM neos.typo3_typo3cr_domain_model_nodedata where parentpath = '/sites/doraphotography/node-5834e54a9ea72';
persistence_object_identifier,workspace,contentobjectproxy,path,identifier,sortingindex,properties,nodetype,removed,hidden,hiddenbeforedatetime,hiddenafterdatetime,hiddeninindex,accessroles,version,parentpath,pathhash,dimensionshash,dimensionvalues,parentpathhash,movedto,creationdatetime,lastmodificationdatetime,lastpublicationdatetime
02f7dac6-3f13-4b17-b176-59977d105a72,live,NULL,/sites/doraphotography/node-5834e54a9ea72/left,8f033acc-9490-0aed-1f5f-92e6c4be7bc5,200,{},TYPO3.Neos:ContentCollection,0,0,NULL,NULL,0,{},2,/sites/doraphotography/node-5834e54a9ea72,b51874a5c1c11114eed16a9961d27781,d751713988987e9331980363e24189ce,{},dc36ed0dd52dec86b0e722e648500de1,NULL,"2016-11-22 19:39:38","2016-11-22 19:43:55","2016-11-22 19:43:54"
7a544bab-1957-44d9-baff-70b6bdbe7b2a,live,NULL,/sites/doraphotography/node-5834e54a9ea72/disclaimer,1ea94359-36ee-d21f-7198-080a77adffa8,300,{},TYPO3.Neos:ContentCollection,0,0,NULL,NULL,0,{},2,/sites/doraphotography/node-5834e54a9ea72,7c552fca4cf0abf83214cc8df991cdf5,d751713988987e9331980363e24189ce,{},dc36ed0dd52dec86b0e722e648500de1,NULL,"2016-11-22 19:39:38","2016-11-22 19:43:55","2016-11-22 19:43:54"
d781cd1d-927d-42af-af46-ec080ab4aa4c,live,NULL,/sites/doraphotography/node-5834e54a9ea72/pictures,1f4b3a6a-2ecd-458d-90fb-25e67fe28976,400,{},TYPO3.Neos:ContentCollection,0,0,NULL,NULL,0,{},1,/sites/doraphotography/node-5834e54a9ea72,4815eb7c81d84b861b91f8ac58e8479e,d751713988987e9331980363e24189ce,{},dc36ed0dd52dec86b0e722e648500de1,NULL,"2016-11-22 20:10:04","2016-11-22 20:10:04",NULL
e15ec65e-9c72-4026-9495-32f3b4937bf9,live,NULL,/sites/doraphotography/node-5834e54a9ea72/main,89e9ea92-7e76-ccc2-e79b-1e9908cb74e1,100,{},TYPO3.Neos:ContentCollection,0,0,NULL,NULL,0,{},2,/sites/doraphotography/node-5834e54a9ea72,4d5391883e6c693178777bc9137470e5,d751713988987e9331980363e24189ce,{},dc36ed0dd52dec86b0e722e648500de1,NULL,"2016-11-22 19:39:38","2016-11-22 19:43:55","2016-11-22 19:43:54"
Sorry it’s a bit hard to ready but I can’t attach CSV files…