RgZbwPau

1DROP TABLE IF EXISTS ips;
2CREATE TEMPORARY TABLE ips (user_account_id INTEGER NOT NULL, ip varchar(255) NOT NULL, access_type varchar(32));
3INSERT INTO ips SELECT offer_responder_id, responder_ip, 'access' FROM crypto_trades_completed WHERE responder_ip IS NOT NULL;
4INSERT INTO ips SELECT offer_owner_id, owner_ip, 'access' FROM crypto_trades_completed WHERE owner_ip IS NOT NULL;
5INSERT INTO ips SELECT id, ip_address, 'register' FROM user_accounts WHERE ip_address IS NOT NULL;
6
7SELECT COUNT(DISTINCT ip) FROM ips;
8DROP TABLE ips;