BP
Size: a a a
H
ПП
NC
NC
A
BP
NC
A
BP
NC
ПП
NC
NC
BP
S
select
case when from = username then to else from end as username
from friends where from = username or to = username
annotate(username=Case(When(friend_from__username=username, then='friend_to__username'),
When(friend_to__username=username, then='friend_from__username'))
BP
NC
BP
NC