Error: Error executing query

The software returned the following error:

Unknown column 's.category' in 'on clause'

Query Executed: SELECT s.*,COUNT(DISTINCT c.id) as comment_count, AVG(v.value) as rating,COUNT(DISTINCT v.id) as num_votes,COUNT(DISTINCT me.id) as already_voted FROM tsl_sites AS s, tsl_users AS u, tsl_emails AS e LEFT JOIN tsl_categories AS cat ON cat.id = s.category LEFT JOIN tsl_votes AS v ON v.site = s.id LEFT JOIN tsl_ip_address AS ipa ON ipa.address = "38.103.63.17" LEFT JOIN tsl_ip_records AS ipr ON ipr.id = ipa.record LEFT JOIN tsl_votes AS me ON me.site = s.id && me.ip_record = ipr.id LEFT JOIN tsl_comments AS c ON c.site = s.id && c.admin_validate = 1 WHERE s.user = u.id && s.email = e.id && u.blocked = 0 && s.active = 1 && s.admin_validate = 1 && e.validated = 1 GROUP BY s.id ORDER BY in_count DESC, rating DESC, out_count DESC, name DESC LIMIT 0,10