How do you use those custom tables? As custom post types? Can we see those somehow on your blog (or were they made by some plugin or by yourself)?

Also — what the blog in question? Let us know what exactly are you trying to search for and where have you entered those queries and we'll do our best to help you out! Any additional feedback is greatly appreciated!