Alex, I enabled debug, and performed several ardp ttsts for that particular role with no success, but in the debug file I found this unique entry (it is normal?):
[01-Apr-2019 13:25:14 UTC] WordPress database error You have an error in your SQL syntax; check the manual that corresponds to your MariaDB server version for the right syntax to use near ‘)’ at line 43 for query
INSERT INTO xxxx_wallets_txs (
blog_id,
category,
tags,
account,
address,
txid,
symbol,
amount,
created_time,
updated_time,
status,
comment
)
SELECT
1 AS blog_id,
‘deposit’ AS category,
‘airdrop ad-5ca21127e86ef’ AS tags,
u.ID AS account,
UUID() AS address,
UUID() AS txid,
‘LTC’ AS symbol,
1.0000000000 + 0.0000000000 * IFNULL( balances.balance, 0) AS amount,
‘2019-04-01 13:25:14’ AS created_time,
‘2019-04-01 13:25:14’ AS updated_time,
‘done’ AS status,
‘Airdrop’ AS comment
FROM
xxxx_users u
LEFT JOIN
(
SELECT
t.account AS account,
SUM( t.amount ) AS balance
FROM
xxxx_wallets_txs t
WHERE
symbol = ‘LTC’
AND status = ‘done’
GROUP BY
t.account
) balances
ON ( balances.account = u.ID ) WHERE u.ID IN () made by require_once(‘wp-admin/admin.php’), do_action(‘admin_init’), WP_Hook->do_action, WP_Hook->apply_filters, Dashed_Slug_Wallets_Airdrop_Settings->do_airdrop