Show balances of LNbits wallets

get_lnbits_wallet_balances.sql

-- Individual wallets
SELECT wallets.name AS wallet_name, SUM(apipayments.amount - ABS(apipayments.fee)) AS balance FROM apipayments
 INNER JOIN wallets ON apipayments.wallet = wallets.id
 WHERE ((wallets.deleted = FALSE) OR (wallets.deleted IS NULL)) AND
       (((apipayments.status = 'success') AND (apipayments.amount > 0)) OR
        ((apipayments.status IN ('success', 'pending')) AND (apipayments.amount < 0)))
 GROUP BY wallets.name;

-- Total
SELECT SUM(COALESCE(apipayments.amount, 0) - COALESCE(ABS(apipayments.fee), 0)) AS total_balance FROM apipayments
 WHERE (((apipayments.status = 'success') AND (apipayments.amount > 0)) OR
        ((apipayments.status IN ('success', 'pending')) AND (apipayments.amount < 0)));