Drupal: Finding Uncategorized Nodes
If you're working with a site with a lot of nodes, especially nodes that have been migrated out of another CMS or blogging tool, you'll probably find yourself wondering which nodes are floating around without any taxonomy terms, so that you can go back and make sure they're duly categorized.
Getting a raw list of node ID's and titles is simple with the following SQL query, which you can execute from the MySQL command line client, or PHPMyAdmin (which your web host's admin panel probably provides):
<br>SELECT nid, title FROM `node` n WHERE n.nid NOT IN (SELECT DISTINCT nid FROM `term_node`);<br>
From there you can just go to your browser and start plugging in edit urls: `http://mysite.com/node/123/edit`, `http://mysite.com/node/456/edit`, et cetera.
If you have a large number of uncategorized nodes, it may be worth writing a module to find and/or categorize them automatically.
-
var switchTo5x=true;stLight.options({publisher:'dr-8d4fe24c-a8ab-ba90-8086-3791b02244be'});