Cannot execute: 
				SELECT a.id, a.title, a.filename, a.description, d.username, AVG( c.rating ) AS avg_rating, a.visitors AS video_views
				FROM tbl_videos a
				RIGHT JOIN rel_videos2tags v2t ON v2t.movie_id = a.id
                RIGHT JOIN tbl_tags t ON t.id = v2t.tag_id 
				LEFT JOIN tbl_ratings c ON a.id = c.item_id
				JOIN tbl_profiles d ON a.owner = d.userid
				WHERE LCASE(t.tag) = 'петер'
				GROUP BY a.id
				ORDER BY video_views DESC, avg_rating DESC