You can not select more than 25 topics
Topics must start with a letter or number, can include dashes ('-') and can be up to 35 characters long.
26 lines
393 B
26 lines
393 B
SELECT |
|
user_id, |
|
ip, |
|
max(used_at) AS used_at |
|
FROM ( |
|
SELECT |
|
id AS user_id, |
|
sign_up_ip AS ip, |
|
created_at AS used_at |
|
FROM users |
|
WHERE sign_up_ip IS NOT NULL |
|
UNION ALL |
|
SELECT |
|
user_id, |
|
ip, |
|
updated_at |
|
FROM session_activations |
|
UNION ALL |
|
SELECT |
|
user_id, |
|
ip, |
|
created_at |
|
FROM login_activities |
|
WHERE success = 't' |
|
) AS t0 |
|
GROUP BY user_id, ip
|
|
|