Aaron's top 5 sites by reputation

0

Please login or register to vote for this query.

(click on this box to dismiss)

Earth Science

Q&A for those interested in the geology, meteorology, oceanography, and environmental sciences

SELECT TOP (5) ss.site_name,
               profile = CONCAT(ss.site_url, '/u/', su.user_id),
               su.reputation,
               su.question_count,
               su.answer_count
   FROM dbo.sede_users AS su
  INNER JOIN dbo.sede_sites AS ss
     ON su.site_id = ss.site_id
  WHERE su.account_id = ##AccountId:int##
  ORDER BY su.reputation DESC;

Enter Parameters

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