由hudongyang 更新于 2018-04-26 20:51
1.1、统计了rails项目(repo_id=1334)中一共具有11085条issues(SQL语句:SELECT * FROM `issues` WHERE repo_id=1334 AND pull_request=0;)。
1.2、rails项目中11085条issues一共有62704条comments(SQL语句:SELECT * FROM `issue_comments` WHERE issue_id in (SELECT id FROM issues_1334);)
1.3、62704条comments一共有9371个不同的users进行评论(SQL语句:SELECT DISTINCT user_id FROM `issue_comments_1334`; )
1.4、9371个users中有2952个users会对不同的issues进行评论。2952/9371=31.5%
2.1、统计了Khan/khan-exercises项目(repo_id=10408)中一共具有139229条issues(SQL语句:SELECT * FROM `issues` WHERE repo_id=10408 AND pull_request=0;)。
2.2、Khan/khan-exercises项目中139229条issues一共有91947条comments(SQL语句:SELECT * FROM `issue_comments` WHERE issue_id in (SELECT id FROM issues_10408);)
2.3、91947条comments一共有个688不同的users进行评论(SQL语句:SELECT DISTINCT user_id FROM `issue_comments_1334`; )
2.4、688个users中有316个users会对不同的issues进行评论。316/688=45.9%
3.1、统计了TrinityCore/TrinityCore项目(repo_id=1717)中一共具有17532条issues(SQL语句:SELECT * FROM `issues` WHERE repo_id=1717 AND pull_request=0;)。
3.2、TrinityCore/TrinityCore项目中17532条issues一共有条80067comments(SQL语句:SELECT * FROM `issue_comments` WHERE issue_id in (SELECT id FROM issues_1717);)
3.3、80067条comments一共有2788个不同的users进行评论(SQL语句:SELECT DISTINCT user_id FROM `issue_comments_1717`; )
3.4、2788个users中有1657个users会对不同的issues进行评论。1657/2788=59.4%
4.1、统计了saltstack/salt项目(repo_id=1142)中一共具有17465条issues(SQL语句:SELECT * FROM `issues` WHERE repo_id=1717 AND pull_request=0;)。
4.2、saltstack/salt项目中17465条issues一共有93205条comments(SQL语句:SELECT * FROM `issue_comments` WHERE issue_id in (SELECT id FROM issues_1142);)
4.3、93205条comments一共有5494个不同的users进行评论(SQL语句:SELECT DISTINCT user_id FROM `issue_comments_1334`; )
2.4、5494个users中有2601个users会对不同的issues进行评论。2601/5494=47.3%
1.1、统计了rails项目(repo_id=1334)中一共具有11085条issues(SQL语句:SELECT * FROM `issues` WHERE repo_id=1334 AND pull_request=0;)。
1.2、rails项目中11085条issues一共有62704条comments(SQL语句:SELECT * FROM `issue_comments` WHERE issue_id in (SELECT id FROM issues_1334);)
1.3、62704条comments一共有9371个不同的users进行评论(SQL语句:SELECT DISTINCT user_id FROM `issue_comments_1334`; )
1.4、9371个users中有2952个users会对不同的issues进行评论。2952/9371=31.5%
2.1、统计了Khan/khan-exercises项目(repo_id=10408)中一共具有139229条issues(SQL语句:SELECT * FROM `issues` WHERE repo_id=10408 AND pull_request=0;)。
2.2、Khan/khan-exercises项目中139229条issues一共有91947条comments(SQL语句:SELECT * FROM `issue_comments` WHERE issue_id in (SELECT id FROM issues_10408);)
2.3、91947条comments一共有个688不同的users进行评论(SQL语句:SELECT DISTINCT user_id FROM `issue_comments_1334`; )
2.4、688个users中有316个users会对不同的issues进行评论。316/688=45.9%
3.1、统计了TrinityCore/TrinityCore项目(repo_id=1717)中一共具有17532条issues(SQL语句:SELECT * FROM `issues` WHERE repo_id=1717 AND pull_request=0;)。
3.2、TrinityCore/TrinityCore项目中17532条issues一共有条80067comments(SQL语句:SELECT * FROM `issue_comments` WHERE issue_id in (SELECT id FROM issues_1717);)
3.3、80067条comments一共有2788个不同的users进行评论(SQL语句:SELECT DISTINCT user_id FROM `issue_comments_1717`; )
3.4、2788个users中有1657个users会对不同的issues进行评论。1657/2788=59.4%
4.1、统计了saltstack/salt项目(repo_id=1142)中一共具有17465条issues(SQL语句:SELECT * FROM `issues` WHERE repo_id=1717 AND pull_request=0;)。
4.2、saltstack/salt项目中17465条issues一共有93205条comments(SQL语句:SELECT * FROM `issue_comments` WHERE issue_id in (SELECT id FROM issues_1142);)
4.3、93205条comments一共有5494个不同的users进行评论(SQL语句:SELECT DISTINCT user_id FROM `issue_comments_1334`; )
2.4、5494个users中有2601个users会对不同的issues进行评论。2601/5494=47.3%