Mail ERRORS, using Subscribe contribution

[Fluffy Bunny]

Send Email To Customers
Warning: constant() [function.constant]: Couldn't find constant TABLE_SUBSCRIBERS in /home/performa/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.

Whats wrong with this?

Thanx

[Fluffy Bunny]

Please help

[brandtim]

What version of ZenCart are you using? What version of MySQL and PHP?

Do you have any add-ons installed?

BrandTim

[Fluffy Bunny]

What version of ZenCart are you using? What version of MySQL and PHP?

Do you have any add-ons installed?

BrandTim

1.3.7 Latest

Got Add-ons

Not sure now what other versions of the others, will check on my other PC.