select e60_numemp, e60_codemp, e60_anousu, dl_caixa_escolar, e60_vlremp, cota_01,cota_02,cota_03,cota_04,cota_05,cota_06, cota_07,cota_08,cota_09,cota_10,cota_11,cota_12, anulacaocota_01,anulacaocota_02,anulacaocota_03,anulacaocota_04, anulacaocota_05,anulacaocota_06,anulacaocota_07,anulacaocota_08, anulacaocota_09,anulacaocota_10,anulacaocota_11,anulacaocota_12 from (select cartao.sequencial, cartao.nome, caixa.z01_nome as dl_caixa_escolar, e60_numemp, e60_codemp, e60_anousu, e60_vlremp, (select e05_valor from empenhocotamensal where e05_numemp = empempenho.e60_numemp and e05_mes = 1) as cota_01, (coalesce((select valoranulado from empenhocotamensal inner join plugins.empenhocotamensalanulacao on e05_sequencial = empenhocotamensal where e05_numemp = empempenho.e60_numemp and e05_mes = 1), 0)) as anulacaocota_01, (select e05_valor from empenhocotamensal where e05_numemp = empempenho.e60_numemp and e05_mes = 2) as cota_02, (coalesce((select valoranulado from empenhocotamensal inner join plugins.empenhocotamensalanulacao on e05_sequencial = empenhocotamensal where e05_numemp = empempenho.e60_numemp and e05_mes = 2), 0)) as anulacaocota_02, (select e05_valor from empenhocotamensal where e05_numemp = empempenho.e60_numemp and e05_mes = 3) as cota_03, (coalesce((select valoranulado from empenhocotamensal inner join plugins.empenhocotamensalanulacao on e05_sequencial = empenhocotamensal where e05_numemp = empempenho.e60_numemp and e05_mes = 3), 0)) as anulacaocota_03, (select e05_valor from empenhocotamensal where e05_numemp = empempenho.e60_numemp and e05_mes = 4) as cota_04, (coalesce((select valoranulado from empenhocotamensal inner join plugins.empenhocotamensalanulacao on e05_sequencial = empenhocotamensal where e05_numemp = empempenho.e60_numemp and e05_mes = 4), 0)) as anulacaocota_04, (select e05_valor from empenhocotamensal where e05_numemp = empempenho.e60_numemp and e05_mes = 5) as cota_05, (coalesce((select valoranulado from empenhocotamensal inner join plugins.empenhocotamensalanulacao on e05_sequencial = empenhocotamensal where e05_numemp = empempenho.e60_numemp and e05_mes = 5), 0)) as anulacaocota_05, (select e05_valor from empenhocotamensal where e05_numemp = empempenho.e60_numemp and e05_mes = 6) as cota_06, (coalesce((select valoranulado from empenhocotamensal inner join plugins.empenhocotamensalanulacao on e05_sequencial = empenhocotamensal where e05_numemp = empempenho.e60_numemp and e05_mes = 6), 0)) as anulacaocota_06, (select e05_valor from empenhocotamensal where e05_numemp = empempenho.e60_numemp and e05_mes = 7) as cota_07, (coalesce((select valoranulado from empenhocotamensal inner join plugins.empenhocotamensalanulacao on e05_sequencial = empenhocotamensal where e05_numemp = empempenho.e60_numemp and e05_mes = 7), 0)) as anulacaocota_07, (select e05_valor from empenhocotamensal where e05_numemp = empempenho.e60_numemp and e05_mes = 8) as cota_08, (coalesce((select valoranulado from empenhocotamensal inner join plugins.empenhocotamensalanulacao on e05_sequencial = empenhocotamensal where e05_numemp = empempenho.e60_numemp and e05_mes = 8), 0)) as anulacaocota_08, (select e05_valor from empenhocotamensal where e05_numemp = empempenho.e60_numemp and e05_mes = 9) as cota_09, (coalesce((select valoranulado from empenhocotamensal inner join plugins.empenhocotamensalanulacao on e05_sequencial = empenhocotamensal where e05_numemp = empempenho.e60_numemp and e05_mes = 9), 0)) as anulacaocota_09, (select e05_valor from empenhocotamensal where e05_numemp = empempenho.e60_numemp and e05_mes = 10) as cota_10, (coalesce((select valoranulado from empenhocotamensal inner join plugins.empenhocotamensalanulacao on e05_sequencial = empenhocotamensal where e05_numemp = empempenho.e60_numemp and e05_mes = 10), 0)) as anulacaocota_10, (select e05_valor from empenhocotamensal where e05_numemp = empempenho.e60_numemp and e05_mes = 11) as cota_11, (coalesce((select valoranulado from empenhocotamensal inner join plugins.empenhocotamensalanulacao on e05_sequencial = empenhocotamensal where e05_numemp = empempenho.e60_numemp and e05_mes = 11), 0)) as anulacaocota_11, (select e05_valor from empenhocotamensal where e05_numemp = empempenho.e60_numemp and e05_mes = 12) as cota_12, (coalesce((select valoranulado from empenhocotamensal inner join plugins.empenhocotamensalanulacao on e05_sequencial = empenhocotamensal where e05_numemp = empempenho.e60_numemp and e05_mes = 12), 0)) as anulacaocota_12 from plugins.pnaecartao cartao inner join cgm caixa on cartao.cgmcaixaescola = caixa.z01_numcgm inner join empempenho on caixa.z01_numcgm = e60_numcgm and not exists (select empempenho from plugins.pnaecartaoempenho where empempenho = e60_numemp) and (e60_vlremp-e60_vlranu) > 0 and e60_anousu = 2020 where cartao.sequencial = 158) T