This is an old revision of the document!
<< Back to List of Activity Metrics
Number of watchers
select count(user_id) as num_watchers, projects.name as project_name, url from watchers join projects on watchers.repo_id = projects.id group by projects.id