The balances table is being corrupted about block-explorer HOT 3 CLOSED

SELECT address, one.available AS one, (two.received - two.spent) AS two
FROM
  (SELECT address, received - spent AS available
  FROM  (
      SELECT address, SUM(value) AS spent
      FROM transaction_inputs
      GROUP BY address
    ) s JOIN
    (
      SELECT address, SUM(value) AS received
      FROM transaction_outputs
      GROUP BY address
    ) r USING (address)
  ) one JOIN balances two USING (address)
WHERE one.available <> (two.received - two.spent);

-- 1. Turn the explorer off

-- 2. count number of balances
SELECT COUNT(*)
FROM balances;

-- 3. verify you would write the same amount
SELECT COUNT(*)
FROM
  (
    SELECT address, SUM(value) AS received
    FROM transaction_outputs
    GROUP BY address
  ) r LEFT JOIN (
      SELECT address, SUM(value) AS spent
      FROM transaction_inputs
      GROUP BY address
  ) s USING (address);

-- 4. delete balances, be sure that the explorer is turned off
DELETE FROM balances;

-- 5. insert the balances
INSERT INTO balances
  (
    SELECT address, received, COALESCE(spent, 0) AS spent
    FROM
      (
        SELECT address, SUM(value) AS received
        FROM transaction_outputs
        GROUP BY address
      ) r LEFT JOIN (
          SELECT address, SUM(value) AS spent
          FROM transaction_inputs
          GROUP BY address
      ) s USING (address)
  );

-- 6. verify you have the same amount
SELECT COUNT(*) FROM balances;

-- 7. start the explorer