find followers and follows not on lists

find-followers-and-follows-not-on-lists.sql

with data as (
  select
    l.title as list,
    a.*
  from
    mastodon_list l
  join
    mastodon_list_account a
  on
    l.id = a.list_id
), 
no_list_following as (
  select
    d.list,
    f.id,
    f.username,
    f.display_name
  from 
    mastodon_following f
  left join
    data d
  on
    f.id = d.id
  where
    list is null
),
no_list_followers as (
  select
    d.list,
    f.id,
    f.username,
    f.display_name
  from 
    mastodon_followers f
  left join
    data d
  on
    f.id = d.id
  where
    list is null
)
select * from no_list_following
union
select * from no_list_followers
order by id