Get User Profile does not show the following

[dxps]

Hi!

First of all, that's a nice project structure! 👍

Just playing with it and discovered that /api/profiles/:username always returns "following": false whether a token is provided or not in the standard Authorization.

Meanwhile, I'll keep looking for the root cause.

[dxps]

The problem is that the generated SQL is:

SELECT u.*, EXISTS (
        SELECT "fu"."user_id", "fu"."followed_user_id" FROM "follow_users" AS "fu" 
        WHERE (fu.followed_user_id = u.id) AND (fu.user_id = 31)
    ) AS following FROM "users" AS "u" WHERE (username = 'joe')

And actually this should be:

SELECT u.*, EXISTS (
       SELECT "fu"."user_id", "fu"."followed_user_id" FROM "follow_users" AS "fu", "users" AS "u"
       WHERE (fu.followed_user_id = u.id) AND (fu.user_id = 31)
   ) AS following FROM "users" AS "u" WHERE (username = 'joe')