本日のぽんこつSQL。h12oさんとこ、弊ぼっちで既知のアカウントはいくつかあるけど、
> SELECT id,username,domain,moved_to_account_id FROM accounts WHERE domain IN ('blessedgeeks.social','blessedgeeks.org') ORDER BY username;
id | username | domain | moved_to_account_id
-------+---------------------+---------------------+---------------------
51101 | applechinfo | blessedgeeks.social |
72850 | blessedgeeks.org | blessedgeeks.org |
52354 | blessedgeeks.social | blessedgeeks.social |
2420 | h12o | blessedgeeks.org |
48970 | h12o | blessedgeeks.social | 2420
63287 | IPAjp | blessedgeeks.social |
49810 | jpcert | blessedgeeks.social |
49830 | JVNiPedia | blessedgeeks.social |
54226 | jvnjp | blessedgeeks.social |
(9 rows)
フォロー被フォロー関係はすでに引っ越し済と思っていいっぽいのかな:
> SELECT follows.account_id,follows.target_account_id FROM accounts INNER JOIN follows ON follows.account_id = accounts.id AND accounts.domain IN ('blessedgeeks.social','blessedgeeks.org');
id | target_account_id
------+-------------------
2420 | 1
(1 row)
> SELECT follows.account_id,follows.target_account_id FROM accounts INNER JOIN follows ON follows.target_account_id = accounts.id AND accounts.domain IN ('blessedgeeks.social','blessedgeeks.org');
account_id | target_account_id
------------+-------------------
1 | 2420
(1 row)