Error trying to send email

Using 1.3.8a
No upgrades since 1.3.8a came out. No add-ons. No customizations except the template.

When I go to tools -> send email I get the following:

Send Email To Customers Text Editor Plain TextHTMLarea

Warning: constant() [function.constant]: Couldn't find constant TABLE_SUBSCRIBERS in /home6/ourldssp/public_html/MFTCSeminars/includes/functions/audience.php on line 113

1064 You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'as s left join zen_customers as c on c.customers_id = s.customers_id' at line 1
in:
[select c.customers_firstname, c.customers_lastname, s.email_address as customers_email_address from as s left join zen_customers as c on c.customers_id = s.customers_id ]
If you were entering information, press the BACK button in your browser and re-check the information you had entered to be sure you left no blank fields.

I did redownload the file it is referring to and put a fresh copy on my site, but it made no difference. I was considering upgrading to 1.3.9. Will that fix this issue?

Thanx in advance.

You've half-installed a "newsletter subscribe" module, but you're missing updates to at least one file, namely the one that defines TABLE_SUBSCRIBERS.

If you're going to use the addon, you need it fully installed.
If you're not going to use it, you need to fully remove it.

I thought I had completely removed it. Any idea what I may have missed?

It seems as though it's made an SQL update to the query_builder table, which you'll need to reverse.

I do appreciate your assistance. I have no idea how to do that. Any iea what record from what tables I need to remove? Or is there an uninstall document I missed?

I guess you'll have to just find the record that mentions TABLE_SUBSCRIBERS and delete it.