thanks andy! my developer was having a similar problem migrating one of my sites to drupal...I'll point him to your article and see if it helps... thanks a lot for selflessly sharing your knowledge!

Why you can't just delete these nodes like this:
DELETE FROM `node` WHERE n.nid NOT IN (SELECT DISTINCT nid FROM `term_node`)
?

thanks for the node-finding trick. I'm sure theres a way to write this into a quick push-button style plugin, to keep track of drupal sites with thousands of nodes.

This works really well. Actually i tried on my site CHETAN
and was amazed by the results. Thanks for sharing.

It's easier to do it with Views module.
Add a filter "Category: ID" and choose "is empty (Null)" and you have them all listed.
Then you can add bulk categorise them with "views bulk operations" module and you're home.

In communication networks, a node (Latin nodus, ‘knot’) is a connection point, either a redistribution point or a communication endpoint (some terminal equipment). The definition of a node depends on the network and protocol layer referred to. A physical network node is an active electronic device that is attached to a network, ccnp exams, and is capable of sending, receiving, or forwarding information over a communications channel. A passive distribution point such as a distribution frame is consequently not a node.

Thanks for this trick.
It could be nice to have such thing realized as module.

Alternate result:


SELECT n.nid FROM node n LEFT JOIN term_node tn ON n.nid = tn.nid GROUP BY n.nid HAVING count(tn.tid) = 0;


pp

I've updated the query accordingly.

Since nodes may be categorized with more than one term, the inner select will return duplicates: you probably want to "SELECT DISTINCT nid FROM term_node".