Cannot generate clickthrough report.

[Guest]

Whenever I click the "Clickthrough Report" button in the affiliate area I get this error:

 

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 'select a.*, pd.products_name from affiliate_clickthroughs a

 

select count( select a.*, pd.products_name from affiliate_clickthroughs a left join products p on (p.products_id = a.affiliate_products_id) left join products_description pd on (pd.products_id = p.products_id and pd.language_id = '1') where a.affiliate_id = '1' ORDER BY a.affiliate_clientdate desc ) as total

 

[TEP STOP]

 

Any ideas? Thanks!

-John-