I am getting this error when i try to send my customers and email from the admin section of site.
"Warning: constant() [function.constant]: Couldn't find constant TABLE_SUBSCRIBERS in /home/XXXXXXXXX/public_html/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 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 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."