Andy Chase

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):