Error: Error executing query

The software returned the following error:

Unknown column 's.id' 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, 0 as already_voted FROM tsl_sites AS s, tsl_users AS u, tsl_emails AS e LEFT JOIN tsl_comments AS c ON c.site = s.id && c.admin_validate = 1 LEFT JOIN tsl_votes AS v ON v.active = 1 && v.site = s.id WHERE s.user = u.id && s.email = e.id && u.blocked = 0 && s.active = 1 && s.admin_validate = 1 && e.validated = 1 && s.category IN ( "0","0","1","2") && s.category_validated = 1 GROUP BY s.id ORDER BY in_count DESC, rating DESC, out_count DESC, name DESC LIMIT 0,10