EXPLAIN 
SELECT 
			e.id, 
			c.name,
			c.name as cat_name, 
			c.id as catid, 
			e.freigeschaltet, 
			e.beschreibung, 
			e.poster, 
			e.poster_hp, 
			e.hits, 
			(sum(v.vote)/count(v.vote)) as roundedRating 
FROM 
			link_entries e, 
			link_cats c, 
			link_voting v 
WHERE 
				c.id = e.cat_id 
			AND c.id = "3" 
			AND v.link_id = e.id 
			AND flag = "1" 
			AND freigeschaltet < 1142353931 
GROUP BY 
			e.id 
ORDER BY 
			freigeschaltet desc 
LIMIT 		0, 30

EXPLAIN
SELECT
			e.id,
			c.name,
			c.name as cat_name,
			c.id as catid,
			e.freigeschaltet,
			e.beschreibung,
			e.poster,
			e.poster_hp,
			e.hits,
			(sum(v.vote)/count(v.vote)) as roundedRating
FROM
			link_entries e,
		
JOIN link_cats AS c 
			ON e.cat_id = c.id
			WHERE  c.id = 3

JOIN link_voting AS v
			ON e.id = v.link_id

WHERE	
			e.flag = 1
		AND e.freigeschaltet < 1142353931	 
		
GROUP BY
			e.id
ORDER BY
			freigeschaltet desc
LIMIT     
			0, 30

#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 'JOIN link_cats AS c
    ON e.cat_id = c.id

JOIN link_voting AS v
    ON e.id =' at line 15