Am rezolvat facind un inner join de genul : select distinct r1.r, r2.r, r3.r, item4 from tabela inner join (select count( * ) r, item4 from tabela where conditie group by item4) r1 on tabela.item4 = r1.item4 .... inner join (...) r2 on tabela.item4 = r2.item4