| Sql |
select replace(d.valore_n, '"','') as codice_ateco, replace(c.valore_n, '"','') as ragione_sociale , c.partita_iva, 'P.IVA:'||c.partita_iva||'' as partita_iva_desc, a.valore_n as "totalValueOfProduction", substring(b.valore_n from 2 for 10) AS yearenddate, substring(b.valore_n from 2 for 10)::TIMESTAMP AS datetime,
case when z.zona is null then 'ND'
else
replace(z.zona, '"', '') end as zona
from
(SELECT rowid1, vat_number as partita_iva ,campo, valore_n
FROM v_financial_deaggr where campo in ('totalValueOfProduction')
GROUP BY 1,2,3,4) a
left join (SELECT rowid, vat_number as partita_iva ,campo, valore_n
FROM v_financial_deaggr where campo in ('yearEndDate')
GROUP BY 1,2,3,4) b on a.partita_iva=b.partita_iva and a.rowid1=b.rowid
left join (select valore_n, campo, partita_iva, id from public.v_company_deaggr where campo='name' group by 1,2,3,4) c on a.partita_iva=c.partita_iva
left join
(select id,valore_n, campo, partita_iva from public.v_company_deaggr where campo='activityCode' group by 1,2,3,4)d on d.id=c.id
left join
(select valore_n as zona, vat_number as partita_iva from public.v_settlement_deaggr where campo='zona' group by 1,2) z on c.partita_iva=z.partita_iva
|
