I need help to make a SELECT from the drupal database.
Two or three tables
- node (maybe)
I want to find all uid's in the comment table from former users but where the uid>0 in the comment table. uid's for former users but whom don't exist in the users table.
I also would like to make an UPDATE-script that can set all uid's from non-existing users in the comment table to zero "0".
This will solve some of the search indexing problem, where it stopps at certain nodes.
Please help me.