Remove Ghost domains

[paranoidcookie]

I have a some records in my databases from domains deleted, I remember someone posted a series of sql scripts to remove orphaned records.

I have searched the forum but I can seem to find it, can someone point me in the right direction please?

Regards

John