67 transactionSQL:SELECT t1.transaction_id, t1.user_id, t1.balance, t2.user_login, t3.meta_value, t4.meta_value
FROM pow_woo_wallet_transactions AS t1,
pow_users AS t2,
pow_usermeta AS t3,
pow_usermeta AS t4
WHERE t2.ID = t1.user_id
  AND t3.user_id = t1.user_id
  AND t4.user_id = t1.user_id
  AND t3.meta_key = '_current_woo_wallet_balance'
  AND t3.meta_value > '0'
  AND t4.meta_key = 'pow_capabilities'
  AND t4.meta_value NOT LIKE '%observer%'
  AND t1.balance = t3.meta_value
ORDER BY t2.user_login DESC,
  t1.transaction_id ASC<br /><pre>Array
(
)
</pre>