select * from users where exists (select 1 from follower where followee=uid) and not exists ( select 1 from follower where followee=uid and not exists ( select 1 from rechirp, chirp a, chirp o where rechirp=a.cid and orginal=o.cid and a.author=followee and o.author=follower ) )
(
select 1 from follower where followee=uid and not exists
(
select 1 from rechirp, chirp a, chirp o where rechirp=a.cid and orginal=o.cid and a.author=followee and o.author=follower
)
)