Rubriken

Can't execute query
select news_rubriken.id as id, news_rubriken.name as name,sum(elements.hits) as hits from elements select value from cache where id='reg_unreg' left join news_rubriken on news_rubriken.id=elements_rubriken.rubrik_id where news_rubriken.name<>'' and group by news_rubriken.id order by hits desc