SELECT 'Fornecedores' as tipo, count(*) as qtdd, '16' as expected
FROM fornecedores_empresas
WHERE codigo IN (1, 10, 24, 32, 57, 119, 204, 219, 224, 237, 238, 239, 243, 244, 245, 256);

SELECT 'Despesas' as tipo, count(*) as qtdd, '7' as expected
FROM cadastro_plano_de_contas_itens
WHERE conta_reduzida IN (554, 579, 663, 697, 699, 767, 799);

INSERT INTO financeiro_contas_fornecedores ( --
    fornecedor_id,
    nota_fiscal,
    data,
    valor,
    nome,
    plano_de_contas_id,
--
#     centros_de_custo_cadaris_id,
#     forma_pagamento,
#     boleto,
    pago, -- =1
#     comprovante,
    conta_id, -- =3
    created_at, -- =NOW()
    updated_at -- =NOW()
)
    VALUES --
  ( (SELECT id FROM fornecedores_empresas WHERE codigo = 237 LIMIT 1), '', '2021-01-05', 4999, 'Compra bateria parcela 10/10', (SELECT id FROM cadastro_plano_de_contas_itens WHERE conta_reduzida= 579 LIMIT 1), 1, 3, NOW(), NOW() ),
  ( (SELECT id FROM fornecedores_empresas WHERE codigo = 238 LIMIT 1), '', '2021-01-05', 10000, 'Curso Maris 09/12', (SELECT id FROM cadastro_plano_de_contas_itens WHERE conta_reduzida= 799 LIMIT 1), 1, 3, NOW(), NOW() ),
  ( (SELECT id FROM fornecedores_empresas WHERE codigo = 245 LIMIT 1), '', '2021-01-05', 127491, 'Compra Macbook - Maris -Parc 006/012', NULL, 1, 3, NOW(), NOW() ),
  ( (SELECT id FROM fornecedores_empresas WHERE codigo = 204 LIMIT 1), '', '2021-01-05', 35791, 'Compra Note 04/12', NULL, 1, 3, NOW(), NOW() ),
  ( (SELECT id FROM fornecedores_empresas WHERE codigo = 256 LIMIT 1), '', '2021-01-05', 1600, 'Contratação de ferramenta', (SELECT id FROM cadastro_plano_de_contas_itens WHERE conta_reduzida= 554 LIMIT 1), 1, 3, NOW(), NOW() ),
  ( (SELECT id FROM fornecedores_empresas WHERE codigo = 219 LIMIT 1), '', '2021-01-05', 2840, 'Contratação de ferramenta', (SELECT id FROM cadastro_plano_de_contas_itens WHERE conta_reduzida= 663 LIMIT 1), 1, 3, NOW(), NOW() ),
  ( (SELECT id FROM fornecedores_empresas WHERE codigo = 219 LIMIT 1), '', '2021-01-05', 2290, 'Contratação de ferramenta', (SELECT id FROM cadastro_plano_de_contas_itens WHERE conta_reduzida= 663 LIMIT 1), 1, 3, NOW(), NOW() ),
  ( (SELECT id FROM fornecedores_empresas WHERE codigo = 219 LIMIT 1), '', '2021-01-05', 2290, 'Contratação de ferramenta', (SELECT id FROM cadastro_plano_de_contas_itens WHERE conta_reduzida= 663 LIMIT 1), 1, 3, NOW(), NOW() ),
  ( (SELECT id FROM fornecedores_empresas WHERE codigo = 57 LIMIT 1), '', '2021-01-05', 48542, 'Assinatura Getty images', (SELECT id FROM cadastro_plano_de_contas_itens WHERE conta_reduzida= 697 LIMIT 1), 1, 3, NOW(), NOW() ),
  ( (SELECT id FROM fornecedores_empresas WHERE codigo = 10 LIMIT 1), '', '2021-01-05', 11774, 'Assinatura Locaweb', (SELECT id FROM cadastro_plano_de_contas_itens WHERE conta_reduzida= 699 LIMIT 1), 1, 3, NOW(), NOW() ),
  ( (SELECT id FROM fornecedores_empresas WHERE codigo = 32 LIMIT 1), '', '2021-01-05', 42906, 'Hospedagem', (SELECT id FROM cadastro_plano_de_contas_itens WHERE conta_reduzida= 699 LIMIT 1), 1, 3, NOW(), NOW() ),
  ( (SELECT id FROM fornecedores_empresas WHERE codigo = 32 LIMIT 1), '', '2021-01-05', 30463, 'Hospedagem', (SELECT id FROM cadastro_plano_de_contas_itens WHERE conta_reduzida= 699 LIMIT 1), 1, 3, NOW(), NOW() ),
  ( (SELECT id FROM fornecedores_empresas WHERE codigo = 32 LIMIT 1), '', '2021-01-05', 12443, 'Hospedagem', (SELECT id FROM cadastro_plano_de_contas_itens WHERE conta_reduzida= 699 LIMIT 1), 1, 3, NOW(), NOW() ),
  ( (SELECT id FROM fornecedores_empresas WHERE codigo = 119 LIMIT 1), '', '2021-01-05', 6473, 'Anúncio TPO', (SELECT id FROM cadastro_plano_de_contas_itens WHERE conta_reduzida= 767 LIMIT 1), 1, 3, NOW(), NOW() ),
  ( (SELECT id FROM fornecedores_empresas WHERE codigo = 119 LIMIT 1), '', '2021-01-05', 699, 'Hospedagem', NULL, 1, 3, NOW(), NOW() ),
  ( (SELECT id FROM fornecedores_empresas WHERE codigo = 239 LIMIT 1), '', '2021-01-05', 13350, '', NULL, 1, 3, NOW(), NOW() ),
  ( (SELECT id FROM fornecedores_empresas WHERE codigo = 24 LIMIT 1), '', '2021-01-05', 92100, 'Hospedagem', NULL, 1, 3, NOW(), NOW() ),
  ( (SELECT id FROM fornecedores_empresas WHERE codigo = 243 LIMIT 1), '', '2021-01-05', 7990, 'Reportei', (SELECT id FROM cadastro_plano_de_contas_itens WHERE conta_reduzida= 554 LIMIT 1), 1, 3, NOW(), NOW() ),
  ( (SELECT id FROM fornecedores_empresas WHERE codigo = 244 LIMIT 1), '', '2021-01-05', 8050, 'Contratação de ferramenta', NULL, 1, 3, NOW(), NOW() ),
  ( (SELECT id FROM fornecedores_empresas WHERE codigo = 239 LIMIT 1), '', '2021-01-05', 13425, 'Hospedagem', NULL, 1, 3, NOW(), NOW() ),
  ( (SELECT id FROM fornecedores_empresas WHERE codigo = 256 LIMIT 1), '', '2021-01-05', 1600, 'Contratação de ferramenta', NULL, 1, 3, NOW(), NOW() ),
  ( (SELECT id FROM fornecedores_empresas WHERE codigo = 256 LIMIT 1), '', '2021-01-05', 1600, 'Contratação de ferramenta', NULL, 1, 3, NOW(), NOW() ),
  ( (SELECT id FROM fornecedores_empresas WHERE codigo = 219 LIMIT 1), '', '2021-01-05', 2840, 'Contratação de ferramenta', NULL, 1, 3, NOW(), NOW() ),
  ( (SELECT id FROM fornecedores_empresas WHERE codigo = 224 LIMIT 1), '', '2021-01-05', 4500, 'Anuidade cartão', NULL, 1, 3, NOW(), NOW() ),
  ( (SELECT id FROM fornecedores_empresas WHERE codigo = 1 LIMIT 1), '', '2021-01-05', 306, 'IOF', NULL, 1, 3, NOW(), NOW() ),
  ( (SELECT id FROM fornecedores_empresas WHERE codigo = 1 LIMIT 1), '', '2021-01-05', 7698, 'Custo transf.exterior - IOF', NULL, 1, 3, NOW(), NOW() ),
  ( (SELECT id FROM fornecedores_empresas WHERE codigo = 238 LIMIT 1), '', '2021-02-05', 10000, 'Curso Maris 10/12', (SELECT id FROM cadastro_plano_de_contas_itens WHERE conta_reduzida= 799 LIMIT 1), 1, 3, NOW(), NOW() ),
  ( (SELECT id FROM fornecedores_empresas WHERE codigo = 245 LIMIT 1), '', '2021-02-05', 127491, 'Compra Macbook - Maris -Parc 007/012', NULL, 1, 3, NOW(), NOW() ),
  ( (SELECT id FROM fornecedores_empresas WHERE codigo = 204 LIMIT 1), '', '2021-02-05', 35791, 'Compra Note 05/12', NULL, 1, 3, NOW(), NOW() ),
  ( (SELECT id FROM fornecedores_empresas WHERE codigo = 238 LIMIT 1), '', '2021-03-05', 10000, 'Curso Maris 11/12', (SELECT id FROM cadastro_plano_de_contas_itens WHERE conta_reduzida= 799 LIMIT 1), 1, 3, NOW(), NOW() ),
  ( (SELECT id FROM fornecedores_empresas WHERE codigo = 245 LIMIT 1), '', '2021-03-05', 127491, 'Compra Macbook - Maris -Parc 008/012', NULL, 1, 3, NOW(), NOW() ),
  ( (SELECT id FROM fornecedores_empresas WHERE codigo = 204 LIMIT 1), '', '2021-03-05', 35791, 'Compra Note 06/12', NULL, 1, 3, NOW(), NOW() ),
  ( (SELECT id FROM fornecedores_empresas WHERE codigo = 238 LIMIT 1), '', '2021-04-05', 10000, 'Curso Maris 12/12', (SELECT id FROM cadastro_plano_de_contas_itens WHERE conta_reduzida= 799 LIMIT 1), 1, 3, NOW(), NOW() ),
  ( (SELECT id FROM fornecedores_empresas WHERE codigo = 245 LIMIT 1), '', '2021-04-05', 127491, 'Compra Macbook - Maris -Parc 009/012', NULL, 1, 3, NOW(), NOW() ),
  ( (SELECT id FROM fornecedores_empresas WHERE codigo = 204 LIMIT 1), '', '2021-04-05', 35791, 'Compra Note 07/12', NULL, 1, 3, NOW(), NOW() ),
  ( (SELECT id FROM fornecedores_empresas WHERE codigo = 245 LIMIT 1), '', '2021-05-05', 127491, 'Compra Macbook - Maris -Parc 10/012', NULL, 1, 3, NOW(), NOW() ),
  ( (SELECT id FROM fornecedores_empresas WHERE codigo = 204 LIMIT 1), '', '2021-05-05', 35791, 'Compra Note 08/12', NULL, 1, 3, NOW(), NOW() );
