No Article added as yet

select *, avg(rated) as abcde from rating,addarticle where rating.articleid=addarticle.articleid and addarticle.articleactivation='1' GROUP BY rating.articleid order by abcde desc LIMIT 0,10