Home ›
MySQL Query to Get Quick Overview of Nodes by Content TypeMySQL Query to Get Quick Overview of Nodes by Content Type
Submitted by Benjamin Melançon on April 9, 2014 - 2:33pm
mysql> SELECT nt.name, nt.type, COUNT(n.nid) FROM node_type nt LEFT JOIN node n ON nt.type = n.type GROUP BY (nt.type);
Searched words:
mysql count by group
list number of Drupal nodes by content type
node types
posts by content type
unused content types
Comments
Post new comment