select name, unpolitisch, sehr_links, links, Mitte_links, Mitte_rechts, rechts, konservativ, kronloyal, liberal, grun, Kommunist from 
(select cm.concentration_id as id, count(*) as unpolitisch from concentration_members cm, user_data ud where cm.user_id=ud.id and political=1 group by concentration_id) p1, 
(select cm.concentration_id as id, count(*) as sehr_links from concentration_members cm, user_data ud where cm.user_id=ud.id and political=2 group by concentration_id) p2, 
(select cm.concentration_id as id, count(*) as links from concentration_members cm, user_data ud where cm.user_id=ud.id and political=3 group by concentration_id) p3, 
(select cm.concentration_id as id, count(*) as Mitte_links from concentration_members cm, user_data ud where cm.user_id=ud.id and political=4 group by concentration_id) p4, 
(select cm.concentration_id as id, count(*) as Mitte_rechts from concentration_members cm, user_data ud where cm.user_id=ud.id and political=5 group by concentration_id) p5, 
(select cm.concentration_id as id, count(*) as rechts from concentration_members cm, user_data ud where cm.user_id=ud.id and political=9 group by concentration_id) p9, 
(select cm.concentration_id as id, count(*) as konservativ from concentration_members cm, user_data ud where cm.user_id=ud.id and political=6 group by concentration_id) p6, 
(select cm.concentration_id as id, count(*) as kronloyal from concentration_members cm, user_data ud where cm.user_id=ud.id and political=11 group by concentration_id) p11, 
(select cm.concentration_id as id, count(*) as liberal from concentration_members cm, user_data ud where cm.user_id=ud.id and political=7 group by concentration_id) p7, 
(select cm.concentration_id as id, count(*) as grun from concentration_members cm, user_data ud where cm.user_id=ud.id and political=8 group by concentration_id) p8, 
(select cm.concentration_id as id, count(*) as Kommunist from concentration_members cm, user_data ud where cm.user_id=ud.id and political=10 group by concentration_id) p10, 
concentrations c where c.id=p1.id and c.id=p2.id and c.id=p3.id and c.id=p4.id and c.id=p5.id and c.id=p9.id and c.id=p6.id and c.id=p11.id and c.id=p7.id and c.id=p8.id and c.id=p10.id;