Database error 
        select au.user_id, au.type, au.title, au.title_url, au.title_url_new
        from tbl__userlike ul
        join vw__all_users_full au
        on au.type = ul.from_resident_type and au.user_id = ul.from_resident_id
        where to_resident_type = 'area' and to_resident_id = 7974
        and au.active = 1 and au.registration_confirmed = 1