Untitled attachment

Notices where this attachment appears

1. Embed this notice
   :blank: (i@declin.eu)'s status on Friday, 13-Sep-2024 05:16:34 JST :blank:

   in reply to
   @j @lanodan @hj probably easier to run two queries than complicate the sql futher
   
   select concat(nickname, '@bae.st') from users join (select following_id from following_relationships where follower_id = (select id from users where nickname = 'CHANGEME')) as _user on users.id = _user.following_id where users.local = 't';
   select nickname from users join (select following_id from following_relationships where follower_id = (select id from users where nickname = 'CHANGEME')) as _user on users.id = _user.following_id where users.local = 'f';
2. Embed this notice
   shitpisscum (shitpisscum@mrhands.horse)'s status on Friday, 13-Sep-2024 05:16:32 JST shitpisscum

   in reply to
   @i @j @lanodan @hj
   >easier to run two queries
   Why not just union these queries?
   
   select concat(nickname, '@bae.st')
   from users
   join (
   select following_id
   from following_relationships
   where follower_id = (
   select id
   from users
   where nickname = 'CHANGEME'
   )
   ) as _user on users.id = _user.following_id
   where users.local = 't'
   union
   select nickname
   from users
   join (
   select following_id
   from following_relationships
   where follower_id = (
   select id
   from users
   where nickname = 'CHANGEME'
   )
   ) as _user on users.id = _user.following_id
   where users.local = 'f';