SELECT 'Fornecedores' as tipo, count(DISTINCT codigo) as qtdd, '1' as expected
FROM fornecedores_empresas
WHERE codigo IN (0);

SELECT 'Despesas' as tipo, count(DISTINCT conta_reduzida) as qtdd, '1' as expected
FROM cadastro_plano_de_contas_itens
WHERE conta_reduzida IN (624);

INSERT INTO financeiro_contas_fornecedores ( --
    nome,
    data,
    fornecedor_id,
    valor,
    plano_de_contas_id,
    centros_de_custo_cadaris_id,
--
#     nota_fiscal,
#     forma_pagamento,
#     boleto,
    pago, -- =1
#     comprovante,
    conta_id, -- =3
    created_at, -- =NOW()
    updated_at -- =NOW()
)
    VALUES --
  ( 'Assinatura Office 365 Personal (1 mês)', '2018-03-31', (SELECT id FROM fornecedores_empresas WHERE codigo = 0 LIMIT 1), 2400, (SELECT id FROM cadastro_plano_de_contas_itens WHERE conta_reduzida = 624 LIMIT 1), 9, 1, 10, NOW(), NOW() ),
  ( 'Assinatura Office 365 Personal (1 mês)', '2018-05-30', (SELECT id FROM fornecedores_empresas WHERE codigo = 0 LIMIT 1), 2400, (SELECT id FROM cadastro_plano_de_contas_itens WHERE conta_reduzida = 624 LIMIT 1), 9, 1, 10, NOW(), NOW() ),
  ( 'Pagamento Gesop', '2018-06-08', (SELECT id FROM fornecedores_empresas WHERE codigo = 0 LIMIT 1), 150000, (SELECT id FROM cadastro_plano_de_contas_itens WHERE conta_reduzida = 624 LIMIT 1), 9, 1, 10, NOW(), NOW() ),
  ( 'Assinatura Office 365 Personal (1 mês)', '2018-06-30', (SELECT id FROM fornecedores_empresas WHERE codigo = 0 LIMIT 1), 2400, (SELECT id FROM cadastro_plano_de_contas_itens WHERE conta_reduzida = 624 LIMIT 1), 9, 1, 10, NOW(), NOW() ),
  ( 'Assinatura Office 365 Personal (1 mês)', '2018-07-30', (SELECT id FROM fornecedores_empresas WHERE codigo = 0 LIMIT 1), 2400, (SELECT id FROM cadastro_plano_de_contas_itens WHERE conta_reduzida = 624 LIMIT 1), 9, 1, 10, NOW(), NOW() ),
  ( 'Assinatura Office 365 Personal (1 mês)', '2018-08-30', (SELECT id FROM fornecedores_empresas WHERE codigo = 0 LIMIT 1), 2400, (SELECT id FROM cadastro_plano_de_contas_itens WHERE conta_reduzida = 624 LIMIT 1), 9, 1, 10, NOW(), NOW() ),
  ( 'Assinatura Office 365 Personal (1 mês)', '2018-09-30', (SELECT id FROM fornecedores_empresas WHERE codigo = 0 LIMIT 1), 2400, (SELECT id FROM cadastro_plano_de_contas_itens WHERE conta_reduzida = 624 LIMIT 1), 9, 1, 10, NOW(), NOW() ),
  ( 'Pagamento Rafa - Fev - Mar - Abr', '2019-05-29', (SELECT id FROM fornecedores_empresas WHERE codigo = 0 LIMIT 1), 90000, (SELECT id FROM cadastro_plano_de_contas_itens WHERE conta_reduzida = 624 LIMIT 1), 9, 1, 10, NOW(), NOW() ),
  ( 'Assinatura Office 365 Personal (1 mês)', '2019-06-30', (SELECT id FROM fornecedores_empresas WHERE codigo = 0 LIMIT 1), 2400, (SELECT id FROM cadastro_plano_de_contas_itens WHERE conta_reduzida = 624 LIMIT 1), 9, 1, 10, NOW(), NOW() ),
  ( 'Pagamento Michael', '2019-07-03', (SELECT id FROM fornecedores_empresas WHERE codigo = 0 LIMIT 1), 450000, (SELECT id FROM cadastro_plano_de_contas_itens WHERE conta_reduzida = 624 LIMIT 1), 9, 1, 10, NOW(), NOW() ),
  ( 'Assinatura Office 365 Personal (1 mês)', '2019-07-30', (SELECT id FROM fornecedores_empresas WHERE codigo = 0 LIMIT 1), 2400, (SELECT id FROM cadastro_plano_de_contas_itens WHERE conta_reduzida = 624 LIMIT 1), 9, 1, 10, NOW(), NOW() ),
  ( 'Assinatura Office 365 Personal (1 mês)', '2019-08-31', (SELECT id FROM fornecedores_empresas WHERE codigo = 0 LIMIT 1), 2400, (SELECT id FROM cadastro_plano_de_contas_itens WHERE conta_reduzida = 624 LIMIT 1), 9, 1, 10, NOW(), NOW() ),
  ( 'Assinatura Office 365 Personal (1 mês)', '2019-09-30', (SELECT id FROM fornecedores_empresas WHERE codigo = 0 LIMIT 1), 2400, (SELECT id FROM cadastro_plano_de_contas_itens WHERE conta_reduzida = 624 LIMIT 1), 9, 1, 10, NOW(), NOW() ),
  ( 'Assinatura Office 365 Personal (1 mês)', '2019-10-31', (SELECT id FROM fornecedores_empresas WHERE codigo = 0 LIMIT 1), 2400, (SELECT id FROM cadastro_plano_de_contas_itens WHERE conta_reduzida = 624 LIMIT 1), 9, 1, 10, NOW(), NOW() ),
  ( 'Assinatura Office 365 Personal (1 mês)', '2019-11-30', (SELECT id FROM fornecedores_empresas WHERE codigo = 0 LIMIT 1), 2400, (SELECT id FROM cadastro_plano_de_contas_itens WHERE conta_reduzida = 624 LIMIT 1), 9, 1, 10, NOW(), NOW() ),
  ( 'Assinatura Office 365 Personal (1 mês)', '2019-12-30', (SELECT id FROM fornecedores_empresas WHERE codigo = 0 LIMIT 1), 2400, (SELECT id FROM cadastro_plano_de_contas_itens WHERE conta_reduzida = 624 LIMIT 1), 9, 1, 10, NOW(), NOW() ),
  ( 'Assinatura Office 365 Personal (1 mês)', '2020-01-31', (SELECT id FROM fornecedores_empresas WHERE codigo = 0 LIMIT 1), 2400, (SELECT id FROM cadastro_plano_de_contas_itens WHERE conta_reduzida = 624 LIMIT 1), 9, 1, 10, NOW(), NOW() ),
  ( 'Assinatura Office 365 Personal (1 mês)', '2020-02-28', (SELECT id FROM fornecedores_empresas WHERE codigo = 0 LIMIT 1), 2400, (SELECT id FROM cadastro_plano_de_contas_itens WHERE conta_reduzida = 624 LIMIT 1), 9, 1, 10, NOW(), NOW() ),
  ( 'Assinatura Office 365 Personal (1 mês)', '2020-03-31', (SELECT id FROM fornecedores_empresas WHERE codigo = 0 LIMIT 1), 2400, (SELECT id FROM cadastro_plano_de_contas_itens WHERE conta_reduzida = 624 LIMIT 1), 9, 1, 10, NOW(), NOW() ),
  ( 'Pagamento Rafa', '2020-04-16', (SELECT id FROM fornecedores_empresas WHERE codigo = 0 LIMIT 1), 30000, (SELECT id FROM cadastro_plano_de_contas_itens WHERE conta_reduzida = 624 LIMIT 1), 9, 1, 10, NOW(), NOW() ),
  ( 'Assinatura Office 365 Personal (1 mês)', '2020-04-30', (SELECT id FROM fornecedores_empresas WHERE codigo = 0 LIMIT 1), 2400, (SELECT id FROM cadastro_plano_de_contas_itens WHERE conta_reduzida = 624 LIMIT 1), 9, 1, 10, NOW(), NOW() ),
  ( 'Assinatura Office 365 Personal (1 mês)', '2020-05-30', (SELECT id FROM fornecedores_empresas WHERE codigo = 0 LIMIT 1), 2400, (SELECT id FROM cadastro_plano_de_contas_itens WHERE conta_reduzida = 624 LIMIT 1), 9, 1, 10, NOW(), NOW() ),
  ( 'Fone de Ouvido Clarisse', '2020-06-27', (SELECT id FROM fornecedores_empresas WHERE codigo = 0 LIMIT 1), 9056, (SELECT id FROM cadastro_plano_de_contas_itens WHERE conta_reduzida = 624 LIMIT 1), 9, 1, 10, NOW(), NOW() ),
  ( 'Assinatura Office 365 Personal (1 mês)', '2020-06-30', (SELECT id FROM fornecedores_empresas WHERE codigo = 0 LIMIT 1), 2400, (SELECT id FROM cadastro_plano_de_contas_itens WHERE conta_reduzida = 624 LIMIT 1), 9, 1, 10, NOW(), NOW() ),
  ( 'Assinatura Office 365 Personal (1 mês)', '2020-07-30', (SELECT id FROM fornecedores_empresas WHERE codigo = 0 LIMIT 1), 2400, (SELECT id FROM cadastro_plano_de_contas_itens WHERE conta_reduzida = 624 LIMIT 1), 9, 1, 10, NOW(), NOW() ),
  ( 'Assinatura Office 365 Personal (1 mês)', '2020-08-31', (SELECT id FROM fornecedores_empresas WHERE codigo = 0 LIMIT 1), 2400, (SELECT id FROM cadastro_plano_de_contas_itens WHERE conta_reduzida = 624 LIMIT 1), 9, 1, 10, NOW(), NOW() ),
  ( 'Assinatura Office 365 Personal (1 mês)', '2020-09-30', (SELECT id FROM fornecedores_empresas WHERE codigo = 0 LIMIT 1), 2400, (SELECT id FROM cadastro_plano_de_contas_itens WHERE conta_reduzida = 624 LIMIT 1), 9, 1, 10, NOW(), NOW() ),
  ( 'Assinatura Office 365 Personal (1 mês)', '2020-10-30', (SELECT id FROM fornecedores_empresas WHERE codigo = 0 LIMIT 1), 2400, (SELECT id FROM cadastro_plano_de_contas_itens WHERE conta_reduzida = 624 LIMIT 1), 9, 1, 10, NOW(), NOW() ),
  ( 'Assinatura Office 365 Personal (1 mês)', '2020-11-30', (SELECT id FROM fornecedores_empresas WHERE codigo = 0 LIMIT 1), 2400, (SELECT id FROM cadastro_plano_de_contas_itens WHERE conta_reduzida = 624 LIMIT 1), 9, 1, 10, NOW(), NOW() ),
  ( 'Desconto reembolso Harada', '2020-12-01', (SELECT id FROM fornecedores_empresas WHERE codigo = 0 LIMIT 1), 125873, (SELECT id FROM cadastro_plano_de_contas_itens WHERE conta_reduzida = 624 LIMIT 1), 9, 1, 10, NOW(), NOW() ),
  ( 'Assinatura Office 365 Personal (1 mês)', '2020-12-30', (SELECT id FROM fornecedores_empresas WHERE codigo = 0 LIMIT 1), 2400, (SELECT id FROM cadastro_plano_de_contas_itens WHERE conta_reduzida = 624 LIMIT 1), 9, 1, 10, NOW(), NOW() ),
  ( 'Desconto reembolso Harada', '2021-01-20', (SELECT id FROM fornecedores_empresas WHERE codigo = 0 LIMIT 1), 100000, (SELECT id FROM cadastro_plano_de_contas_itens WHERE conta_reduzida = 624 LIMIT 1), 9, 1, 10, NOW(), NOW() ),
  ( 'Assinatura Office 365 Personal (1 mês)', '2021-01-30', (SELECT id FROM fornecedores_empresas WHERE codigo = 0 LIMIT 1), 2400, (SELECT id FROM cadastro_plano_de_contas_itens WHERE conta_reduzida = 624 LIMIT 1), 9, 1, 10, NOW(), NOW() ),
  ( 'Desconto reembolso Harada', '2021-02-20', (SELECT id FROM fornecedores_empresas WHERE codigo = 0 LIMIT 1), 200000, (SELECT id FROM cadastro_plano_de_contas_itens WHERE conta_reduzida = 624 LIMIT 1), 9, 1, 10, NOW(), NOW() ),
  ( 'Assinatura Office 365 Personal (1 mês)', '2021-02-28', (SELECT id FROM fornecedores_empresas WHERE codigo = 0 LIMIT 1), 2400, (SELECT id FROM cadastro_plano_de_contas_itens WHERE conta_reduzida = 624 LIMIT 1), 9, 1, 10, NOW(), NOW() ),
  ( 'Desconto reembolso Harada', '2021-03-20', (SELECT id FROM fornecedores_empresas WHERE codigo = 0 LIMIT 1), 200000, (SELECT id FROM cadastro_plano_de_contas_itens WHERE conta_reduzida = 624 LIMIT 1), 9, 1, 10, NOW(), NOW() ),
  ( 'Assinatura Office 365 Personal (1 mês)', '2021-03-30', (SELECT id FROM fornecedores_empresas WHERE codigo = 0 LIMIT 1), 2400, (SELECT id FROM cadastro_plano_de_contas_itens WHERE conta_reduzida = 624 LIMIT 1), 9, 1, 10, NOW(), NOW() ),
  ( 'Serviços Jurídicos Lassori', '2021-03-30', (SELECT id FROM fornecedores_empresas WHERE codigo = 0 LIMIT 1), 500000, (SELECT id FROM cadastro_plano_de_contas_itens WHERE conta_reduzida = 624 LIMIT 1), 9, 1, 10, NOW(), NOW() ),
  ( 'Desconto reembolso Harada', '2021-04-20', (SELECT id FROM fornecedores_empresas WHERE codigo = 0 LIMIT 1), 200000, (SELECT id FROM cadastro_plano_de_contas_itens WHERE conta_reduzida = 624 LIMIT 1), 9, 1, 10, NOW(), NOW() ),
  ( 'Assinatura Office 365 Personal (1 mês)', '2021-04-30', (SELECT id FROM fornecedores_empresas WHERE codigo = 0 LIMIT 1), 2400, (SELECT id FROM cadastro_plano_de_contas_itens WHERE conta_reduzida = 624 LIMIT 1), 9, 1, 10, NOW(), NOW() );
