Skip to content

Instantly share code, notes, and snippets.

@mficzel

mficzel/Query.sql

Created January 28, 2020 14:39
Show Gist options
  • Save mficzel/af7c93feb09180d14b10f534775f5dfd to your computer and use it in GitHub Desktop.
Save mficzel/af7c93feb09180d14b10f534775f5dfd to your computer and use it in GitHub Desktop.
Download ZIP
Neos - Find out which nodes were added below a specific type
Raw
Query.sql
SELECT node.nodetype, parent.nodetype, count(*) FROM `neos_contentrepository_domain_model_nodedata` AS node
JOIN `neos_contentrepository_domain_model_nodedata`
AS parent
ON node.parentpath = parent.path
WHERE parent.nodetype='Vendor.Site:NodeType'
GROUP by node.nodetype
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment