| Sql |
select c.valore_n as ragione_sociale ,'P.IVA:'||c.partita_iva||'' as partita_iva_desc, prima.operatingRevenues, seconda.profitOrLossForTheYear, terza.totalPayrollAndRelatedCosts, quarta.totalValueOfProduction, prima.partita_iva, substring(seconda.yearEndDate from 2 for 10) AS yearenddate from
(SELECT a.id, a.partita_iva, a.nome, a.campo, a.valore_n as operatingRevenues, a.user_id, b.valore_n as yearEndDate from
(SELECT rowid, id, partita_iva, nome, campo, valore_n, user_id from v_financial_deaggr a where campo='operatingRevenues') a
left join
(SELECT rowid, id, partita_iva, nome, campo, valore_n, user_id from v_financial_deaggr a where campo='yearEndDate') b on a.rowid=b.rowid
group by 1,2,3,4,5,6,7) prima
join
(SELECT a.id, a.partita_iva, a.nome, a.campo, a.valore_n as profitOrLossForTheYear, a.user_id, b.valore_n as yearEndDate from
(SELECT rowid, id, partita_iva, nome, campo, valore_n, user_id from v_financial_deaggr a where campo='profitOrLossForTheYear') a
left join
(SELECT rowid, id, partita_iva, nome, campo, valore_n, user_id from v_financial_deaggr a where campo='yearEndDate') b on a.rowid=b.rowid
group by 1,2,3,4,5,6,7) seconda on prima.id= seconda.id and prima.partita_iva=seconda.partita_iva and seconda.yearEndDate= prima.yearEndDate
left join
(SELECT a.id, a.partita_iva, a.nome, a.campo, a.valore_n as totalPayrollAndRelatedCosts, a.user_id, b.valore_n as yearEndDate from
(SELECT rowid, id, partita_iva, nome, campo, valore_n, user_id from v_financial_deaggr a where campo='totalPayrollAndRelatedCosts') a
left join
(SELECT rowid, id, partita_iva, nome, campo, valore_n, user_id from v_financial_deaggr a where campo='yearEndDate') b on a.rowid=b.rowid
group by 1,2,3,4,5,6,7) terza on prima.id= terza.id and prima.partita_iva=terza.partita_iva and terza.yearEndDate= prima.yearEndDate
left join
(SELECT a.id, a.partita_iva, a.nome, a.campo, a.valore_n as totalValueOfProduction, a.user_id, b.valore_n as yearEndDate from
(SELECT rowid, id, partita_iva, nome, campo, valore_n, user_id from v_financial_deaggr a where campo='totalValueOfProduction') a
left join
(SELECT rowid, id, partita_iva, nome, campo, valore_n, user_id from v_financial_deaggr a where campo='yearEndDate') b on a.rowid=b.rowid
group by 1,2,3,4,5,6,7) quarta on prima.id= quarta.id and prima.partita_iva=quarta.partita_iva and quarta.yearEndDate= prima.yearEndDate
left join (select valore_n, campo, partita_iva from public.v_company_deaggr where campo='name' group by 1,2,3) c on prima.partita_iva=c.partita_iva;
|
