SELECT
  lm.ano,
  lm.mes,
  c.nome,
  tc.nome AS cargo,
  COALESCE(lm.valor,0) AS Subsidio,
  COALESCE((SELECT SUM(valor) FROM lancamentomes WHERE verba IN (187) AND ano = lm.ano AND mes = lm.mes AND prontuario = lm.prontuario ),0) AS AbonoPermanencia,
  COALESCE((SELECT SUM(valor) FROM lancamentomes WHERE verba IN (30102,147) AND ano = lm.ano AND mes = lm.mes AND prontuario = lm.prontuario ),0) AS DireitosPessoais,
  COALESCE((SELECT SUM(valor) FROM lancamentomes WHERE verba IN (162,163) AND ano = lm.ano AND mes = lm.mes AND prontuario = lm.prontuario ),0) AS ExercicioCargo,
  COALESCE((SELECT SUM(valor) FROM lancamentomes WHERE verba IN (112) AND ano = lm.ano AND mes = lm.mes AND prontuario = lm.prontuario ),0) AS ExercicioCumulativo,
COALESCE((SELECT SUM(valor) FROM lancamentomes WHERE verba IN (202) AND ano = lm.ano AND mes = lm.mes AND prontuario = lm.prontuario ),0) AS GratificacaoNatalina,
COALESCE((SELECT SUM(valor) FROM lancamentomes WHERE verba IN (215) AND ano = lm.ano AND mes = lm.mes AND prontuario = lm.prontuario ),0) AS TercoFerias,
COALESCE((SELECT SUM(valor) FROM lancamentomes WHERE verba IN (213,214) AND ano = lm.ano AND mes = lm.mes AND prontuario = lm.prontuario ),0) AS AbonoFerias,
COALESCE((SELECT SUM(valor) FROM lancamentomes WHERE verba IN (SELECT codigo FROM tabelaverbas WHERE nome LIKE 'Dif%') AND ano = lm.ano AND mes = lm.mes AND prontuario = lm.prontuario ),0) AS PagamentosRetroativos,
COALESCE((SELECT SUM(valor) FROM lancamentomes WHERE verba IN (164,165) AND ano = lm.ano AND mes = lm.mes AND prontuario = lm.prontuario ),0) AS DirecaoPromotoria,
COALESCE((SELECT SUM(valor) FROM lancamentomes WHERE verba IN (30259) AND ano = lm.ano AND mes = lm.mes AND prontuario = lm.prontuario ),0) AS AuxilioMoradia,
COALESCE((SELECT SUM(valor) FROM lancamentomes WHERE verba IN (257) AND ano = lm.ano AND mes = lm.mes AND prontuario = lm.prontuario ),0) AS AuxilioAlimentacao,
COALESCE((SELECT SUM(valor) FROM lancamentomes WHERE verba IN (189) AND ano = lm.ano AND mes = lm.mes AND prontuario = lm.prontuario ),0) AS AjudaDeCusto,
COALESCE((SELECT SUM(valor) FROM lancamentomes WHERE verba IN (241) AND ano = lm.ano AND mes = lm.mes AND prontuario = lm.prontuario ),0) AS GratEncargoCursoConcurso,
0 AS Bruto,
0 AS RetencaoTeto,
COALESCE((SELECT SUM(valor) FROM lancamentomes WHERE verba IN (985) AND ano = lm.ano AND mes = lm.mes AND prontuario = lm.prontuario ),0) AS IRPF,
COALESCE((SELECT SUM(valor) FROM lancamentomes WHERE verba IN (982) AND ano = lm.ano AND mes = lm.mes AND prontuario = lm.prontuario ),0) AS Previdencia,
0 AS TotalDescontos,
0 AS Líquido
FROM
 cadastro c
 JOIN
 tabelacargo tc ON c.plano = tc.cargo AND c.nivel = tc.nivel AND tc.categoria = 'membro'
 JOIN
 lancamentomes lm ON c.matricula = lm.prontuario AND lm.verba = 102 AND lm.folha = 1
WHERE
  dbo.intanomes(lm.ano,lm.mes) >= 201609
  AND
  dbo.intanomes(lm.ano,lm.mes) <= 201708

ORDER BY
  lm.ano,
  lm.mes,
  c.nome