Replicating part of the network profile list for one site

0

Please login or register to vote for this query.

(click on this box to dismiss)

Ukrainian Language

Q&A for linguists, teachers and students of the Ukrainian language

SELECT su.user_id, 
       su.reputation,
       su.question_count,
       su.answer_count
  FROM dbo.sede_users AS su
 INNER JOIN dbo.Users AS u
    ON su.user_id = u.Id
 WHERE su.account_id = ##AccountId:int##
   AND EXISTS 
   (
     SELECT 1 
       FROM dbo.sede_sites
      WHERE database_name = DB_NAME()
        AND site_id = su.site_id
   );

Enter Parameters

Options:
Switch to meta site
loading Hold tight while we fetch your results