Syntax Error: Newbie Help

I keep getting errors on certain pages. Where should I look for changes?

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]

Thanks,

Martin