Conversation

Notices

1. Jake (formerly sjw) :lain_sneed: (j@bae.st)'s status on Friday, 04-Oct-2024 00:59:43 JST Jake (formerly sjw) :lain_sneed:

   • Haelwenn /элвэн/ :triskell:
   • Proud owner of a potato sack :flag:
   @lanodan @hj what would be the postgres query to export a user's followers?
   • :blank: (i@declin.eu)'s status on Friday, 04-Oct-2024 00:59:42 JST :blank:

     in reply to

     • Haelwenn /элвэн/ :triskell:
     • Proud owner of a potato sack :flag:
     @j @lanodan @hj this
     
     select ap_id from users join (select following_id from following_relationships where follower_id = (select id from users where nickname = 'CHANGE ME')) as _user on users.id = _user.following_id;
   • Jake (formerly sjw) :lain_sneed: (j@bae.st)'s status on Friday, 04-Oct-2024 01:00:02 JST Jake (formerly sjw) :lain_sneed:

     in reply to

     • Haelwenn /элвэн/ :triskell:
     • Proud owner of a potato sack :flag:
     • :blank:

     @i @lanodan @hj I just got

     ERROR: column "nepiant" does not exist