Re: Trying to get categories and relational table information in one query

[laptop alias]

That should be appended to your LEFT JOIN...

Something like this, although line 2 may not now be quite right...

SELECT DiSTINCT t.*
              , COALESCE(ut.user_id = ut.user_id,0) linked 
           FROM tags t 
           LEFT 
           JOIN users_tags ut 
             ON ut.tag_id = t.tag_id
            AND ut.user_id = 3;