I suspect that query is being generated by Views. I can't find a reference to "SELECT count(" anywhere, and I always use "AS" with my table aliases. Since the problem is in the WHERE clause, I suspect a Filter is messed up in some way. The part after the AND looks like the "Is a product" filter, so I would check your View definition around that area. If it looks alright, you may have to put an issue in to the RelatedContent queue. I can't make heads or tails out of that code to be of much help.