This is an automated email from the ASF dual-hosted git repository.
eldenmoon pushed a commit to branch master
in repository https://gitbox.apache.org/repos/asf/doris.git
The following commit(s) were added to refs/heads/master by this push:
new ce60064573e [regression-test](variant) fix unstable query result m…
(#28390)
ce60064573e is described below
commit ce60064573ef7082512508461669b883072cd8e5
Author: lihangyu <15605149...@163.com>
AuthorDate: Fri Dec 15 10:52:50 2023 +0800
[regression-test](variant) fix unstable query result m… (#28390)
* [regression-test](variant) fix unstable query result for unique key model
* fix p2 case
* add msg
---
regression-test/data/variant_p2/load.out | 2 +-
.../variant_p2/sql/authorsWithTheMostPushes.out | 90 +++++++++----------
.../data/variant_p2/sql/countingStar1.out | 2 +-
.../data/variant_p2/sql/countingStar2.out | 2 +-
.../data/variant_p2/sql/countingStar3.out | 2 +-
.../sql/distributionOfRepositoriesByStarCount.out | 9 +-
...heListOfTopRepositoriesChangedOverTheYears1.out | 100 ++++++++++-----------
...heListOfTopRepositoriesChangedOverTheYears2.out | 100 ++++++++++-----------
...heListOfTopRepositoriesChangedOverTheYears3.out | 100 ++++++++++-----------
...heListOfTopRepositoriesChangedOverTheYears4.out | 100 ++++++++++-----------
...heListOfTopRepositoriesChangedOverTheYears5.out | 100 ++++++++++-----------
...heListOfTopRepositoriesChangedOverTheYears6.out | 100 ++++++++++-----------
...heListOfTopRepositoriesChangedOverTheYears7.out | 20 ++---
.../howHasTheTotalNumberOfStarsChangedOverTime.out | 2 +-
.../variant_p2/sql/issuesWithTheMostComments1.out | 2 +-
.../variant_p2/sql/issuesWithTheMostComments2.out | 82 ++++++++---------
.../variant_p2/sql/issuesWithTheMostComments3.out | 82 ++++++++---------
.../variant_p2/sql/issuesWithTheMostComments4.out | 24 ++---
.../variant_p2/sql/issuesWithTheMostComments5.out | 24 ++---
.../variant_p2/sql/issuesWithTheMostComments6.out | 42 ++++-----
.../variant_p2/sql/issuesWithTheMostComments7.out | 64 ++++++-------
.../data/variant_p2/sql/mostForkedRepositories.out | 92 +++++++++----------
.../variant_p2/sql/mostPopularCommentsOnGithub.out | 2 +-
.../sql/organizationsByTheNumberOfRepositories.out | 22 ++---
.../sql/organizationsByTheNumberOfStars.out | 100 ++++++++++-----------
.../sql/organizationsByTheSizeOfCommunity.out | 10 +--
.../sql/proportionsBetweenStarsAndForks1.out | 94 +++++++++----------
.../sql/proportionsBetweenStarsAndForks2.out | 90 +++++++++----------
.../sql/proportionsBetweenStarsAndForks3.out | 48 +++++-----
.../sql/proportionsBetweenStarsAndForks4.out | 2 +-
.../sql/proportionsBetweenStarsAndForks5.out | 2 +-
...epositoriesWithClickhouse_related_comments1.out | 26 +++---
...epositoriesWithClickhouse_related_comments2.out | 100 ++++++++++-----------
.../repositoriesWithDoris_related_comments1.out | 24 ++---
.../repositoriesWithDoris_related_comments2.out | 100 ++++++++++-----------
.../repositoriesWithTheMaximumAmountOfIssues1.out | 38 ++++----
.../repositoriesWithTheMaximumAmountOfIssues2.out | 44 ++++-----
.../repositoriesWithTheMaximumAmountOfIssues3.out | 90 +++++++++----------
.../repositoriesWithTheMaximumAmountOfIssues4.out | 90 +++++++++----------
...sitoriesWithTheMaximumAmountOfPullRequests2.out | 94 +++++++++----------
...esWithTheMaximumNumberOfAcceptedInvitations.out | 18 ++--
...sitoriesWithTheMostPeopleWhoHavePushAccess1.out | 2 +-
...sitoriesWithTheMostPeopleWhoHavePushAccess2.out | 4 +-
...sitoriesWithTheMostPeopleWhoHavePushAccess3.out | 92 +++++++++----------
.../repositoriesWithTheMostStarsOverOneDay1.out | 100 ++++++++++-----------
.../repositoriesWithTheMostStarsOverOneDay2.out | 100 ++++++++++-----------
.../repositoriesWithTheMostStarsOverOneDay3.out | 100 ++++++++++-----------
.../repositoriesWithTheWorstStagnation_order.out | 6 +-
.../variant_p2/sql/repositoryAffinityList2.out | 100 ++++++++++-----------
regression-test/data/variant_p2/sql/sql02.out | 2 +-
regression-test/data/variant_p2/sql/sql03.out | 2 +-
regression-test/data/variant_p2/sql/sql06.out | 2 +-
.../variant_p2/sql/theLongestRepositoryNames2.out | 12 +--
.../variant_p2/sql/theMostToughCodeReviews.out | 34 +++----
.../sql/theTotalNumberOfRepositoriesOnGithub.out | 2 +-
.../sql/theTotalNumberOfUsersOnGithub1.out | 2 +-
.../sql/theTotalNumberOfUsersOnGithub2.out | 2 +-
.../sql/theTotalNumberOfUsersOnGithub3.out | 2 +-
.../sql/theTotalNumberOfUsersOnGithub4.out | 2 +-
.../data/variant_p2/sql/topRepositoriesByStars.out | 100 ++++++++++-----------
.../sql/whatIsTheBestDayOfTheWeekToCatchAStar.out | 14 +--
.../sql/whoAreAllThosePeopleGivingStars1.out | 76 ++++++++--------
regression-test/suites/variant_p0/load.groovy | 2 +-
regression-test/suites/variant_p2/load.groovy | 1 +
64 files changed, 1447 insertions(+), 1447 deletions(-)
diff --git a/regression-test/data/variant_p2/load.out
b/regression-test/data/variant_p2/load.out
index 86df6f121ec..f3dbb78d8dd 100644
--- a/regression-test/data/variant_p2/load.out
+++ b/regression-test/data/variant_p2/load.out
@@ -1,4 +1,4 @@
-- This file is automatically generated. You should know what you did if you
want to edit this
-- !sql --
-44273863
+43774586
diff --git a/regression-test/data/variant_p2/sql/authorsWithTheMostPushes.out
b/regression-test/data/variant_p2/sql/authorsWithTheMostPushes.out
index 569a84d202f..2b2c2c39f58 100644
--- a/regression-test/data/variant_p2/sql/authorsWithTheMostPushes.out
+++ b/regression-test/data/variant_p2/sql/authorsWithTheMostPushes.out
@@ -1,53 +1,53 @@
-- This file is automatically generated. You should know what you did if you
want to edit this
-- !authorsWithTheMostPushes --
-KenanSulayman 150218 31
-greatfirebot 102604 4
-mirror-updates 84117 42
-greatfire 45199 2
-rydnr 43285 18
-pbaffiliate1 41473 6
-chapuni 35820 18
-asfgit 34623 391
-meatballhat 31119 57
-direwolf-github 28690 1
-openstack-gerrit 28358 473
+KenanSulayman 148195 31
+greatfirebot 101632 4
+mirror-updates 82983 42
+greatfire 44348 2
+rydnr 42980 18
+pbaffiliate1 41467 6
+chapuni 35522 18
+asfgit 34333 391
+meatballhat 31115 57
+direwolf-github 28478 1
+openstack-gerrit 28187 473
diversify-exp-user 25708 2
-dsm-git 25470 73
-wmst 23587 1
-qdm 21165 1
-cn-nytimes 20415 1
-wmfgerrit 19150 761
-maomihz 18291 2
-lukeis 17764 11
-cato- 16394 8
-efa2000 16010 6
-hubot 15856 306
-pluginmirror-worker 15692 3283
-k-okada 13944 86
+dsm-git 25258 73
+wmst 23314 1
+qdm 20649 1
+cn-nytimes 20175 1
+wmfgerrit 18974 761
+maomihz 18039 2
+lukeis 17569 11
+cato- 16177 8
+efa2000 16007 6
+hubot 15723 306
+pluginmirror-worker 15614 3276
pbaffiliatetwoop 13892 3
-timmmmyboy 12912 11
-gnomesysadmins 12742 383
-micahyoung 12368 5
-InternetDevels 12344 3
+k-okada 13795 86
+timmmmyboy 12744 11
+gnomesysadmins 12615 383
+micahyoung 12206 5
+InternetDevels 12182 3
bmorganatlas 12018 2
-keum 11906 11
-eotect 11367 7
-kinlane 11248 67
+keum 11782 11
+kinlane 11239 67
alma-dev 11224 1369
-hwine 11116 16
-alexcrichton 10976 85
-abeta 9648 9
+eotect 11195 7
+hwine 11018 16
+alexcrichton 10895 85
+abeta 9490 8
brucemcpherson 9277 95
-xinwendashibaike 8915 5
-cmsbuild 8713 4
-kodekloud 7819 30
-uqs 7748 3
-malevolm 7578 3
-unicoremachina 7550 152
-linphone-sync-bot 7542 22
-angelventura 7392 6
-xndcn 7226 9
-designerwebhosting 7131 8
-swegener 7076 2
-CocoaPodsBot 6650 3
+xinwendashibaike 8826 5
+cmsbuild 8603 4
+kodekloud 7811 30
+uqs 7637 3
+malevolm 7546 3
+unicoremachina 7490 152
+linphone-sync-bot 7474 22
+angelventura 7223 6
+xndcn 7092 9
+designerwebhosting 7061 8
+swegener 7004 2
+Accountz-DEV 6618 6
diff --git a/regression-test/data/variant_p2/sql/countingStar1.out
b/regression-test/data/variant_p2/sql/countingStar1.out
index f60d8e64831..d91ef32da45 100644
--- a/regression-test/data/variant_p2/sql/countingStar1.out
+++ b/regression-test/data/variant_p2/sql/countingStar1.out
@@ -1,4 +1,4 @@
-- This file is automatically generated. You should know what you did if you
want to edit this
-- !countingStar1 --
-3951085
+3901627
diff --git a/regression-test/data/variant_p2/sql/countingStar2.out
b/regression-test/data/variant_p2/sql/countingStar2.out
index 8c140a93000..0048ffe86bc 100644
--- a/regression-test/data/variant_p2/sql/countingStar2.out
+++ b/regression-test/data/variant_p2/sql/countingStar2.out
@@ -1,4 +1,4 @@
-- This file is automatically generated. You should know what you did if you
want to edit this
-- !countingStar2 --
-started 3951085
+started 3901627
diff --git a/regression-test/data/variant_p2/sql/countingStar3.out
b/regression-test/data/variant_p2/sql/countingStar3.out
index d447b2edd8a..b83ab1c4645 100644
--- a/regression-test/data/variant_p2/sql/countingStar3.out
+++ b/regression-test/data/variant_p2/sql/countingStar3.out
@@ -1,4 +1,4 @@
-- This file is automatically generated. You should know what you did if you
want to edit this
-- !countingStar3 --
-4925
+4826
diff --git
a/regression-test/data/variant_p2/sql/distributionOfRepositoriesByStarCount.out
b/regression-test/data/variant_p2/sql/distributionOfRepositoriesByStarCount.out
index 6a067f9a3a4..8dfc672cdca 100644
---
a/regression-test/data/variant_p2/sql/distributionOfRepositoriesByStarCount.out
+++
b/regression-test/data/variant_p2/sql/distributionOfRepositoriesByStarCount.out
@@ -1,8 +1,7 @@
-- This file is automatically generated. You should know what you did if you
want to edit this
-- !distributionOfRepositoriesByStarCount --
-1 523331
-10 42165
-100 5258
-1000 270
-10000 1
+1 519549
+10 41828
+100 5180
+1000 269
diff --git
a/regression-test/data/variant_p2/sql/howHasTheListOfTopRepositoriesChangedOverTheYears1.out
b/regression-test/data/variant_p2/sql/howHasTheListOfTopRepositoriesChangedOverTheYears1.out
index b6b264b11ff..62b9d1fcdcc 100644
---
a/regression-test/data/variant_p2/sql/howHasTheListOfTopRepositoriesChangedOverTheYears1.out
+++
b/regression-test/data/variant_p2/sql/howHasTheListOfTopRepositoriesChangedOverTheYears1.out
@@ -1,53 +1,53 @@
-- This file is automatically generated. You should know what you did if you
want to edit this
-- !howHasTheListOfTopRepositoriesChangedOverTheYears1 --
-facebook/react-native 10021
-phanan/htaccess 7964
-alex/what-happens-when 7407
-facebook/react 6762
-moklick/frontend-stuff 6528
-prakhar1989/awesome-courses 6110
-yaronn/blessed-contrib 5880
-arasatasaygin/is.js 5498
-vhf/free-programming-books 5437
-tiimgreen/github-cheat-sheet 5420
-gorhill/uBlock 5415
-Flipboard/react-canvas 5187
-h5bp/Front-end-Developer-Interview-Questions 5177
-sdelements/lets-chat 5045
-iojs/io.js 4866
-bendc/frontend-guidelines 4696
-twbs/bootstrap 4475
-getify/You-Dont-Know-JS 4344
-0xAX/linux-insides 4220
-IanLunn/Hover 4102
-dotnet/coreclr 4049
-daniel-lundin/snabbt.js 3996
-angular/angular.js 3942
-Mango/slideout 3866
-twostairs/paperwork 3684
-Dogfalo/materialize 3664
-libreboard/libreboard 3469
-mbostock/d3 3422
-Selz/plyr 3403
-USArmyResearchLab/Dshell 3401
-LeaVerou/awesomplete 3390
-MengTo/Spring 3276
-muut/riotjs 3244
-wasabeef/awesome-android-ui 3225
-airbnb/javascript 3155
-sophron/wifiphisher 3142
-KeyboardFire/mkcast 3134
-google/fonts 3122
-mikechau/react-primer-draft 3044
-jhauswald/sirius 3030
-sbstjn/timesheet.js 3005
-github/gitignore 2926
-torvalds/linux 2907
-IonicaBizau/git-stats 2896
-googlesamples/android-UniversalMusicPlayer 2838
-nwjs/nw.js 2829
-primer/primer 2816
-lukehoban/es6features 2810
-FortAwesome/Font-Awesome 2798
-driftyco/ionic 2783
+facebook/react-native 9918
+phanan/htaccess 7954
+alex/what-happens-when 7307
+facebook/react 6696
+moklick/frontend-stuff 6466
+prakhar1989/awesome-courses 5998
+yaronn/blessed-contrib 5779
+arasatasaygin/is.js 5493
+vhf/free-programming-books 5395
+tiimgreen/github-cheat-sheet 5315
+gorhill/uBlock 5299
+Flipboard/react-canvas 5174
+h5bp/Front-end-Developer-Interview-Questions 5134
+sdelements/lets-chat 5039
+iojs/io.js 4729
+bendc/frontend-guidelines 4655
+twbs/bootstrap 4428
+getify/You-Dont-Know-JS 4315
+0xAX/linux-insides 4171
+dotnet/coreclr 4042
+IanLunn/Hover 3983
+daniel-lundin/snabbt.js 3925
+angular/angular.js 3893
+Mango/slideout 3834
+Dogfalo/materialize 3636
+twostairs/paperwork 3465
+USArmyResearchLab/Dshell 3398
+libreboard/libreboard 3388
+Selz/plyr 3381
+LeaVerou/awesomplete 3379
+mbostock/d3 3376
+MengTo/Spring 3270
+muut/riotjs 3203
+wasabeef/awesome-android-ui 3154
+KeyboardFire/mkcast 3133
+google/fonts 3104
+airbnb/javascript 3091
+sophron/wifiphisher 3067
+mikechau/react-primer-draft 3039
+jhauswald/sirius 3010
+sbstjn/timesheet.js 2982
+IonicaBizau/git-stats 2894
+github/gitignore 2869
+torvalds/linux 2856
+googlesamples/android-UniversalMusicPlayer 2819
+primer/primer 2807
+nwjs/nw.js 2796
+lukehoban/es6features 2785
+FortAwesome/Font-Awesome 2758
+wishstudio/flinux 2754
diff --git
a/regression-test/data/variant_p2/sql/howHasTheListOfTopRepositoriesChangedOverTheYears2.out
b/regression-test/data/variant_p2/sql/howHasTheListOfTopRepositoriesChangedOverTheYears2.out
index 1f82eb03fa8..e7668cb8b0b 100644
---
a/regression-test/data/variant_p2/sql/howHasTheListOfTopRepositoriesChangedOverTheYears2.out
+++
b/regression-test/data/variant_p2/sql/howHasTheListOfTopRepositoriesChangedOverTheYears2.out
@@ -1,53 +1,53 @@
-- This file is automatically generated. You should know what you did if you
want to edit this
-- !howHasTheListOfTopRepositoriesChangedOverTheYears2 --
-facebook/react-native 10021
-phanan/htaccess 7964
-alex/what-happens-when 7407
-facebook/react 6762
-moklick/frontend-stuff 6528
-prakhar1989/awesome-courses 6110
-yaronn/blessed-contrib 5880
-arasatasaygin/is.js 5498
-vhf/free-programming-books 5437
-tiimgreen/github-cheat-sheet 5420
-gorhill/uBlock 5415
-Flipboard/react-canvas 5187
-h5bp/Front-end-Developer-Interview-Questions 5177
-sdelements/lets-chat 5045
-iojs/io.js 4866
-bendc/frontend-guidelines 4696
-twbs/bootstrap 4475
-getify/You-Dont-Know-JS 4344
-0xAX/linux-insides 4220
-IanLunn/Hover 4102
-dotnet/coreclr 4049
-daniel-lundin/snabbt.js 3996
-angular/angular.js 3942
-Mango/slideout 3866
-twostairs/paperwork 3684
-Dogfalo/materialize 3664
-libreboard/libreboard 3469
-mbostock/d3 3422
-Selz/plyr 3403
-USArmyResearchLab/Dshell 3401
-LeaVerou/awesomplete 3390
-MengTo/Spring 3276
-muut/riotjs 3244
-wasabeef/awesome-android-ui 3225
-airbnb/javascript 3155
-sophron/wifiphisher 3142
-KeyboardFire/mkcast 3134
-google/fonts 3122
-mikechau/react-primer-draft 3044
-jhauswald/sirius 3030
-sbstjn/timesheet.js 3005
-github/gitignore 2926
-torvalds/linux 2907
-IonicaBizau/git-stats 2896
-googlesamples/android-UniversalMusicPlayer 2838
-nwjs/nw.js 2829
-primer/primer 2816
-lukehoban/es6features 2810
-FortAwesome/Font-Awesome 2798
-driftyco/ionic 2783
+facebook/react-native 9918
+phanan/htaccess 7954
+alex/what-happens-when 7307
+facebook/react 6696
+moklick/frontend-stuff 6466
+prakhar1989/awesome-courses 5998
+yaronn/blessed-contrib 5779
+arasatasaygin/is.js 5493
+vhf/free-programming-books 5395
+tiimgreen/github-cheat-sheet 5315
+gorhill/uBlock 5299
+Flipboard/react-canvas 5174
+h5bp/Front-end-Developer-Interview-Questions 5134
+sdelements/lets-chat 5039
+iojs/io.js 4729
+bendc/frontend-guidelines 4655
+twbs/bootstrap 4428
+getify/You-Dont-Know-JS 4315
+0xAX/linux-insides 4171
+dotnet/coreclr 4042
+IanLunn/Hover 3983
+daniel-lundin/snabbt.js 3925
+angular/angular.js 3893
+Mango/slideout 3834
+Dogfalo/materialize 3636
+twostairs/paperwork 3465
+USArmyResearchLab/Dshell 3398
+libreboard/libreboard 3388
+Selz/plyr 3381
+LeaVerou/awesomplete 3379
+mbostock/d3 3376
+MengTo/Spring 3270
+muut/riotjs 3203
+wasabeef/awesome-android-ui 3154
+KeyboardFire/mkcast 3133
+google/fonts 3104
+airbnb/javascript 3091
+sophron/wifiphisher 3067
+mikechau/react-primer-draft 3039
+jhauswald/sirius 3010
+sbstjn/timesheet.js 2982
+IonicaBizau/git-stats 2894
+github/gitignore 2869
+torvalds/linux 2856
+googlesamples/android-UniversalMusicPlayer 2819
+primer/primer 2807
+nwjs/nw.js 2796
+lukehoban/es6features 2785
+FortAwesome/Font-Awesome 2758
+wishstudio/flinux 2754
diff --git
a/regression-test/data/variant_p2/sql/howHasTheListOfTopRepositoriesChangedOverTheYears3.out
b/regression-test/data/variant_p2/sql/howHasTheListOfTopRepositoriesChangedOverTheYears3.out
index 8b3156f98fa..997a79a8af1 100644
---
a/regression-test/data/variant_p2/sql/howHasTheListOfTopRepositoriesChangedOverTheYears3.out
+++
b/regression-test/data/variant_p2/sql/howHasTheListOfTopRepositoriesChangedOverTheYears3.out
@@ -1,53 +1,53 @@
-- This file is automatically generated. You should know what you did if you
want to edit this
-- !howHasTheListOfTopRepositoriesChangedOverTheYears3 --
-facebook/react-native 10021
-phanan/htaccess 7964
-alex/what-happens-when 7407
-facebook/react 6762
-moklick/frontend-stuff 6528
-prakhar1989/awesome-courses 6110
-yaronn/blessed-contrib 5880
-arasatasaygin/is.js 5498
-vhf/free-programming-books 5437
-tiimgreen/github-cheat-sheet 5420
-gorhill/uBlock 5415
-Flipboard/react-canvas 5187
-h5bp/Front-end-Developer-Interview-Questions 5177
-sdelements/lets-chat 5045
-iojs/io.js 4866
-bendc/frontend-guidelines 4696
-twbs/bootstrap 4475
-getify/You-Dont-Know-JS 4344
-0xAX/linux-insides 4220
-IanLunn/Hover 4102
-dotnet/coreclr 4049
-daniel-lundin/snabbt.js 3996
-angular/angular.js 3942
-Mango/slideout 3866
-twostairs/paperwork 3684
-Dogfalo/materialize 3664
-libreboard/libreboard 3469
-mbostock/d3 3422
-Selz/plyr 3403
-USArmyResearchLab/Dshell 3401
-LeaVerou/awesomplete 3390
-MengTo/Spring 3276
-muut/riotjs 3244
-wasabeef/awesome-android-ui 3225
-airbnb/javascript 3155
-sophron/wifiphisher 3142
-KeyboardFire/mkcast 3134
-google/fonts 3122
-mikechau/react-primer-draft 3044
-jhauswald/sirius 3030
-sbstjn/timesheet.js 3005
-github/gitignore 2926
-torvalds/linux 2907
-IonicaBizau/git-stats 2896
-googlesamples/android-UniversalMusicPlayer 2838
-nwjs/nw.js 2829
-primer/primer 2816
-lukehoban/es6features 2810
-FortAwesome/Font-Awesome 2798
-driftyco/ionic 2783
+facebook/react-native 9918
+phanan/htaccess 7954
+alex/what-happens-when 7307
+facebook/react 6696
+moklick/frontend-stuff 6466
+prakhar1989/awesome-courses 5998
+yaronn/blessed-contrib 5779
+arasatasaygin/is.js 5493
+vhf/free-programming-books 5395
+tiimgreen/github-cheat-sheet 5315
+gorhill/uBlock 5299
+Flipboard/react-canvas 5174
+h5bp/Front-end-Developer-Interview-Questions 5134
+sdelements/lets-chat 5039
+iojs/io.js 4729
+bendc/frontend-guidelines 4655
+twbs/bootstrap 4428
+getify/You-Dont-Know-JS 4315
+0xAX/linux-insides 4171
+dotnet/coreclr 4042
+IanLunn/Hover 3983
+daniel-lundin/snabbt.js 3925
+angular/angular.js 3893
+Mango/slideout 3834
+Dogfalo/materialize 3636
+twostairs/paperwork 3465
+USArmyResearchLab/Dshell 3398
+libreboard/libreboard 3388
+Selz/plyr 3381
+LeaVerou/awesomplete 3379
+mbostock/d3 3376
+MengTo/Spring 3270
+muut/riotjs 3203
+wasabeef/awesome-android-ui 3154
+KeyboardFire/mkcast 3133
+google/fonts 3104
+airbnb/javascript 3091
+sophron/wifiphisher 3067
+mikechau/react-primer-draft 3039
+jhauswald/sirius 3010
+sbstjn/timesheet.js 2982
+IonicaBizau/git-stats 2894
+github/gitignore 2869
+torvalds/linux 2856
+googlesamples/android-UniversalMusicPlayer 2819
+primer/primer 2807
+nwjs/nw.js 2796
+lukehoban/es6features 2785
+FortAwesome/Font-Awesome 2758
+wishstudio/flinux 2754
diff --git
a/regression-test/data/variant_p2/sql/howHasTheListOfTopRepositoriesChangedOverTheYears4.out
b/regression-test/data/variant_p2/sql/howHasTheListOfTopRepositoriesChangedOverTheYears4.out
index 496e681f6d6..404522cce02 100644
---
a/regression-test/data/variant_p2/sql/howHasTheListOfTopRepositoriesChangedOverTheYears4.out
+++
b/regression-test/data/variant_p2/sql/howHasTheListOfTopRepositoriesChangedOverTheYears4.out
@@ -1,53 +1,53 @@
-- This file is automatically generated. You should know what you did if you
want to edit this
-- !howHasTheListOfTopRepositoriesChangedOverTheYears4 --
-facebook/react-native 10021
-phanan/htaccess 7964
-alex/what-happens-when 7407
-facebook/react 6762
-moklick/frontend-stuff 6528
-prakhar1989/awesome-courses 6110
-yaronn/blessed-contrib 5880
-arasatasaygin/is.js 5498
-vhf/free-programming-books 5437
-tiimgreen/github-cheat-sheet 5420
-gorhill/uBlock 5415
-Flipboard/react-canvas 5187
-h5bp/Front-end-Developer-Interview-Questions 5177
-sdelements/lets-chat 5045
-iojs/io.js 4866
-bendc/frontend-guidelines 4696
-twbs/bootstrap 4475
-getify/You-Dont-Know-JS 4344
-0xAX/linux-insides 4220
-IanLunn/Hover 4102
-dotnet/coreclr 4049
-daniel-lundin/snabbt.js 3996
-angular/angular.js 3942
-Mango/slideout 3866
-twostairs/paperwork 3684
-Dogfalo/materialize 3664
-libreboard/libreboard 3469
-mbostock/d3 3422
-Selz/plyr 3403
-USArmyResearchLab/Dshell 3401
-LeaVerou/awesomplete 3390
-MengTo/Spring 3276
-muut/riotjs 3244
-wasabeef/awesome-android-ui 3225
-airbnb/javascript 3155
-sophron/wifiphisher 3142
-KeyboardFire/mkcast 3134
-google/fonts 3122
-mikechau/react-primer-draft 3044
-jhauswald/sirius 3030
-sbstjn/timesheet.js 3005
-github/gitignore 2926
-torvalds/linux 2907
-IonicaBizau/git-stats 2896
-googlesamples/android-UniversalMusicPlayer 2838
-nwjs/nw.js 2829
-primer/primer 2816
-lukehoban/es6features 2810
-FortAwesome/Font-Awesome 2798
-driftyco/ionic 2783
+facebook/react-native 9918
+phanan/htaccess 7954
+alex/what-happens-when 7307
+facebook/react 6696
+moklick/frontend-stuff 6466
+prakhar1989/awesome-courses 5998
+yaronn/blessed-contrib 5779
+arasatasaygin/is.js 5493
+vhf/free-programming-books 5395
+tiimgreen/github-cheat-sheet 5315
+gorhill/uBlock 5299
+Flipboard/react-canvas 5174
+h5bp/Front-end-Developer-Interview-Questions 5134
+sdelements/lets-chat 5039
+iojs/io.js 4729
+bendc/frontend-guidelines 4655
+twbs/bootstrap 4428
+getify/You-Dont-Know-JS 4315
+0xAX/linux-insides 4171
+dotnet/coreclr 4042
+IanLunn/Hover 3983
+daniel-lundin/snabbt.js 3925
+angular/angular.js 3893
+Mango/slideout 3834
+Dogfalo/materialize 3636
+twostairs/paperwork 3465
+USArmyResearchLab/Dshell 3398
+libreboard/libreboard 3388
+Selz/plyr 3381
+LeaVerou/awesomplete 3379
+mbostock/d3 3376
+MengTo/Spring 3270
+muut/riotjs 3203
+wasabeef/awesome-android-ui 3154
+KeyboardFire/mkcast 3133
+google/fonts 3104
+airbnb/javascript 3091
+sophron/wifiphisher 3067
+mikechau/react-primer-draft 3039
+jhauswald/sirius 3010
+sbstjn/timesheet.js 2982
+IonicaBizau/git-stats 2894
+github/gitignore 2869
+torvalds/linux 2856
+googlesamples/android-UniversalMusicPlayer 2819
+primer/primer 2807
+nwjs/nw.js 2796
+lukehoban/es6features 2785
+FortAwesome/Font-Awesome 2758
+wishstudio/flinux 2754
diff --git
a/regression-test/data/variant_p2/sql/howHasTheListOfTopRepositoriesChangedOverTheYears5.out
b/regression-test/data/variant_p2/sql/howHasTheListOfTopRepositoriesChangedOverTheYears5.out
index 13116d3cc76..0bee030e8d2 100644
---
a/regression-test/data/variant_p2/sql/howHasTheListOfTopRepositoriesChangedOverTheYears5.out
+++
b/regression-test/data/variant_p2/sql/howHasTheListOfTopRepositoriesChangedOverTheYears5.out
@@ -1,53 +1,53 @@
-- This file is automatically generated. You should know what you did if you
want to edit this
-- !howHasTheListOfTopRepositoriesChangedOverTheYears5 --
-facebook/react-native 10021
-phanan/htaccess 7964
-alex/what-happens-when 7407
-facebook/react 6762
-moklick/frontend-stuff 6528
-prakhar1989/awesome-courses 6110
-yaronn/blessed-contrib 5880
-arasatasaygin/is.js 5498
-vhf/free-programming-books 5437
-tiimgreen/github-cheat-sheet 5420
-gorhill/uBlock 5415
-Flipboard/react-canvas 5187
-h5bp/Front-end-Developer-Interview-Questions 5177
-sdelements/lets-chat 5045
-iojs/io.js 4866
-bendc/frontend-guidelines 4696
-twbs/bootstrap 4475
-getify/You-Dont-Know-JS 4344
-0xAX/linux-insides 4220
-IanLunn/Hover 4102
-dotnet/coreclr 4049
-daniel-lundin/snabbt.js 3996
-angular/angular.js 3942
-Mango/slideout 3866
-twostairs/paperwork 3684
-Dogfalo/materialize 3664
-libreboard/libreboard 3469
-mbostock/d3 3422
-Selz/plyr 3403
-USArmyResearchLab/Dshell 3401
-LeaVerou/awesomplete 3390
-MengTo/Spring 3276
-muut/riotjs 3244
-wasabeef/awesome-android-ui 3225
-airbnb/javascript 3155
-sophron/wifiphisher 3142
-KeyboardFire/mkcast 3134
-google/fonts 3122
-mikechau/react-primer-draft 3044
-jhauswald/sirius 3030
-sbstjn/timesheet.js 3005
-github/gitignore 2926
-torvalds/linux 2907
-IonicaBizau/git-stats 2896
-googlesamples/android-UniversalMusicPlayer 2838
-nwjs/nw.js 2829
-primer/primer 2816
-lukehoban/es6features 2810
-FortAwesome/Font-Awesome 2798
-driftyco/ionic 2783
+facebook/react-native 9918
+phanan/htaccess 7954
+alex/what-happens-when 7307
+facebook/react 6696
+moklick/frontend-stuff 6466
+prakhar1989/awesome-courses 5998
+yaronn/blessed-contrib 5779
+arasatasaygin/is.js 5493
+vhf/free-programming-books 5395
+tiimgreen/github-cheat-sheet 5315
+gorhill/uBlock 5299
+Flipboard/react-canvas 5174
+h5bp/Front-end-Developer-Interview-Questions 5134
+sdelements/lets-chat 5039
+iojs/io.js 4729
+bendc/frontend-guidelines 4655
+twbs/bootstrap 4428
+getify/You-Dont-Know-JS 4315
+0xAX/linux-insides 4171
+dotnet/coreclr 4042
+IanLunn/Hover 3983
+daniel-lundin/snabbt.js 3925
+angular/angular.js 3893
+Mango/slideout 3834
+Dogfalo/materialize 3636
+twostairs/paperwork 3465
+USArmyResearchLab/Dshell 3398
+libreboard/libreboard 3388
+Selz/plyr 3381
+LeaVerou/awesomplete 3379
+mbostock/d3 3376
+MengTo/Spring 3270
+muut/riotjs 3203
+wasabeef/awesome-android-ui 3154
+KeyboardFire/mkcast 3133
+google/fonts 3104
+airbnb/javascript 3091
+sophron/wifiphisher 3067
+mikechau/react-primer-draft 3039
+jhauswald/sirius 3010
+sbstjn/timesheet.js 2982
+IonicaBizau/git-stats 2894
+github/gitignore 2869
+torvalds/linux 2856
+googlesamples/android-UniversalMusicPlayer 2819
+primer/primer 2807
+nwjs/nw.js 2796
+lukehoban/es6features 2785
+FortAwesome/Font-Awesome 2758
+wishstudio/flinux 2754
diff --git
a/regression-test/data/variant_p2/sql/howHasTheListOfTopRepositoriesChangedOverTheYears6.out
b/regression-test/data/variant_p2/sql/howHasTheListOfTopRepositoriesChangedOverTheYears6.out
index 16eb965b642..a6a75ac7a81 100644
---
a/regression-test/data/variant_p2/sql/howHasTheListOfTopRepositoriesChangedOverTheYears6.out
+++
b/regression-test/data/variant_p2/sql/howHasTheListOfTopRepositoriesChangedOverTheYears6.out
@@ -1,53 +1,53 @@
-- This file is automatically generated. You should know what you did if you
want to edit this
-- !howHasTheListOfTopRepositoriesChangedOverTheYears6 --
-facebook/react-native 10021
-phanan/htaccess 7964
-alex/what-happens-when 7407
-facebook/react 6762
-moklick/frontend-stuff 6528
-prakhar1989/awesome-courses 6110
-yaronn/blessed-contrib 5880
-arasatasaygin/is.js 5498
-vhf/free-programming-books 5437
-tiimgreen/github-cheat-sheet 5420
-gorhill/uBlock 5415
-Flipboard/react-canvas 5187
-h5bp/Front-end-Developer-Interview-Questions 5177
-sdelements/lets-chat 5045
-iojs/io.js 4866
-bendc/frontend-guidelines 4696
-twbs/bootstrap 4475
-getify/You-Dont-Know-JS 4344
-0xAX/linux-insides 4220
-IanLunn/Hover 4102
-dotnet/coreclr 4049
-daniel-lundin/snabbt.js 3996
-angular/angular.js 3942
-Mango/slideout 3866
-twostairs/paperwork 3684
-Dogfalo/materialize 3664
-libreboard/libreboard 3469
-mbostock/d3 3422
-Selz/plyr 3403
-USArmyResearchLab/Dshell 3401
-LeaVerou/awesomplete 3390
-MengTo/Spring 3276
-muut/riotjs 3244
-wasabeef/awesome-android-ui 3225
-airbnb/javascript 3155
-sophron/wifiphisher 3142
-KeyboardFire/mkcast 3134
-google/fonts 3122
-mikechau/react-primer-draft 3044
-jhauswald/sirius 3030
-sbstjn/timesheet.js 3005
-github/gitignore 2926
-torvalds/linux 2907
-IonicaBizau/git-stats 2896
-googlesamples/android-UniversalMusicPlayer 2838
-nwjs/nw.js 2829
-primer/primer 2816
-lukehoban/es6features 2810
-FortAwesome/Font-Awesome 2798
-driftyco/ionic 2783
+facebook/react-native 9918
+phanan/htaccess 7954
+alex/what-happens-when 7307
+facebook/react 6696
+moklick/frontend-stuff 6466
+prakhar1989/awesome-courses 5998
+yaronn/blessed-contrib 5779
+arasatasaygin/is.js 5493
+vhf/free-programming-books 5395
+tiimgreen/github-cheat-sheet 5315
+gorhill/uBlock 5299
+Flipboard/react-canvas 5174
+h5bp/Front-end-Developer-Interview-Questions 5134
+sdelements/lets-chat 5039
+iojs/io.js 4729
+bendc/frontend-guidelines 4655
+twbs/bootstrap 4428
+getify/You-Dont-Know-JS 4315
+0xAX/linux-insides 4171
+dotnet/coreclr 4042
+IanLunn/Hover 3983
+daniel-lundin/snabbt.js 3925
+angular/angular.js 3893
+Mango/slideout 3834
+Dogfalo/materialize 3636
+twostairs/paperwork 3465
+USArmyResearchLab/Dshell 3398
+libreboard/libreboard 3388
+Selz/plyr 3381
+LeaVerou/awesomplete 3379
+mbostock/d3 3376
+MengTo/Spring 3270
+muut/riotjs 3203
+wasabeef/awesome-android-ui 3154
+KeyboardFire/mkcast 3133
+google/fonts 3104
+airbnb/javascript 3091
+sophron/wifiphisher 3067
+mikechau/react-primer-draft 3039
+jhauswald/sirius 3010
+sbstjn/timesheet.js 2982
+IonicaBizau/git-stats 2894
+github/gitignore 2869
+torvalds/linux 2856
+googlesamples/android-UniversalMusicPlayer 2819
+primer/primer 2807
+nwjs/nw.js 2796
+lukehoban/es6features 2785
+FortAwesome/Font-Awesome 2758
+wishstudio/flinux 2754
diff --git
a/regression-test/data/variant_p2/sql/howHasTheListOfTopRepositoriesChangedOverTheYears7.out
b/regression-test/data/variant_p2/sql/howHasTheListOfTopRepositoriesChangedOverTheYears7.out
index 998b22fa773..928e8500afc 100644
---
a/regression-test/data/variant_p2/sql/howHasTheListOfTopRepositoriesChangedOverTheYears7.out
+++
b/regression-test/data/variant_p2/sql/howHasTheListOfTopRepositoriesChangedOverTheYears7.out
@@ -1,13 +1,13 @@
-- This file is automatically generated. You should know what you did if you
want to edit this
-- !howHasTheListOfTopRepositoriesChangedOverTheYears7 --
-facebook/react-native 2015 10021
-phanan/htaccess 2015 7964
-alex/what-happens-when 2015 7407
-facebook/react 2015 6762
-moklick/frontend-stuff 2015 6528
-prakhar1989/awesome-courses 2015 6110
-yaronn/blessed-contrib 2015 5880
-arasatasaygin/is.js 2015 5498
-vhf/free-programming-books 2015 5437
-tiimgreen/github-cheat-sheet 2015 5420
+facebook/react-native 2015 9918
+phanan/htaccess 2015 7954
+alex/what-happens-when 2015 7307
+facebook/react 2015 6696
+moklick/frontend-stuff 2015 6466
+prakhar1989/awesome-courses 2015 5998
+yaronn/blessed-contrib 2015 5779
+arasatasaygin/is.js 2015 5493
+vhf/free-programming-books 2015 5395
+tiimgreen/github-cheat-sheet 2015 5315
diff --git
a/regression-test/data/variant_p2/sql/howHasTheTotalNumberOfStarsChangedOverTime.out
b/regression-test/data/variant_p2/sql/howHasTheTotalNumberOfStarsChangedOverTime.out
index e089d1fb789..c15936f42ff 100644
---
a/regression-test/data/variant_p2/sql/howHasTheTotalNumberOfStarsChangedOverTime.out
+++
b/regression-test/data/variant_p2/sql/howHasTheTotalNumberOfStarsChangedOverTime.out
@@ -1,4 +1,4 @@
-- This file is automatically generated. You should know what you did if you
want to edit this
-- !howHasTheTotalNumberOfStarsChangedOverTime --
-2015 3951085
+2015 3901627
diff --git a/regression-test/data/variant_p2/sql/issuesWithTheMostComments1.out
b/regression-test/data/variant_p2/sql/issuesWithTheMostComments1.out
index 65a9891bf19..c39fbabafed 100644
--- a/regression-test/data/variant_p2/sql/issuesWithTheMostComments1.out
+++ b/regression-test/data/variant_p2/sql/issuesWithTheMostComments1.out
@@ -1,4 +1,4 @@
-- This file is automatically generated. You should know what you did if you
want to edit this
-- !issuesWithTheMostComments1 --
-4237859
+4197585
diff --git a/regression-test/data/variant_p2/sql/issuesWithTheMostComments2.out
b/regression-test/data/variant_p2/sql/issuesWithTheMostComments2.out
index fe95c99e167..ecc05fa4161 100644
--- a/regression-test/data/variant_p2/sql/issuesWithTheMostComments2.out
+++ b/regression-test/data/variant_p2/sql/issuesWithTheMostComments2.out
@@ -1,53 +1,53 @@
-- This file is automatically generated. You should know what you did if you
want to edit this
-- !issuesWithTheMostComments2 --
chrsmith/bwapi 28873
-owncloud/core 24124
-apache/spark 21708
+owncloud/core 23962
+apache/spark 21442
chrsmith/google-api-java-client 20317
-rust-lang/rust 19251
-GoogleCloudPlatform/kubernetes 16616
-docker/docker 16562
-cms-sw/cmssw 15740
+rust-lang/rust 19053
+GoogleCloudPlatform/kubernetes 16505
+docker/docker 16444
+cms-sw/cmssw 15594
chrsmith/reaver-wps 14305
-tgstation/-tg-station 13022
+tgstation/-tg-station 12886
chrsmith/html5rocks 10539
chrsmith/open-ig 10130
-iojs/io.js 8927
-JuliaLang/julia 8918
-saltstack/salt 8792
-Homebrew/homebrew 8192
-spyder-ide/spyder 7874
-SiCKRAGETV/sickrage-issues 7635
+iojs/io.js 8833
+JuliaLang/julia 8811
+saltstack/salt 8721
+Homebrew/homebrew 8078
+spyder-ide/spyder 7871
pychess/pychess 7618
-joomla/joomla-cms 7367
-xbmc/xbmc 7320
-openshift/origin 7242
-ManageIQ/manageiq 6862
-mozilla-b2g/gaia 6791
+SiCKRAGETV/sickrage-issues 7516
+joomla/joomla-cms 7261
+xbmc/xbmc 7245
+openshift/origin 7230
+ManageIQ/manageiq 6840
ConEmu/old-issues 6731
-edx/edx-platform 6595
-dotnet/roslyn 6348
+mozilla-b2g/gaia 6717
+edx/edx-platform 6552
+dotnet/roslyn 6322
chrsmith/hedgewars 6134
-rails/rails 5919
-atom/atom 5885
-brianchandotcom/liferay-portal 5851
-NixOS/nixpkgs 5475
-yiisoft/yii2 5173
-FortAwesome/Font-Awesome 4863
-neovim/neovim 4770
-scikit-learn/scikit-learn 4542
-angular/angular.js 4524
-CleverRaven/Cataclysm-DDA 4372
-symfony/symfony 4354
-CartoDB/cartodb 4352
-ember-cli/ember-cli 4299
-ceph/ceph 4263
-npm/npm 4252
+rails/rails 5879
+atom/atom 5816
+brianchandotcom/liferay-portal 5810
+NixOS/nixpkgs 5399
+yiisoft/yii2 5129
+FortAwesome/Font-Awesome 4818
+neovim/neovim 4715
+scikit-learn/scikit-learn 4515
+angular/angular.js 4456
+CleverRaven/Cataclysm-DDA 4323
+CartoDB/cartodb 4320
+ember-cli/ember-cli 4262
+symfony/symfony 4254
+npm/npm 4226
+ceph/ceph 4225
sphinx-doc/testing2 4220
-laravel/framework 4217
-RIOT-OS/RIOT 4091
-gorhill/uBlock 4088
-rust-lang/rfcs 4051
-OpenRA/OpenRA 3993
-Microsoft/TypeScript 3963
+laravel/framework 4184
+gorhill/uBlock 4065
+RIOT-OS/RIOT 4052
+rust-lang/rfcs 4018
+OpenRA/OpenRA 3951
+Microsoft/TypeScript 3927
diff --git a/regression-test/data/variant_p2/sql/issuesWithTheMostComments3.out
b/regression-test/data/variant_p2/sql/issuesWithTheMostComments3.out
index a9b5b17ca0f..04bc174d9df 100644
--- a/regression-test/data/variant_p2/sql/issuesWithTheMostComments3.out
+++ b/regression-test/data/variant_p2/sql/issuesWithTheMostComments3.out
@@ -1,53 +1,53 @@
-- This file is automatically generated. You should know what you did if you
want to edit this
-- !issuesWithTheMostComments3 --
chrsmith/bwapi 28873 499 58
-owncloud/core 24124 3172 8
-apache/spark 21708 1693 13
+owncloud/core 23962 3167 8
+apache/spark 21442 1692 13
chrsmith/google-api-java-client 20317 782 26
-rust-lang/rust 19251 4525 4
-GoogleCloudPlatform/kubernetes 16616 3057 5
-docker/docker 16562 2933 6
-cms-sw/cmssw 15740 1678 9
+rust-lang/rust 19053 4496 4
+GoogleCloudPlatform/kubernetes 16505 3049 5
+docker/docker 16444 2928 6
+cms-sw/cmssw 15594 1676 9
chrsmith/reaver-wps 14305 544 26
-tgstation/-tg-station 13022 1786 7
+tgstation/-tg-station 12886 1785 7
chrsmith/html5rocks 10539 884 12
chrsmith/open-ig 10130 898 11
-iojs/io.js 8927 1124 8
-JuliaLang/julia 8918 1383 6
-saltstack/salt 8792 2386 4
-Homebrew/homebrew 8192 2315 4
-spyder-ide/spyder 7874 1813 4
-SiCKRAGETV/sickrage-issues 7635 766 10
+iojs/io.js 8833 1119 8
+JuliaLang/julia 8811 1378 6
+saltstack/salt 8721 2381 4
+Homebrew/homebrew 8078 2297 4
+spyder-ide/spyder 7871 1813 4
pychess/pychess 7618 930 8
-joomla/joomla-cms 7367 1276 6
-xbmc/xbmc 7320 836 9
-openshift/origin 7242 908 8
-ManageIQ/manageiq 6862 1180 6
-mozilla-b2g/gaia 6791 2118 3
+SiCKRAGETV/sickrage-issues 7516 757 10
+joomla/joomla-cms 7261 1274 6
+xbmc/xbmc 7245 831 9
+openshift/origin 7230 908 8
+ManageIQ/manageiq 6840 1179 6
ConEmu/old-issues 6731 1120 6
-edx/edx-platform 6595 1086 6
-dotnet/roslyn 6348 1304 5
+mozilla-b2g/gaia 6717 2103 3
+edx/edx-platform 6552 1081 6
+dotnet/roslyn 6322 1302 5
chrsmith/hedgewars 6134 862 7
-rails/rails 5919 1580 4
-atom/atom 5885 1469 4
-brianchandotcom/liferay-portal 5851 2221 3
-NixOS/nixpkgs 5475 1335 4
-yiisoft/yii2 5173 1302 4
-FortAwesome/Font-Awesome 4863 1457 3
-neovim/neovim 4770 628 8
-scikit-learn/scikit-learn 4542 636 7
-angular/angular.js 4524 1223 4
-CleverRaven/Cataclysm-DDA 4372 865 5
-symfony/symfony 4354 1188 4
-CartoDB/cartodb 4352 1026 4
-ember-cli/ember-cli 4299 877 5
-ceph/ceph 4263 978 4
-npm/npm 4252 1320 3
+rails/rails 5879 1575 4
+atom/atom 5816 1462 4
+brianchandotcom/liferay-portal 5810 2217 3
+NixOS/nixpkgs 5399 1319 4
+yiisoft/yii2 5129 1292 4
+FortAwesome/Font-Awesome 4818 1454 3
+neovim/neovim 4715 627 8
+scikit-learn/scikit-learn 4515 636 7
+angular/angular.js 4456 1216 4
+CleverRaven/Cataclysm-DDA 4323 865 5
+CartoDB/cartodb 4320 1020 4
+ember-cli/ember-cli 4262 875 5
+symfony/symfony 4254 1181 4
+npm/npm 4226 1320 3
+ceph/ceph 4225 975 4
sphinx-doc/testing2 4220 1416 3
-laravel/framework 4217 1138 4
-RIOT-OS/RIOT 4091 631 6
-gorhill/uBlock 4088 671 6
-rust-lang/rfcs 4051 384 11
-OpenRA/OpenRA 3993 691 6
-Microsoft/TypeScript 3963 974 4
+laravel/framework 4184 1134 4
+gorhill/uBlock 4065 670 6
+RIOT-OS/RIOT 4052 629 6
+rust-lang/rfcs 4018 383 10
+OpenRA/OpenRA 3951 691 6
+Microsoft/TypeScript 3927 969 4
diff --git a/regression-test/data/variant_p2/sql/issuesWithTheMostComments4.out
b/regression-test/data/variant_p2/sql/issuesWithTheMostComments4.out
index c4406b23099..83fa3ec22dd 100644
--- a/regression-test/data/variant_p2/sql/issuesWithTheMostComments4.out
+++ b/regression-test/data/variant_p2/sql/issuesWithTheMostComments4.out
@@ -1,28 +1,28 @@
-- This file is automatically generated. You should know what you did if you
want to edit this
-- !issuesWithTheMostComments4 --
tphongio/elasticbox-plugin 1 3216
-TTMTT/iCL0udin 1 1844
+TTMTT/iCL0udin 1 1782
iiordanov/remote-desktop-clients 39 1473
chrsmith/bwapi 134 1200
-codecov/ci-repo 1 771
+codecov/ci-repo 1 761
chrsmith/bwapi 145 528
xbmc/xbmc 6227 515
chrsmith/bwapi 322 480
TrigonaMinima/TrigonaMinima.github.io 3 450
chrsmith/bwapi 190 432
-Wouter1/EMU-driver 40 385
+Wouter1/EMU-driver 40 383
chrsmith/reaver-wps 195 368
mtambara/liferay-portal 22 367
chrsmith/bwapi 104 352
chrsmith/google-api-java-client 18 351
-Flyer53/jsPanel 23 338
+Flyer53/jsPanel 23 337
chrsmith/bwapi 93 336
chrsmith/bwapi 113 336
-synergy/synergy 4349 322
+synergy/synergy 4349 321
chrsmith/bwapi 142 320
chrsmith/reaver-wps 16 316
chrsmith/reaver-wps 158 316
-neovim/neovim 1820 316
+neovim/neovim 1820 313
openmicroscopy/snoopys-sandbox 14 310
owncloud/core 14472 295
mtambara/liferay-portal 21 286
@@ -30,24 +30,24 @@ chrsmith/reaver-wps 6 284
mtambara/liferay-portal 25 282
chrsmith/reaver-wps 129 280
Tribler/tribler 1210 277
-OpenELEC/OpenELEC.tv 3726 275
chrsmith/google-api-java-client 2 273
+OpenELEC/OpenELEC.tv 3726 263
chrsmith/reaver-wps 203 260
letsgetrandy/DICSS 16 259
-neovim/neovim 2076 257
chrsmith/bwapi 96 256
chrsmith/bwapi 198 256
-doraTeX/TeX2img 14 255
chrsmith/bwapi 19 255
-iojs/website 125 254
tgstation/-tg-station 7420 254
+doraTeX/TeX2img 14 253
chrsmith/bwapi 232 252
+neovim/neovim 2076 252
chrsmith/bwapi 281 247
+iojs/website 125 244
chrsmith/bwapi 120 240
chrsmith/bwapi 169 240
chrsmith/bwapi 373 240
chrsmith/reaver-wps 90 232
-luc-github/Repetier-Firmware-0.92 10 227
-aosp-exchange-group/about 1 226
chrsmith/bwapi 153 224
+lhorie/mithril.js 413 223
+luc-github/Repetier-Firmware-0.92 10 220
diff --git a/regression-test/data/variant_p2/sql/issuesWithTheMostComments5.out
b/regression-test/data/variant_p2/sql/issuesWithTheMostComments5.out
index 9b00c81679c..072559a6739 100644
--- a/regression-test/data/variant_p2/sql/issuesWithTheMostComments5.out
+++ b/regression-test/data/variant_p2/sql/issuesWithTheMostComments5.out
@@ -6,48 +6,48 @@ chrsmith/bwapi 145 528
xbmc/xbmc 6227 515
chrsmith/bwapi 322 480
chrsmith/bwapi 190 432
-Wouter1/EMU-driver 40 385
+Wouter1/EMU-driver 40 383
chrsmith/reaver-wps 195 368
mtambara/liferay-portal 22 367
chrsmith/bwapi 104 352
chrsmith/google-api-java-client 18 351
-Flyer53/jsPanel 23 338
+Flyer53/jsPanel 23 337
chrsmith/bwapi 93 336
chrsmith/bwapi 113 336
-synergy/synergy 4349 322
+synergy/synergy 4349 321
chrsmith/bwapi 142 320
chrsmith/reaver-wps 16 316
chrsmith/reaver-wps 158 316
-neovim/neovim 1820 316
+neovim/neovim 1820 313
openmicroscopy/snoopys-sandbox 14 310
owncloud/core 14472 295
mtambara/liferay-portal 21 286
mtambara/liferay-portal 25 282
chrsmith/reaver-wps 129 280
Tribler/tribler 1210 277
-OpenELEC/OpenELEC.tv 3726 275
+OpenELEC/OpenELEC.tv 3726 263
chrsmith/reaver-wps 203 260
letsgetrandy/DICSS 16 259
-neovim/neovim 2076 257
chrsmith/bwapi 96 256
chrsmith/bwapi 198 256
chrsmith/bwapi 19 255
-doraTeX/TeX2img 14 255
-iojs/website 125 254
tgstation/-tg-station 7420 254
+doraTeX/TeX2img 14 253
chrsmith/bwapi 232 252
+neovim/neovim 2076 252
chrsmith/bwapi 281 247
+iojs/website 125 244
chrsmith/bwapi 120 240
chrsmith/bwapi 169 240
chrsmith/bwapi 373 240
chrsmith/reaver-wps 90 232
chrsmith/bwapi 153 224
lhorie/mithril.js 413 223
-ValveSoftware/steam-for-linux 3671 222
-iojs/io.js 978 221
-xbmc/xbmc 5329 221
+iojs/io.js 978 220
+xbmc/xbmc 5329 220
chrsmith/google-api-java-client 361 216
dotnet/roslyn 98 215
+ValveSoftware/steam-for-linux 3671 214
chrsmith/bwapi 135 208
-limelight-stream/limelight-ios 20 207
+limelight-stream/limelight-ios 20 206
diff --git a/regression-test/data/variant_p2/sql/issuesWithTheMostComments6.out
b/regression-test/data/variant_p2/sql/issuesWithTheMostComments6.out
index c354bb906d5..529c7958e83 100644
--- a/regression-test/data/variant_p2/sql/issuesWithTheMostComments6.out
+++ b/regression-test/data/variant_p2/sql/issuesWithTheMostComments6.out
@@ -2,52 +2,52 @@
-- !issuesWithTheMostComments6 --
iiordanov/remote-desktop-clients 39 1473 1023
xbmc/xbmc 6227 515 17
-Flyer53/jsPanel 23 338 5
-synergy/synergy 4349 322 108
-neovim/neovim 1820 316 21
+Flyer53/jsPanel 23 337 5
+synergy/synergy 4349 321 108
+neovim/neovim 1820 313 21
owncloud/core 14472 295 8
-OpenELEC/OpenELEC.tv 3726 275 18
+OpenELEC/OpenELEC.tv 3726 263 18
letsgetrandy/DICSS 16 259 138
-neovim/neovim 2076 257 30
-iojs/website 125 254 160
tgstation/-tg-station 7420 254 18
+neovim/neovim 2076 252 30
+iojs/website 125 244 155
lhorie/mithril.js 413 223 30
-ValveSoftware/steam-for-linux 3671 222 119
-iojs/io.js 978 221 76
-xbmc/xbmc 5329 221 6
+iojs/io.js 978 220 76
+xbmc/xbmc 5329 220 6
dotnet/roslyn 98 215 99
-limelight-stream/limelight-ios 20 207 154
+ValveSoftware/steam-for-linux 3671 214 115
+limelight-stream/limelight-ios 20 206 154
6to5/6to5 596 204 51
-raspberrypi/firmware 377 193 5
+raspberrypi/firmware 377 192 5
isaacs/github 18 183 179
-SiCKRAGETV/sickrage-issues 589 180 5
SiCKRAGETV/sickrage-issues 1023 179 4
-MarlinFirmware/Marlin 1209 179 25
+SiCKRAGETV/sickrage-issues 589 178 5
owncloud/core 14151 173 8
rust-lang/rfcs 803 170 37
-rackerlabs/repose 1149 170 4
+MarlinFirmware/Marlin 1209 170 25
Shani-08/ShaniXBMCWork 74 167 15
easydigitaldownloads/Easy-Digital-Downloads 2548 164 9
+rackerlabs/repose 1149 163 4
JorgenPhi/php-snapchat 89 158 19
wf9a5m75/phonegap-googlemaps-plugin 408 157 5
wrye-bash/wrye-bash 187 155 6
-catalinii/minisatip 21 148 5
+catalinii/minisatip 21 146 5
whatwg/fetch 27 146 15
-docker/docker 4036 145 46
angular/angular.dart 1650 144 6
-rust-lang/rfcs 560 142 28
+docker/docker 4036 142 46
SynoCommunity/spksrc 1478 140 24
angular/angular.dart 1647 140 6
-ajaxorg/cloud9 3200 140 41
-docker/docker 9882 139 26
+rust-lang/rfcs 560 139 28
+ajaxorg/cloud9 3200 139 40
+docker/docker 9882 138 26
iojs/io.js 758 136 10
-joomla/joomla-cms 5140 135 12
aerogear/aerogear-unifiedpush-server 502 134 6
UV-CDAT/uvcdat 1113 134 5
apache/spark 3916 134 8
+joomla/joomla-cms 5140 134 12
LaurentGomila/SFML 757 132 8
xbmc/xbmc 5561 132 11
-trakt/script.trakt 190 130 28
owncloud/core 11884 129 8
owncloud/core 12801 129 12
+docker/docker 9176 128 29
diff --git a/regression-test/data/variant_p2/sql/issuesWithTheMostComments7.out
b/regression-test/data/variant_p2/sql/issuesWithTheMostComments7.out
index 747ff0ff0f5..e5ab2c8e53f 100644
--- a/regression-test/data/variant_p2/sql/issuesWithTheMostComments7.out
+++ b/regression-test/data/variant_p2/sql/issuesWithTheMostComments7.out
@@ -1,48 +1,47 @@
-- This file is automatically generated. You should know what you did if you
want to edit this
-- !issuesWithTheMostComments7 --
miabot/galleries.csv 21872 1
-NREL/EnergyPlus 3874 14
-servo/servo 3649 14
-jirikuncar/invenio 3292 3
-rust-lang/rust 1513 34
+NREL/EnergyPlus 3843 14
+servo/servo 3635 14
+jirikuncar/invenio 3218 3
+rust-lang/rust 1484 34
coala-analyzer/coala 1445 7
-NREL/OpenStudio 1327 11
-mono/MonoGame 1224 14
-Wikia/app 852 24
+NREL/OpenStudio 1316 11
+mono/MonoGame 1208 14
+Wikia/app 850 24
Microsoft/TypeScript 760 23
-JuliaLang/julia 732 46
-netguru/people 732 28
-TrinityCore/TrinityCore 630 126
-NixOS/nixpkgs 524 78
-FreeBSDFoundation/freebsd 516 6
-magnumripper/JohnTheRipper 501 8
-netguru-training/foodempire 474 1
-jruby/jruby 429 18
+netguru/people 731 28
+JuliaLang/julia 726 45
+TrinityCore/TrinityCore 624 125
+NixOS/nixpkgs 517 77
+FreeBSDFoundation/freebsd 511 6
+magnumripper/JohnTheRipper 495 8
+netguru-training/foodempire 459 1
+jruby/jruby 428 18
junmin-zhu/blink-crosswalk 411 3
-AnnaPonomareva/ybackend 381 3
-OsmSharp/OsmSharp 354 2
-kasper93/mpc-hc 336 5
-ChaiScript/ChaiScript 332 1
-odoo/odoo 329 59
+AnnaPonomareva/ybackend 375 3
+OsmSharp/OsmSharp 352 2
pocket-playlab/optimus-prime 328 2
-OpenSprites/OpenSprites 325 14
-laravel/framework 325 136
-akkadotnet/akka.net 305 6
-edx/edx-platform 304 40
+ChaiScript/ChaiScript 327 1
+odoo/odoo 327 58
+OpenSprites/OpenSprites 324 14
+kasper93/mpc-hc 324 5
+laravel/framework 322 136
+akkadotnet/akka.net 303 6
netguru/carrierwave-ios 303 7
+edx/edx-platform 301 40
nick-levelup/home 294 4
cbitstech/think_feel_do_engine 292 7
online-labs/kernel-config 292 3
-rails/rails 292 104
-Warsow/qfusion 284 5
-kenji0919/pirodx_manager 283 2
-php/php-src 282 44
+rails/rails 291 104
+kenji0919/pirodx_manager 280 2
gbitten/preempt_rt 278 1
-HaxeFoundation/haxe 255 19
-basho/riak_cs 255 6
-PrestaShop/PrestaShop 250 60
+Warsow/qfusion 275 5
+php/php-src 270 44
+HaxeFoundation/haxe 252 19
hwoarangmy/OpenDungeons 249 5
-nl5887/github-webhook-test 240 2
+PrestaShop/PrestaShop 248 60
+basho/riak_cs 243 6
nl5887/linthub-demo 237 1
L2J/L2J_Server 234 17
netguru/devise-ios 231 7
@@ -50,4 +49,5 @@ lmccallum/GeoCanViz 229 2
mtk09422/chromiumos-third_party-coreboot 228 2
cachethq/Cachet 222 9
gorhill/uBlock 218 20
+xBimTeam/XbimExchange 218 1
diff --git a/regression-test/data/variant_p2/sql/mostForkedRepositories.out
b/regression-test/data/variant_p2/sql/mostForkedRepositories.out
index be96dadb402..c9189f8c067 100644
--- a/regression-test/data/variant_p2/sql/mostForkedRepositories.out
+++ b/regression-test/data/variant_p2/sql/mostForkedRepositories.out
@@ -1,53 +1,53 @@
-- This file is automatically generated. You should know what you did if you
want to edit this
-- !mostForkedRepositories --
-jtleek/datasharing 25220
-rdpeng/ProgrammingAssignment2 14984
-octocat/Spoon-Knife 12375
+jtleek/datasharing 24456
+rdpeng/ProgrammingAssignment2 14534
+octocat/Spoon-Knife 12203
MyCoolTest/a-terrible-project 9266
-rdpeng/ExData_Plotting1 6362
+rdpeng/ExData_Plotting1 6225
TridentSDK/Trident 5571
-rdpeng/RepData_PeerAssessment1 3557
-udacity/frontend-nanodegree-resume 3256
-twbs/bootstrap 3104
-barryclark/jekyll-now 2792
-angular/angular.js 2630
-LarryMad/recipes 2072
-HubPress/hubpress.io 1801
-rdpeng/courses 1723
-vhf/free-programming-books 1543
-jlord/patchwork 1467
-github/gitignore 1330
-mbostock/d3 1299
-bcaffo/courses 1252
-deadlyvipers/dojo_rules 1222
-torvalds/linux 1221
-Homebrew/homebrew 1207
-aporter/coursera-android 1089
-docker/docker 1064
-goagent/goagent 1032
-Trinea/android-open-project 1007
-rails/rails 960
-laravel/laravel 954
-facebook/react 949
-tastejs/todomvc 909
-nightscout/cgm-remote-monitor 907
-udacity/create-your-own-adventure 894
-apache/spark 889
-gabrielecirulli/2048 844
-yiisoft/yii2 838
-facebook/react-native 822
-Itseez/opencv 813
-prakhar1989/awesome-courses 813
-FortAwesome/Font-Awesome 774
-dotnet/coreclr 760
+rdpeng/RepData_PeerAssessment1 3509
+udacity/frontend-nanodegree-resume 3218
+twbs/bootstrap 3072
+barryclark/jekyll-now 2748
+angular/angular.js 2589
+LarryMad/recipes 2044
+HubPress/hubpress.io 1798
+rdpeng/courses 1692
+vhf/free-programming-books 1527
+jlord/patchwork 1452
+github/gitignore 1304
+mbostock/d3 1281
+bcaffo/courses 1239
+deadlyvipers/dojo_rules 1214
+torvalds/linux 1202
+Homebrew/homebrew 1189
+aporter/coursera-android 1069
+docker/docker 1048
+goagent/goagent 1013
+Trinea/android-open-project 986
+rails/rails 954
+laravel/laravel 945
+facebook/react 939
+nightscout/cgm-remote-monitor 897
+tastejs/todomvc 888
+apache/spark 882
+udacity/create-your-own-adventure 873
+gabrielecirulli/2048 836
+yiisoft/yii2 832
+facebook/react-native 814
+Itseez/opencv 802
+prakhar1989/awesome-courses 794
+FortAwesome/Font-Awesome 764
+dotnet/coreclr 759
ColonyTestOrganisation/repoName 753
-swirldev/swirl_courses 750
-DataScienceSpecialization/courses 746
+swirldev/swirl_courses 742
USArmyResearchLab/Dshell 736
-django/django 714
-h5bp/Front-end-Developer-Interview-Questions 714
-iluwatar/java-design-patterns 714
-jquery/jquery 712
-daneden/animate.css 707
-atom/atom 705
+DataScienceSpecialization/courses 735
+django/django 707
+iluwatar/java-design-patterns 706
+h5bp/Front-end-Developer-Interview-Questions 704
+jquery/jquery 704
+daneden/animate.css 697
+hakimel/reveal.js 692
diff --git
a/regression-test/data/variant_p2/sql/mostPopularCommentsOnGithub.out
b/regression-test/data/variant_p2/sql/mostPopularCommentsOnGithub.out
index 78eb92582c0..754bb7086b7 100644
--- a/regression-test/data/variant_p2/sql/mostPopularCommentsOnGithub.out
+++ b/regression-test/data/variant_p2/sql/mostPopularCommentsOnGithub.out
@@ -1,4 +1,4 @@
-- This file is automatically generated. You should know what you did if you
want to edit this
-- !mostPopularCommentsOnGithub --
-:+1: 38565
+:+1: 38258
diff --git
a/regression-test/data/variant_p2/sql/organizationsByTheNumberOfRepositories.out
b/regression-test/data/variant_p2/sql/organizationsByTheNumberOfRepositories.out
index 41e4d206ec9..dc65be783d9 100644
---
a/regression-test/data/variant_p2/sql/organizationsByTheNumberOfRepositories.out
+++
b/regression-test/data/variant_p2/sql/organizationsByTheNumberOfRepositories.out
@@ -1,9 +1,9 @@
-- This file is automatically generated. You should know what you did if you
want to edit this
-- !organizationsByTheNumberOfRepositories --
-google 168
-apache 116
+google 166
+apache 115
facebook 100
-sindresorhus 94
+sindresorhus 93
substack 89
codrops 66
twitter 59
@@ -13,37 +13,37 @@ stackforge 54
netflix 50
openstack 48
tj 47
-yahoo 47
square 46
+yahoo 46
thoughtbot 44
mapbox 43
googlesamples 41
angular 36
-github 36
+github 35
maxogden 35
microsoft 34
-tpope 34
googlecloudplatform 33
-mafintosh 33
nicklockwood 33
+tpope 33
+mafintosh 32
alibaba 31
heroku 30
aspnet 29
-adafruit 28
automattic 28
-elasticsearch 28
-firebase 28
thephpleague 28
+adafruit 27
+elasticsearch 27
+firebase 27
hadley 27
spotify 27
addyosmani 26
-atom 26
driftyco 26
mattn 26
esri 25
gruntjs 25
iojs 25
shopify 25
+atom 24
filamentgroup 24
golang 24
rails 24
diff --git
a/regression-test/data/variant_p2/sql/organizationsByTheNumberOfStars.out
b/regression-test/data/variant_p2/sql/organizationsByTheNumberOfStars.out
index cf8094bb77c..1db47c36e72 100644
--- a/regression-test/data/variant_p2/sql/organizationsByTheNumberOfStars.out
+++ b/regression-test/data/variant_p2/sql/organizationsByTheNumberOfStars.out
@@ -1,53 +1,53 @@
-- This file is automatically generated. You should know what you did if you
want to edit this
-- !organizationsByTheNumberOfStars --
-facebook 46498
-google 33024
-angular 10705
-github 9153
-square 8896
-dotnet 8735
-thoughtbot 8290
-h5bp 8175
-yalantis 8129
-phanan 7996
-sindresorhus 7660
-alex 7615
-microsoft 7376
-mozilla 7136
-moklick 6935
-prakhar1989 6772
-apache 6762
-docker 6498
-yaronn 6467
-flipboard 6457
-twbs 6024
-iojs 5924
-yahoo 5793
-gorhill 5791
-twitter 5740
-vhf 5526
-arasatasaygin 5498
-substack 5464
-tiimgreen 5425
-airbnb 5182
-atom 5169
-mengto 5150
-sdelements 5096
-bendc 5082
-jakewharton 5020
-driftyco 5005
-wasabeef 4750
-0xax 4661
-getify 4554
-googlesamples 4504
-ianlunn 4348
-grpc 4339
-angular-ui 4188
-shadowsocks 4177
-daniel-lundin 4001
-leaverou 3999
-etsy 3968
-ecomfe 3911
-mango 3888
-mbostock 3839
+facebook 45972
+google 32678
+angular 10577
+github 9021
+square 8767
+dotnet 8675
+thoughtbot 8146
+h5bp 8105
+yalantis 7996
+phanan 7986
+sindresorhus 7526
+alex 7509
+microsoft 7292
+mozilla 7067
+moklick 6867
+apache 6682
+prakhar1989 6640
+flipboard 6432
+docker 6428
+yaronn 6353
+twbs 5964
+iojs 5773
+yahoo 5757
+gorhill 5668
+twitter 5654
+arasatasaygin 5493
+vhf 5483
+substack 5398
+tiimgreen 5320
+mengto 5137
+atom 5092
+sdelements 5090
+airbnb 5081
+bendc 5041
+driftyco 4945
+jakewharton 4934
+wasabeef 4648
+0xax 4609
+getify 4521
+googlesamples 4464
+grpc 4314
+ianlunn 4226
+angular-ui 4137
+shadowsocks 4090
+leaverou 3984
+etsy 3941
+daniel-lundin 3930
+mango 3856
+ecomfe 3826
+mbostock 3788
diff --git
a/regression-test/data/variant_p2/sql/organizationsByTheSizeOfCommunity.out
b/regression-test/data/variant_p2/sql/organizationsByTheSizeOfCommunity.out
index 667b28838bc..a364ae96e76 100644
--- a/regression-test/data/variant_p2/sql/organizationsByTheSizeOfCommunity.out
+++ b/regression-test/data/variant_p2/sql/organizationsByTheSizeOfCommunity.out
@@ -1,8 +1,8 @@
-- This file is automatically generated. You should know what you did if you
want to edit this
-- !organizationsByTheSizeOfCommunity --
-facebook 3225 797 1516 2522 195 172
-fortawesome 2994 42 624 2645 3 3
-angular 2831 463 1229 2262 109 44
-docker 2697 504 948 2419 210 34
-atom 2620 276 1368 2024 65 20
+facebook 3214 791 1505 2512 195 172
+fortawesome 2969 42 619 2620 3 3
+angular 2811 459 1220 2250 107 43
+docker 2692 501 942 2414 208 34
+atom 2595 273 1349 2009 65 20
diff --git
a/regression-test/data/variant_p2/sql/proportionsBetweenStarsAndForks1.out
b/regression-test/data/variant_p2/sql/proportionsBetweenStarsAndForks1.out
index 026d4c8e797..e30b60ddb63 100644
--- a/regression-test/data/variant_p2/sql/proportionsBetweenStarsAndForks1.out
+++ b/regression-test/data/variant_p2/sql/proportionsBetweenStarsAndForks1.out
@@ -1,53 +1,53 @@
-- This file is automatically generated. You should know what you did if you
want to edit this
-- !proportionsBetweenStarsAndForks1 --
-jtleek/datasharing 25220 555 0
-rdpeng/ProgrammingAssignment2 14984 91 0
-octocat/Spoon-Knife 12375 165 0
+jtleek/datasharing 24456 551 0
+rdpeng/ProgrammingAssignment2 14534 90 0
+octocat/Spoon-Knife 12203 165 0
MyCoolTest/a-terrible-project 9266 0 0
-rdpeng/ExData_Plotting1 6362 12 0
+rdpeng/ExData_Plotting1 6225 12 0
TridentSDK/Trident 5571 19 0
-rdpeng/RepData_PeerAssessment1 3557 6 0
-udacity/frontend-nanodegree-resume 3256 49 0
-twbs/bootstrap 3104 4475 1
-barryclark/jekyll-now 2792 471 0
-angular/angular.js 2630 3942 1
-LarryMad/recipes 2072 13 0
-HubPress/hubpress.io 1801 1843 1
-rdpeng/courses 1723 281 0
-vhf/free-programming-books 1543 5437 4
-jlord/patchwork 1467 36 0
-github/gitignore 1330 2926 2
-mbostock/d3 1299 3422 3
-bcaffo/courses 1252 167 0
-deadlyvipers/dojo_rules 1222 14 0
-torvalds/linux 1221 2907 2
-Homebrew/homebrew 1207 1583 1
-aporter/coursera-android 1089 602 1
-docker/docker 1064 2655 2
-goagent/goagent 1032 1912 2
-Trinea/android-open-project 1007 1901 2
-rails/rails 960 1363 1
-laravel/laravel 954 2056 2
-facebook/react 949 6762 7
-tastejs/todomvc 909 1035 1
-nightscout/cgm-remote-monitor 907 25 0
-udacity/create-your-own-adventure 894 18 0
-apache/spark 889 1028 1
-gabrielecirulli/2048 844 485 1
-yiisoft/yii2 838 1034 1
-facebook/react-native 822 10021 12
-Itseez/opencv 813 847 1
-prakhar1989/awesome-courses 813 6110 8
-FortAwesome/Font-Awesome 774 2798 4
-dotnet/coreclr 760 4049 5
+rdpeng/RepData_PeerAssessment1 3509 6 0
+udacity/frontend-nanodegree-resume 3218 49 0
+twbs/bootstrap 3072 4428 1
+barryclark/jekyll-now 2748 459 0
+angular/angular.js 2589 3893 2
+LarryMad/recipes 2044 13 0
+HubPress/hubpress.io 1798 1841 1
+rdpeng/courses 1692 276 0
+vhf/free-programming-books 1527 5395 4
+jlord/patchwork 1452 36 0
+github/gitignore 1304 2869 2
+mbostock/d3 1281 3376 3
+bcaffo/courses 1239 163 0
+deadlyvipers/dojo_rules 1214 13 0
+torvalds/linux 1202 2856 2
+Homebrew/homebrew 1189 1561 1
+aporter/coursera-android 1069 592 1
+docker/docker 1048 2626 3
+goagent/goagent 1013 1870 2
+Trinea/android-open-project 986 1869 2
+rails/rails 954 1341 1
+laravel/laravel 945 2036 2
+facebook/react 939 6696 7
+nightscout/cgm-remote-monitor 897 25 0
+tastejs/todomvc 888 1022 1
+apache/spark 882 1014 1
+udacity/create-your-own-adventure 873 18 0
+gabrielecirulli/2048 836 476 1
+yiisoft/yii2 832 1027 1
+facebook/react-native 814 9918 12
+Itseez/opencv 802 844 1
+prakhar1989/awesome-courses 794 5998 8
+FortAwesome/Font-Awesome 764 2758 4
+dotnet/coreclr 759 4042 5
ColonyTestOrganisation/repoName 753 0 0
-swirldev/swirl_courses 750 252 0
-DataScienceSpecialization/courses 746 296 0
-USArmyResearchLab/Dshell 736 3401 5
-django/django 714 1369 2
-h5bp/Front-end-Developer-Interview-Questions 714 5177 7
-iluwatar/java-design-patterns 714 2771 4
-jquery/jquery 712 1368 2
-daneden/animate.css 707 2687 4
-atom/atom 705 2745 4
+swirldev/swirl_courses 742 249 0
+USArmyResearchLab/Dshell 736 3398 5
+DataScienceSpecialization/courses 735 285 0
+django/django 707 1353 2
+iluwatar/java-design-patterns 706 2734 4
+h5bp/Front-end-Developer-Interview-Questions 704 5134 7
+jquery/jquery 704 1342 2
+daneden/animate.css 697 2654 4
+hakimel/reveal.js 692 1873 3
diff --git
a/regression-test/data/variant_p2/sql/proportionsBetweenStarsAndForks2.out
b/regression-test/data/variant_p2/sql/proportionsBetweenStarsAndForks2.out
index 8997ec079fe..7803bd83cd2 100644
--- a/regression-test/data/variant_p2/sql/proportionsBetweenStarsAndForks2.out
+++ b/regression-test/data/variant_p2/sql/proportionsBetweenStarsAndForks2.out
@@ -1,53 +1,53 @@
-- This file is automatically generated. You should know what you did if you
want to edit this
-- !proportionsBetweenStarsAndForks2 --
-motemen/gore 11 894 81
-nathanpeck/clui 10 669 66
-venantius/ultra 10 597 59
-IonicaBizau/git-stats 56 2896 51
+motemen/gore 11 893 81
+nathanpeck/clui 10 666 66
+venantius/ultra 10 596 59
+IonicaBizau/git-stats 55 2894 52
skywinder/github-changelog-generator 19 958 50
-FormidableLabs/radium 16 788 49
-amscanne/huptime 10 493 49
+FormidableLabs/radium 16 784 49
anacrolix/torrent 16 782 48
-vektra/templar 14 661 47
-philipwalton/flexbugs 29 1331 45
-KeyboardFire/mkcast 70 3134 44
-labstack/echo 13 572 44
-mentum/lambdaws 22 953 43
-begriffs/postgrest 55 2312 42
-jaicab/localFont 13 557 42
-mikechau/react-primer-draft 71 3044 42
-seppo0010/rlite 16 676 42
-shipitjs/shipit 47 1976 42
-yaronn/GifW00t 13 557 42
-bevacqua/fuzzysearch 15 622 41
-jgrahamc/httpdiff 34 1399 41
-sindresorhus/chalk 16 666 41
-Yomguithereal/baobab 20 782 39
-pdcgomes/XCActionBar 25 965 38
+amscanne/huptime 10 471 47
+philipwalton/flexbugs 28 1305 46
+vektra/templar 14 645 46
+jaicab/localFont 12 548 45
+yaronn/GifW00t 12 544 45
+KeyboardFire/mkcast 70 3133 44
+labstack/echo 13 565 43
+begriffs/postgrest 54 2272 42
+jgrahamc/httpdiff 33 1393 42
+mentum/lambdaws 22 944 42
+mikechau/react-primer-draft 71 3039 42
+seppo0010/rlite 16 658 41
+shipitjs/shipit 47 1969 41
+sindresorhus/chalk 16 659 41
+bevacqua/fuzzysearch 15 609 40
+Yomguithereal/baobab 20 778 38
+pdcgomes/XCActionBar 25 963 38
+gizak/termui 73 2703 37
ko1/pretty_backtrace 14 519 37
-vim/vim 74 2746 37
BurntSushi/xsv 10 367 36
-gizak/termui 74 2716 36
-nicklockwood/MustOverride 12 434 36
-ry/v8worker 15 551 36
-systemjs/systemjs 35 1265 36
-codesuki/react-d3-components 12 420 35
-fizx/parsley 20 717 35
-israelidanny/ie8linter 21 741 35
-YabataDesign/afterglow-theme 26 896 34
-google/yapf 22 751 34
+nicklockwood/MustOverride 12 432 36
+vim/vim 74 2737 36
+israelidanny/ie8linter 21 737 35
+ry/v8worker 15 527 35
+simov/grant 10 351 35
+systemjs/systemjs 35 1234 35
+NYTimes/NYTPhotoViewer 12 415 34
+YabataDesign/afterglow-theme 26 895 34
+codesuki/react-d3-components 12 417 34
+fizx/parsley 20 698 34
trello/victor 11 379 34
-ianks/octodown 15 506 33
-joewalnes/websocketd 79 2615 33
-maxogden/menubar 14 462 33
-paulirish/automated-chrome-profiling 11 367 33
-resume/resume.github.com 50 1698 33
-shellfire-dev/shellfire 28 935 33
-venmo/synx 11 372 33
-krockode/x_x 12 393 32
-pheuter/essential-react 41 1318 32
-centaurean/density 20 622 31
-kriskowal/gtor 22 697 31
-tdenniston/bish 37 1167 31
-yaronn/blessed-contrib 184 5880 31
+google/yapf 22 746 33
+ianks/octodown 15 498 33
+joewalnes/websocketd 79 2614 33
+resume/resume.github.com 50 1669 33
+shellfire-dev/shellfire 27 910 33
+venmo/synx 11 368 33
+gopherjs/gopherjs 21 686 32
+icecrime/docker-mon 14 448 32
+krockode/x_x 12 391 32
+maxogden/menubar 14 460 32
+paulirish/automated-chrome-profiling 11 361 32
+pheuter/essential-react 41 1314 32
diff --git
a/regression-test/data/variant_p2/sql/proportionsBetweenStarsAndForks3.out
b/regression-test/data/variant_p2/sql/proportionsBetweenStarsAndForks3.out
index 15f702a471d..9eed6501830 100644
--- a/regression-test/data/variant_p2/sql/proportionsBetweenStarsAndForks3.out
+++ b/regression-test/data/variant_p2/sql/proportionsBetweenStarsAndForks3.out
@@ -1,53 +1,53 @@
-- This file is automatically generated. You should know what you did if you
want to edit this
-- !proportionsBetweenStarsAndForks3 --
zzzili/zzCommonProject 6 13 0
-zzzeek/sqlalchemy 27 94 0
+zzzeek/sqlalchemy 27 93 0
zzz40500/PhotoBrowser 5 8 0
-zzz40500/HeadsUp 25 61 0
+zzz40500/HeadsUp 25 59 0
zzz40500/GsonFormat 7 17 0
zzyss86/tuijscom 5 16 0
-zzyss86/LunarCalendar 7 23 0
+zzyss86/LunarCalendar 7 22 0
zzrough/gs-extensions-drop-down-terminal 5 9 0
-zzmp/juliusjs 20 126 0
-zzhouj/Android-DraggableGridViewPager 10 16 0
-zzet/ansible-rbenv-role 12 23 0
-zzdboy/GoCMS 11 16 0
-zzarcon/focusable 7 38 0
+zzmp/juliusjs 20 124 0
+zzhouj/Android-DraggableGridViewPager 9 16 0
+zzet/ansible-rbenv-role 11 22 0
+zzdboy/GoCMS 11 15 0
+zzarcon/focusable 7 37 0
zzarbi/synology 5 9 0
zzap/Cikonss 10 21 0
zytzagoo/smtp-validate-email 7 8 0
zythum/youkuhtml5playerbookmark 9 36 0
zythum/mama2 27 218 0
zyro/hyde-x 13 26 0
-zynga/scroller 34 588 0
+zynga/scroller 34 585 0
zynga/jsbindings 6 9 0
-zym2014/MingQQ 128 315 0
-zxlie/WeixinApi 186 356 0
+zym2014/MingQQ 124 311 0
+zxlie/WeixinApi 179 344 0
zxlie/FeHelper 8 20 0
-zxing/zxing 546 939 0
-zxh0/jvm.go 98 1256 0
-zxdrive/imouto.host 45 112 0
+zxing/zxing 536 927 0
+zxh0/jvm.go 97 1252 0
+zxdrive/imouto.host 43 112 0
zx2c4/password-store 15 37 0
-zwz/plantuml-mode 5 6 0
-zwopple/PocketSocket 5 14 0
-zwaldowski/BlocksKit 47 301 0
+zwopple/PocketSocket 5 13 0
+zwaldowski/BlocksKit 47 297 0
zwacky/angular-flippy 5 6 0
zverok/clio 7 21 0
zutrinken/attila 8 18 0
zurb/twentytwenty 10 37 0
zurb/responsive-tables 6 13 0
-zurb/pizza 6 14 0
+zurb/pizza 5 14 0
zurb/joyride 9 30 0
-zurb/ink 39 198 0
-zurb/foundation-rails 33 46 0
+zurb/ink 39 197 0
+zurb/foundation-rails 32 46 0
zurb/foundation-libsass-template 10 11 0
zurb/foundation-compass-template 14 17 0
zurb/foundation-apps-template 8 16 0
-zurb/foundation-apps 61 249 0
-zurb/foundation-5-sublime-snippets 19 51 0
-zurb/foundation 328 977 0
+zurb/foundation-apps 61 244 0
+zurb/foundation-5-sublime-snippets 19 50 0
+zurb/foundation 323 967 0
zurb/bower-foundation 31 37 0
zupet/LuaTinker 5 8 0
zuk/jquery.inview 10 13 0
-ztianjin/BigData 5 7 0
+ztellman/manifold 5 43 0
+ztellman/aleph 8 77 0
diff --git
a/regression-test/data/variant_p2/sql/proportionsBetweenStarsAndForks4.out
b/regression-test/data/variant_p2/sql/proportionsBetweenStarsAndForks4.out
index 78eef66a208..78e58cbdf99 100644
--- a/regression-test/data/variant_p2/sql/proportionsBetweenStarsAndForks4.out
+++ b/regression-test/data/variant_p2/sql/proportionsBetweenStarsAndForks4.out
@@ -1,4 +1,4 @@
-- This file is automatically generated. You should know what you did if you
want to edit this
-- !proportionsBetweenStarsAndForks4 --
-1493710 3951085 2.65
+1474745 3901627 2.65
diff --git
a/regression-test/data/variant_p2/sql/proportionsBetweenStarsAndForks5.out
b/regression-test/data/variant_p2/sql/proportionsBetweenStarsAndForks5.out
index 55770e05612..98d6d6a6fa7 100644
--- a/regression-test/data/variant_p2/sql/proportionsBetweenStarsAndForks5.out
+++ b/regression-test/data/variant_p2/sql/proportionsBetweenStarsAndForks5.out
@@ -1,4 +1,4 @@
-- This file is automatically generated. You should know what you did if you
want to edit this
-- !proportionsBetweenStarsAndForks5 --
-788721 2938913 3.73
+775821 2897072 3.73
diff --git
a/regression-test/data/variant_p2/sql/repositoriesWithClickhouse_related_comments1.out
b/regression-test/data/variant_p2/sql/repositoriesWithClickhouse_related_comments1.out
index 0102ad866f7..f383c9cf351 100644
---
a/regression-test/data/variant_p2/sql/repositoriesWithClickhouse_related_comments1.out
+++
b/regression-test/data/variant_p2/sql/repositoriesWithClickhouse_related_comments1.out
@@ -1,27 +1,27 @@
-- This file is automatically generated. You should know what you did if you
want to edit this
-- !repositoriesWithClickhouse_related_comments1 --
-apache/spark 9527
+apache/spark 9406
apache/incubator-brooklyn 426
-apache/incubator-reef 355
-brianchandotcom/liferay-portal 347
-owncloud/core 294
+apache/incubator-reef 351
+brianchandotcom/liferay-portal 346
+owncloud/core 291
apache/activemq-6 236
apache/flink 126
-shuyangzhou/liferay-portal 98
+shuyangzhou/liferay-portal 95
apache/storm 92
-NFLabs/zeppelin 89
+NFLabs/zeppelin 88
chrsmith/google-api-java-client 85
mtambara/liferay-portal 83
sergiogonzalez/liferay-portal 81
jirikuncar/invenio 76
puppetlabs/puppetlabs-apache 72
pentestgeek/phishing-frenzy 71
-puphpet/puphpet 68
+puphpet/puphpet 65
juliocamarero/liferay-portal 64
phusion/passenger 61
Homebrew/homebrew 52
apache/tajo 48
-saltstack/salt 46
+saltstack/salt 45
rotty3000/liferay-portal 44
apache/cloudstack 41
crowell/modpagespeed 41
@@ -33,21 +33,21 @@ ManageIQ/manageiq 35
apache/cordova-lib 34
spark-jobserver/spark-jobserver 34
commons-rdf/commons-rdf 32
-docker-library/php 32
-fail2ban/fail2ban 32
shawnmckinney/apache-fortress-demo 32
+docker-library/php 31
+fail2ban/fail2ban 31
matethurzo/liferay-portal 31
spring-projects/spring-boot 31
-intel-hadoop/gearpump 30
owncloud/client 30
apache/couchdb-fauxton 29
apache/incubator-parquet-mr 29
+intel-hadoop/gearpump 29
snipe/snipe-it 29
GoogleCloudPlatform/kubernetes 28
ampache/ampache 28
joomla/joomla-cms 28
-apache/camel 27
IQSS/dataverse 26
-openmicroscopy/openmicroscopy 26
+apache/camel 26
Shopify/sarama 25
+apache/wicket 25
diff --git
a/regression-test/data/variant_p2/sql/repositoriesWithClickhouse_related_comments2.out
b/regression-test/data/variant_p2/sql/repositoriesWithClickhouse_related_comments2.out
index 21d9cf83d44..f8f891f023d 100644
---
a/regression-test/data/variant_p2/sql/repositoriesWithClickhouse_related_comments2.out
+++
b/regression-test/data/variant_p2/sql/repositoriesWithClickhouse_related_comments2.out
@@ -1,53 +1,53 @@
-- This file is automatically generated. You should know what you did if you
want to edit this
-- !repositoriesWithClickhouse_related_comments2 --
-facebook/react-native 10021 1
-phanan/htaccess 7964 9
-sdelements/lets-chat 5045 7
-twbs/bootstrap 4475 2
-twostairs/paperwork 3684 20
-libreboard/libreboard 3469 1
-Selz/plyr 3403 2
-wasabeef/awesome-android-ui 3225 1
-sophron/wifiphisher 3142 2
-jhauswald/sirius 3030 1
-github/gitignore 2926 1
-FortAwesome/Font-Awesome 2798 1
-driftyco/ionic 2783 6
-iluwatar/java-design-patterns 2771 2
-atom/atom 2745 3
-docker/docker 2655 17
-Semantic-Org/Semantic-UI 2488 2
-meteor/meteor 2486 36
-golang/go 2252 4
-robbyrussell/oh-my-zsh 2227 2
-google/gxui 2172 1
-shadowsocks/shadowsocks 2134 3
-facebook/stetho 2085 2
-gogits/gogs 1959 6
-joyent/node 1940 8
-reapp/reapp 1925 2
-hakimel/reveal.js 1900 1
-rust-lang/rust 1869 13
-tripit/slate 1868 1
-Automattic/socket.io 1840 2
-angular/material 1778 3
-h5bp/html5-boilerplate 1710 1
-babel/babel 1693 1
-android-cn/android-open-project-analysis 1676 1
-dotnet/roslyn 1626 19
-lodash/lodash 1585 1
-Homebrew/homebrew 1583 52
-AFNetworking/AFNetworking 1572 2
-jekyll/jekyll 1479 7
-adobe/brackets 1463 2
-ansible/ansible 1441 7
-Polymer/polymer 1384 1
-haifengl/smile 1371 1
-django/django 1369 1
-jquery/jquery 1368 6
-rails/rails 1363 8
-mitsuhiko/flask 1359 4
-balderdashy/sails 1343 4
-Unitech/PM2 1311 1
-GoogleCloudPlatform/kubernetes 1303 28
+facebook/react-native 9918 1
+phanan/htaccess 7954 9
+sdelements/lets-chat 5039 7
+twbs/bootstrap 4428 2
+twostairs/paperwork 3465 19
+libreboard/libreboard 3388 1
+Selz/plyr 3381 2
+wasabeef/awesome-android-ui 3154 1
+sophron/wifiphisher 3067 2
+jhauswald/sirius 3010 1
+github/gitignore 2869 1
+FortAwesome/Font-Awesome 2758 1
+driftyco/ionic 2753 6
+iluwatar/java-design-patterns 2734 2
+atom/atom 2703 3
+docker/docker 2626 17
+meteor/meteor 2457 36
+Semantic-Org/Semantic-UI 2446 2
+golang/go 2213 4
+robbyrussell/oh-my-zsh 2202 2
+google/gxui 2169 1
+shadowsocks/shadowsocks 2090 3
+facebook/stetho 2075 2
+gogits/gogs 1950 6
+reapp/reapp 1920 2
+joyent/node 1899 8
+hakimel/reveal.js 1873 1
+rust-lang/rust 1838 13
+Automattic/socket.io 1820 2
+tripit/slate 1816 1
+angular/material 1760 3
+h5bp/html5-boilerplate 1697 1
+babel/babel 1681 1
+android-cn/android-open-project-analysis 1659 1
+dotnet/roslyn 1608 19
+lodash/lodash 1571 1
+Homebrew/homebrew 1561 52
+AFNetworking/AFNetworking 1540 2
+jekyll/jekyll 1457 7
+adobe/brackets 1439 2
+ansible/ansible 1430 7
+Polymer/polymer 1369 1
+django/django 1353 1
+haifengl/smile 1349 1
+mitsuhiko/flask 1347 4
+jquery/jquery 1342 5
+rails/rails 1341 8
+balderdashy/sails 1328 3
+Unitech/PM2 1294 1
+GoogleCloudPlatform/kubernetes 1288 28
diff --git
a/regression-test/data/variant_p2/sql/repositoriesWithDoris_related_comments1.out
b/regression-test/data/variant_p2/sql/repositoriesWithDoris_related_comments1.out
index 206617322f4..644a8778140 100644
---
a/regression-test/data/variant_p2/sql/repositoriesWithDoris_related_comments1.out
+++
b/regression-test/data/variant_p2/sql/repositoriesWithDoris_related_comments1.out
@@ -1,10 +1,10 @@
-- This file is automatically generated. You should know what you did if you
want to edit this
-- !repositoriesWithDoris_related_comments1 --
-apache/spark 15220
-amplab-extras/SparkR-pkg 289
-NFLabs/zeppelin 184
-datastax/spark-cassandra-connector 148
-spark-jobserver/spark-jobserver 146
+apache/spark 15039
+amplab-extras/SparkR-pkg 286
+NFLabs/zeppelin 182
+datastax/spark-cassandra-connector 145
+spark-jobserver/spark-jobserver 143
NREL/OpenStudio 88
awslabs/emr-bootstrap-actions 52
mesos/spark-ec2 50
@@ -12,28 +12,28 @@ spring-projects/spring-xd 46
spark/spark-cli 45
mikesparks/OLB-Dev-Tracker 44
perwendel/spark 44
-spark/firmware 43
andypetrella/spark-notebook 41
elasticsearch/elasticsearch-hadoop 41
caskdata/cdap 40
+spark/firmware 40
SparkDevNetwork/Rock 38
vslavik/winsparkle 34
cleanflight/cleanflight 33
ibm-et/spark-kernel 33
-sparkle-project/Sparkle 33
+sparkle-project/Sparkle 32
apache/mahout 30
databricks/spark-avro 29
-ReactiveCocoa/ReactiveCocoa 28
hbons/SparkleShare 28
-bigdatagenomics/adam 26
+ReactiveCocoa/ReactiveCocoa 27
libgit2/libgit2sharp 26
Carthage/Carthage 23
-TauLabs/TauLabs 23
databricks/spark-csv 23
+TauLabs/TauLabs 22
berkeley-dsc/dlab-finance 22
-sparklemotion/nokogiri 22
yola/healthcheck 22
+bigdatagenomics/adam 21
sampsyo/beets 21
+sparklemotion/nokogiri 21
ilayaperumalg/spring-xd 19
scalanlp/breeze 19
spark/spark-dev 19
@@ -45,9 +45,9 @@ SparkartGroupInc/jungle-solidus 17
tresata/spark-scalding 17
ComputationalRadiationPhysics/picongpu 16
KristaANelson/the_pivot 16
-atom/atom 16
gorillalabs/sparkling 16
robot-monkey/final-project 16
+atom/atom 15
ContinuumIO/into 14
geotrellis/geotrellis 14
diff --git
a/regression-test/data/variant_p2/sql/repositoriesWithDoris_related_comments2.out
b/regression-test/data/variant_p2/sql/repositoriesWithDoris_related_comments2.out
index 7e8ac449b6f..6f2e0253243 100644
---
a/regression-test/data/variant_p2/sql/repositoriesWithDoris_related_comments2.out
+++
b/regression-test/data/variant_p2/sql/repositoriesWithDoris_related_comments2.out
@@ -1,53 +1,53 @@
-- This file is automatically generated. You should know what you did if you
want to edit this
-- !repositoriesWithDoris_related_comments2 --
-facebook/react-native 10021 1
-alex/what-happens-when 7407 2
-prakhar1989/awesome-courses 6110 2
-yaronn/blessed-contrib 5880 2
-tiimgreen/github-cheat-sheet 5420 1
-gorhill/uBlock 5415 2
-iojs/io.js 4866 1
-dotnet/coreclr 4049 1
-angular/angular.js 3942 1
-muut/riotjs 3244 10
-github/gitignore 2926 4
-primer/primer 2816 1
-atom/atom 2745 16
-gizak/termui 2716 2
-docker/docker 2655 5
-lukasz-madon/awesome-remote-job 2579 1
-meteor/meteor 2486 1
-robbyrussell/oh-my-zsh 2227 1
-gogits/gogs 1959 2
-rust-lang/rust 1869 4
-prometheus/prometheus 1767 1
-dotnet/roslyn 1626 4
-neovim/neovim 1621 2
-lodash/lodash 1585 2
-Homebrew/homebrew 1583 13
-amjith/pgcli 1495 1
-jekyll/jekyll 1479 5
-ansible/ansible 1441 1
-dotnet/corefx 1389 1
-django/django 1369 1
-papers-we-love/papers-we-love 1366 1
-rails/rails 1363 4
-mrdoob/three.js 1351 1
-GoogleCloudPlatform/kubernetes 1303 6
-atom/atom-shell 1285 3
-google/guava 1274 1
-rg3/youtube-dl 1272 1
-scrapy/scrapy 1241 1
-kennethreitz/requests 1236 6
-mozilla/pdf.js 1234 1
-Microsoft/TypeScript 1217 3
-facebook/pop 1127 1
-BVLC/caffe 1102 1
-ReactiveCocoa/ReactiveCocoa 1098 28
-petkaantonov/bluebird 1095 1
-creationix/nvm 1081 1
-spoike/refluxjs 1073 1
-Carthage/Carthage 1043 23
-tastejs/todomvc 1035 1
-yiisoft/yii2 1034 2
+facebook/react-native 9918 1
+alex/what-happens-when 7307 2
+prakhar1989/awesome-courses 5998 2
+yaronn/blessed-contrib 5779 1
+tiimgreen/github-cheat-sheet 5315 1
+gorhill/uBlock 5299 2
+iojs/io.js 4729 1
+dotnet/coreclr 4042 1
+angular/angular.js 3893 1
+muut/riotjs 3203 10
+github/gitignore 2869 4
+primer/primer 2807 1
+atom/atom 2703 15
+gizak/termui 2703 2
+docker/docker 2626 5
+lukasz-madon/awesome-remote-job 2546 1
+meteor/meteor 2457 1
+robbyrussell/oh-my-zsh 2202 1
+gogits/gogs 1950 2
+rust-lang/rust 1838 4
+prometheus/prometheus 1762 1
+dotnet/roslyn 1608 4
+neovim/neovim 1583 2
+lodash/lodash 1571 2
+Homebrew/homebrew 1561 13
+amjith/pgcli 1472 1
+jekyll/jekyll 1457 5
+ansible/ansible 1430 1
+dotnet/corefx 1374 1
+django/django 1353 1
+rails/rails 1341 4
+mrdoob/three.js 1333 1
+papers-we-love/papers-we-love 1300 1
+GoogleCloudPlatform/kubernetes 1288 6
+atom/atom-shell 1266 3
+rg3/youtube-dl 1264 1
+google/guava 1262 1
+scrapy/scrapy 1227 1
+mozilla/pdf.js 1225 1
+kennethreitz/requests 1220 3
+Microsoft/TypeScript 1193 3
+facebook/pop 1116 1
+BVLC/caffe 1091 1
+petkaantonov/bluebird 1085 1
+ReactiveCocoa/ReactiveCocoa 1081 27
+creationix/nvm 1071 1
+Carthage/Carthage 1029 23
+yiisoft/yii2 1027 2
+tastejs/todomvc 1022 1
+apache/spark 1014 15039
diff --git
a/regression-test/data/variant_p2/sql/repositoriesWithTheMaximumAmountOfIssues1.out
b/regression-test/data/variant_p2/sql/repositoriesWithTheMaximumAmountOfIssues1.out
index 90778d85dc0..30b6c01feb5 100644
---
a/regression-test/data/variant_p2/sql/repositoriesWithTheMaximumAmountOfIssues1.out
+++
b/regression-test/data/variant_p2/sql/repositoriesWithTheMaximumAmountOfIssues1.out
@@ -1,53 +1,53 @@
-- This file is automatically generated. You should know what you did if you
want to edit this
-- !repositoriesWithTheMaximumAmountOfIssues1 --
-No-CQRT/GooGuns 24737 1
+No-CQRT/GooGuns 24407 1
chrsmith/google-api-java-client 10568 1
-Khan/khan-i18n 8940 1
+Khan/khan-i18n 8867 1
chrsmith/bwapi 6258 1
chrsmith/nishazi6 4877 1
LeaVerou/awesomplete 4608 748
chrsmith/html5rocks 4395 2
-huntermcmillian/huntermcmillian 3175 1
+huntermcmillian/huntermcmillian 3141 1
chrsmith/open-ig 2516 1
chrsmith/reaver-wps 2300 1
-djbouche/glowing-bear 2088 1
-andresriancho/w3af 1995 21
-sbezborotest/test 1989 5
+djbouche/glowing-bear 2061 1
+sbezborotest/test 1974 5
+andresriancho/w3af 1964 21
spyder-ide/spyder 1848 49
BOINC/boinc 1754 6
pedromorgan/flightgear-issues-test 1750 1
-Atlantiss/BugTracker 1665 501
pychess/pychess 1658 4
-rust-lang/rust 1648 589
+Atlantiss/BugTracker 1634 497
+rust-lang/rust 1626 582
sphinx-doc/testing2 1598 1
chrsmith/hedgewars 1447 1
wbish/IronPath 1309 1
TWtablero/repoTest1 1306 5
-owncloud/core 1299 577
-kewinrausch/Test 1293 1
+owncloud/core 1291 575
pzia/vlm 1244 1
LeaVerou/prefixfree 1226 106
BOINC/boinc-ng 1223 1
-joyent/node 1186 289
+kewinrausch/Test 1219 1
+joyent/node 1185 288
BALL-Project/ball 1162 4
ConEmu/old-issues 1144 1
chrsmith/blogger-ftp-migration-tracker 1133 1
v-l-m/vlm 1088 5
-atom/atom 1074 779
-GoogleCloudPlatform/kubernetes 1048 197
+atom/atom 1058 765
+GoogleCloudPlatform/kubernetes 1037 194
Virtual-TreeView/Virtual-TreeView 1037 10
-phalcon/cphalcon 1014 170
-fourq/hackball 1000 1
+phalcon/cphalcon 1012 168
+fourq/hackball 996 1
chrsmith/dsdsdaadf 991 1
chrsmith/jsjsj122 991 1
-dotnet/roslyn 962 209
+dotnet/roslyn 960 209
harishamdani/TestRepo 960 1
-saltstack/salt 958 448
+saltstack/salt 955 448
chrsmith/mo-1 948 1
chrsmithdemos/google-api-java-client 923 1
chrsmithdemos/open-ig 917 1
chrsmithdemos/html5rocks 911 1
chrsmith/scribefire-chrome 886 1
-CartoDB/cartodb 884 55
-docker/docker 873 524
+CartoDB/cartodb 873 55
+docker/docker 869 522
diff --git
a/regression-test/data/variant_p2/sql/repositoriesWithTheMaximumAmountOfIssues2.out
b/regression-test/data/variant_p2/sql/repositoriesWithTheMaximumAmountOfIssues2.out
index 4f8281d36dc..4857cc1206e 100644
---
a/regression-test/data/variant_p2/sql/repositoriesWithTheMaximumAmountOfIssues2.out
+++
b/regression-test/data/variant_p2/sql/repositoriesWithTheMaximumAmountOfIssues2.out
@@ -1,53 +1,53 @@
-- This file is automatically generated. You should know what you did if you
want to edit this
-- !repositoriesWithTheMaximumAmountOfIssues2 --
-No-CQRT/GooGuns 24737 1 0
+No-CQRT/GooGuns 24407 1 0
chrsmith/google-api-java-client 10568 1 0
-Khan/khan-i18n 8940 1 2
+Khan/khan-i18n 8867 1 2
chrsmith/bwapi 6258 1 0
chrsmith/nishazi6 4877 1 0
-LeaVerou/awesomplete 4608 748 3390
+LeaVerou/awesomplete 4608 748 3379
chrsmith/html5rocks 4395 2 0
-huntermcmillian/huntermcmillian 3175 1 1
+huntermcmillian/huntermcmillian 3141 1 1
chrsmith/open-ig 2516 1 0
chrsmith/reaver-wps 2300 1 0
-djbouche/glowing-bear 2088 1 0
-andresriancho/w3af 1995 21 68
-sbezborotest/test 1989 5 0
-spyder-ide/spyder 1848 49 175
-BOINC/boinc 1754 6 44
+djbouche/glowing-bear 2061 1 0
+sbezborotest/test 1974 5 0
+andresriancho/w3af 1964 21 67
+spyder-ide/spyder 1848 49 173
+BOINC/boinc 1754 6 43
pedromorgan/flightgear-issues-test 1750 1 0
-Atlantiss/BugTracker 1665 501 52
pychess/pychess 1658 4 24
-rust-lang/rust 1648 589 1869
+Atlantiss/BugTracker 1634 497 52
+rust-lang/rust 1626 582 1838
sphinx-doc/testing2 1598 1 0
chrsmith/hedgewars 1447 1 0
wbish/IronPath 1309 1 0
TWtablero/repoTest1 1306 5 0
-owncloud/core 1299 577 360
-kewinrausch/Test 1293 1 0
+owncloud/core 1291 575 354
pzia/vlm 1244 1 0
LeaVerou/prefixfree 1226 106 144
BOINC/boinc-ng 1223 1 0
-joyent/node 1186 289 1940
+kewinrausch/Test 1219 1 0
+joyent/node 1185 288 1899
BALL-Project/ball 1162 4 1
ConEmu/old-issues 1144 1 0
chrsmith/blogger-ftp-migration-tracker 1133 1 0
v-l-m/vlm 1088 5 7
-atom/atom 1074 779 2745
-GoogleCloudPlatform/kubernetes 1048 197 1303
+atom/atom 1058 765 2703
+GoogleCloudPlatform/kubernetes 1037 194 1288
Virtual-TreeView/Virtual-TreeView 1037 10 27
-phalcon/cphalcon 1014 170 592
-fourq/hackball 1000 1 0
+phalcon/cphalcon 1012 168 584
+fourq/hackball 996 1 0
chrsmith/dsdsdaadf 991 1 0
chrsmith/jsjsj122 991 1 0
-dotnet/roslyn 962 209 1626
+dotnet/roslyn 960 209 1608
harishamdani/TestRepo 960 1 0
-saltstack/salt 958 448 469
+saltstack/salt 955 448 464
chrsmith/mo-1 948 1 0
chrsmithdemos/google-api-java-client 923 1 0
chrsmithdemos/open-ig 917 1 0
chrsmithdemos/html5rocks 911 1 0
chrsmith/scribefire-chrome 886 1 0
-CartoDB/cartodb 884 55 102
-docker/docker 873 524 2655
+CartoDB/cartodb 873 55 101
+docker/docker 869 522 2626
diff --git
a/regression-test/data/variant_p2/sql/repositoriesWithTheMaximumAmountOfIssues3.out
b/regression-test/data/variant_p2/sql/repositoriesWithTheMaximumAmountOfIssues3.out
index 8ee41ec721b..4bd081661ad 100644
---
a/regression-test/data/variant_p2/sql/repositoriesWithTheMaximumAmountOfIssues3.out
+++
b/regression-test/data/variant_p2/sql/repositoriesWithTheMaximumAmountOfIssues3.out
@@ -1,53 +1,53 @@
-- This file is automatically generated. You should know what you did if you
want to edit this
-- !repositoriesWithTheMaximumAmountOfIssues3 --
-github/gitignore 0 0 2926
-torvalds/linux 0 0 2907
-thoughtbot/til 0 0 2769
-laravel/laravel 0 0 2056
-goagent/goagent 0 0 1912
-resume/resume.github.com 0 0 1698
-django/django 0 0 1369
-MaciejCzyzewski/retter 0 0 1245
-discourse/discourse 0 0 1172
+github/gitignore 0 0 2869
+torvalds/linux 0 0 2856
+thoughtbot/til 0 0 2691
+laravel/laravel 0 0 2036
+goagent/goagent 0 0 1870
+resume/resume.github.com 0 0 1669
+django/django 0 0 1353
+MaciejCzyzewski/retter 0 0 1217
bltavares/Knoodou 0 0 1157
-blueimp/jQuery-File-Upload 0 0 1091
-hakimel/css 0 0 1073
-angrave/SystemProgramming 0 0 1028
-apache/spark 0 0 1028
-jez/vim-as-an-ide 0 0 987
-simple-android-framework-exchange/android_design_patterns_analysis 0
0 888
-git/git 0 0 878
-Itseez/opencv 0 0 847
-wsargent/docker-cheat-sheet 0 0 835
-lgvalle/Material-Animations 0 0 810
-cdarwin/go-koans 0 0 767
-fcambus/nginx-resources 0 0 719
-ruby/ruby 0 0 690
-nathanpeck/clui 0 0 669
-owainlewis/awesome-artificial-intelligence 0 0 662
-vektra/templar 0 0 661
-qrpike/Web-Font-Load 0 0 656
-spring-projects/spring-framework 0 0 650
-mongodb/mongo 0 0 632
-Naituw/WBWebViewConsole 0 0 612
-php/php-src 0 0 607
+discourse/discourse 0 0 1157
+hakimel/css 0 0 1070
+blueimp/jQuery-File-Upload 0 0 1068
+angrave/SystemProgramming 0 0 1026
+apache/spark 0 0 1014
+jez/vim-as-an-ide 0 0 985
+simple-android-framework-exchange/android_design_patterns_analysis 0
0 879
+git/git 0 0 868
+Itseez/opencv 0 0 844
+wsargent/docker-cheat-sheet 0 0 827
+lgvalle/Material-Animations 0 0 802
+cdarwin/go-koans 0 0 766
+fcambus/nginx-resources 0 0 703
+ruby/ruby 0 0 683
+nathanpeck/clui 0 0 666
+owainlewis/awesome-artificial-intelligence 0 0 661
+qrpike/Web-Font-Load 0 0 655
+vektra/templar 0 0 645
+spring-projects/spring-framework 0 0 637
+mongodb/mongo 0 0 617
anicollection/anicollection 0 0 605
-geekcompany/ResumeSample 0 0 573
-yaronn/GifW00t 0 0 557
-WordPress/WordPress 0 0 534
-chrisbanes/Android-PullToRefresh 0 0 534
+Naituw/WBWebViewConsole 0 0 600
+php/php-src 0 0 599
+geekcompany/ResumeSample 0 0 562
+yaronn/GifW00t 0 0 544
spasmilo/electrum 0 0 533
-clojure/clojurescript 0 0 520
-oli107/material-range-bar 0 0 456
-bup/bup 0 0 453
-LukeLin/data-structure-with-js 0 0 439
-sparanoid/chinese-copywriting-guidelines 0 0 439
-chriskempson/base16 0 0 432
+WordPress/WordPress 0 0 530
+chrisbanes/Android-PullToRefresh 0 0 527
+clojure/clojurescript 0 0 518
+bup/bup 0 0 452
+oli107/material-range-bar 0 0 445
+LukeLin/data-structure-with-js 0 0 438
+sparanoid/chinese-copywriting-guidelines 0 0 437
keefo/CATweaker 0 0 430
-vandadnp/swift-weekly 0 0 410
+chriskempson/base16 0 0 421
mafintosh/airpaste 0 0 409
-johnno1962/Remote 0 0 403
-aosp-exchange-group/share 0 0 402
-nemoTyrant/manong 0 0 398
-apache/storm 0 0 396
+vandadnp/swift-weekly 0 0 409
+codrops/TextInputEffects 0 0 400
+apache/storm 0 0 394
+jenkinsci/jenkins 0 0 394
+nemoTyrant/manong 0 0 393
diff --git
a/regression-test/data/variant_p2/sql/repositoriesWithTheMaximumAmountOfIssues4.out
b/regression-test/data/variant_p2/sql/repositoriesWithTheMaximumAmountOfIssues4.out
index 623c4971ecf..e09031d428f 100644
---
a/regression-test/data/variant_p2/sql/repositoriesWithTheMaximumAmountOfIssues4.out
+++
b/regression-test/data/variant_p2/sql/repositoriesWithTheMaximumAmountOfIssues4.out
@@ -1,53 +1,53 @@
-- This file is automatically generated. You should know what you did if you
want to edit this
-- !repositoriesWithTheMaximumAmountOfIssues4 --
-github/gitignore 0 0 2926
-torvalds/linux 0 0 2907
-thoughtbot/til 0 0 2769
-laravel/laravel 0 0 2056
-goagent/goagent 0 0 1912
-resume/resume.github.com 0 0 1698
-django/django 0 0 1369
-MaciejCzyzewski/retter 0 0 1245
-discourse/discourse 0 0 1172
+github/gitignore 0 0 2869
+torvalds/linux 0 0 2856
+thoughtbot/til 0 0 2691
+laravel/laravel 0 0 2036
+goagent/goagent 0 0 1870
+resume/resume.github.com 0 0 1669
+django/django 0 0 1353
+MaciejCzyzewski/retter 0 0 1217
bltavares/Knoodou 0 0 1157
-blueimp/jQuery-File-Upload 0 0 1091
-hakimel/css 0 0 1073
-angrave/SystemProgramming 0 0 1028
-apache/spark 0 0 1028
-jez/vim-as-an-ide 0 0 987
-simple-android-framework-exchange/android_design_patterns_analysis 0
0 888
-git/git 0 0 878
-Itseez/opencv 0 0 847
-wsargent/docker-cheat-sheet 0 0 835
-lgvalle/Material-Animations 0 0 810
-cdarwin/go-koans 0 0 767
-fcambus/nginx-resources 0 0 719
-ruby/ruby 0 0 690
-nathanpeck/clui 0 0 669
-owainlewis/awesome-artificial-intelligence 0 0 662
-vektra/templar 0 0 661
-qrpike/Web-Font-Load 0 0 656
-spring-projects/spring-framework 0 0 650
-mongodb/mongo 0 0 632
-Naituw/WBWebViewConsole 0 0 612
-php/php-src 0 0 607
+discourse/discourse 0 0 1157
+hakimel/css 0 0 1070
+blueimp/jQuery-File-Upload 0 0 1068
+angrave/SystemProgramming 0 0 1026
+apache/spark 0 0 1014
+jez/vim-as-an-ide 0 0 985
+simple-android-framework-exchange/android_design_patterns_analysis 0
0 879
+git/git 0 0 868
+Itseez/opencv 0 0 844
+wsargent/docker-cheat-sheet 0 0 827
+lgvalle/Material-Animations 0 0 802
+cdarwin/go-koans 0 0 766
+fcambus/nginx-resources 0 0 703
+ruby/ruby 0 0 683
+nathanpeck/clui 0 0 666
+owainlewis/awesome-artificial-intelligence 0 0 661
+qrpike/Web-Font-Load 0 0 655
+vektra/templar 0 0 645
+spring-projects/spring-framework 0 0 637
+mongodb/mongo 0 0 617
anicollection/anicollection 0 0 605
-geekcompany/ResumeSample 0 0 573
-yaronn/GifW00t 0 0 557
-WordPress/WordPress 0 0 534
-chrisbanes/Android-PullToRefresh 0 0 534
+Naituw/WBWebViewConsole 0 0 600
+php/php-src 0 0 599
+geekcompany/ResumeSample 0 0 562
+yaronn/GifW00t 0 0 544
spasmilo/electrum 0 0 533
-clojure/clojurescript 0 0 520
-oli107/material-range-bar 0 0 456
-bup/bup 0 0 453
-LukeLin/data-structure-with-js 0 0 439
-sparanoid/chinese-copywriting-guidelines 0 0 439
-chriskempson/base16 0 0 432
+WordPress/WordPress 0 0 530
+chrisbanes/Android-PullToRefresh 0 0 527
+clojure/clojurescript 0 0 518
+bup/bup 0 0 452
+oli107/material-range-bar 0 0 445
+LukeLin/data-structure-with-js 0 0 438
+sparanoid/chinese-copywriting-guidelines 0 0 437
keefo/CATweaker 0 0 430
-vandadnp/swift-weekly 0 0 410
+chriskempson/base16 0 0 421
mafintosh/airpaste 0 0 409
-johnno1962/Remote 0 0 403
-aosp-exchange-group/share 0 0 402
-nemoTyrant/manong 0 0 398
-apache/storm 0 0 396
+vandadnp/swift-weekly 0 0 409
+codrops/TextInputEffects 0 0 400
+apache/storm 0 0 394
+jenkinsci/jenkins 0 0 394
+nemoTyrant/manong 0 0 393
diff --git
a/regression-test/data/variant_p2/sql/repositoriesWithTheMaximumAmountOfPullRequests2.out
b/regression-test/data/variant_p2/sql/repositoriesWithTheMaximumAmountOfPullRequests2.out
index 82e5a50926e..b2b26bdea51 100644
---
a/regression-test/data/variant_p2/sql/repositoriesWithTheMaximumAmountOfPullRequests2.out
+++
b/regression-test/data/variant_p2/sql/repositoriesWithTheMaximumAmountOfPullRequests2.out
@@ -1,53 +1,53 @@
-- This file is automatically generated. You should know what you did if you
want to edit this
-- !repositoriesWithTheMaximumAmountOfPullRequests2 --
-jlord/patchwork 1226 1064
-deadlyvipers/dojo_rules 1520 997
-octocat/Spoon-Knife 976 910
-Homebrew/homebrew 2194 691
-udacity/create-your-own-adventure 622 507
-caskroom/homebrew-cask 1440 442
-rails/rails 839 359
-baidu-ife/ife 381 347
-rust-lang/rust 1713 337
-apache/spark 1359 296
-laravel/framework 694 293
-docker/docker 1128 287
-LarryMad/recipes 293 268
-borisyankov/DefinitelyTyped 508 265
-saltstack/salt 1795 249
-NixOS/nixpkgs 1133 247
-JetBrains/swot 273 242
-wbond/package_control_channel 301 238
-rdpeng/ProgrammingAssignment2 243 224
-Azure/azure-content 784 217
+jlord/patchwork 1208 1053
+deadlyvipers/dojo_rules 1504 993
+octocat/Spoon-Knife 968 903
+Homebrew/homebrew 2170 684
+udacity/create-your-own-adventure 607 494
+caskroom/homebrew-cask 1428 441
+rails/rails 830 358
+baidu-ife/ife 367 338
+rust-lang/rust 1692 335
+apache/spark 1334 294
+laravel/framework 687 290
+docker/docker 1119 285
+borisyankov/DefinitelyTyped 505 264
+LarryMad/recipes 287 263
+saltstack/salt 1788 248
+NixOS/nixpkgs 1111 246
+JetBrains/swot 270 239
+wbond/package_control_channel 297 235
+Azure/azure-content 782 216
iloveponies/training-day 218 214
-cms-sw/cmssw 1485 213
-odoo/odoo 933 213
-django/django 578 196
-GoogleCloudPlatform/kubernetes 1793 194
+cms-sw/cmssw 1466 213
+odoo/odoo 927 213
+rdpeng/ProgrammingAssignment2 230 212
+django/django 575 195
+GoogleCloudPlatform/kubernetes 1783 194
laravel/docs 282 191
-angular/angular.js 334 188
-mozilla-b2g/gaia 2113 182
-symfony/symfony 614 175
-yiisoft/yii2 427 174
-iloveponies/i-am-a-horse-in-the-land-of-booleans 171 171
-ansible/ansible 297 170
-facebook/react 377 164
-TheOdinProject/curriculum 530 161
-cdnjs/cdnjs 294 161
-milkypostman/melpa 262 161
-ansible/ansible-modules-core 281 160
-leereilly/swot 199 158
-ga-students/wdi-fundamentals-rps 154 147
-iojs/io.js 570 136
+angular/angular.js 328 185
+mozilla-b2g/gaia 2084 181
+yiisoft/yii2 420 173
+symfony/symfony 600 172
+ansible/ansible 294 169
+iloveponies/i-am-a-horse-in-the-land-of-booleans 167 167
+facebook/react 375 163
+TheOdinProject/curriculum 521 160
+cdnjs/cdnjs 290 160
+ansible/ansible-modules-core 280 160
+milkypostman/melpa 261 160
+leereilly/swot 197 156
+ga-students/wdi-fundamentals-rps 153 146
+iojs/io.js 566 135
rcos/rcos-projects 170 134
-jsdelivr/jsdelivr 1147 127
-robbyrussell/oh-my-zsh 170 124
-joomla/joomla-cms 587 119
-ceph/ceph 909 115
-JuliaLang/METADATA.jl 422 115
-cocos2d/cocos2d-x 972 114
-michaelliao/learngit 123 114
-cakephp/docs 348 112
-ember-cli/ember-cli 376 111
+jsdelivr/jsdelivr 1137 127
+robbyrussell/oh-my-zsh 169 123
+joomla/joomla-cms 582 119
+ceph/ceph 896 114
+JuliaLang/METADATA.jl 420 114
+michaelliao/learngit 122 114
+cocos2d/cocos2d-x 962 113
+cakephp/docs 347 112
+tomchristie/django-rest-framework 192 110
diff --git
a/regression-test/data/variant_p2/sql/repositoriesWithTheMaximumNumberOfAcceptedInvitations.out
b/regression-test/data/variant_p2/sql/repositoriesWithTheMaximumNumberOfAcceptedInvitations.out
index 37e8e052dec..107fe7ec137 100644
---
a/regression-test/data/variant_p2/sql/repositoriesWithTheMaximumNumberOfAcceptedInvitations.out
+++
b/regression-test/data/variant_p2/sql/repositoriesWithTheMaximumNumberOfAcceptedInvitations.out
@@ -1,15 +1,15 @@
-- This file is automatically generated. You should know what you did if you
want to edit this
-- !repositoriesWithTheMaximumNumberOfAcceptedInvitations --
-cs428TAs/cs428 76 5
+cs428TAs/cs428 75 5
5harad/crowds 69 8
chrisvfritz/tc359_cheatsheets 56 2
madmilla/THO78-Roborescue 47 2
egingric/2015-Racing-Game 45 2
anrom7/NLP_with_Python 38 2
rsanchez-wsu/sp15-ceg3120 29 9
-projbdic32/bdi-c32 24 9
nadiagarcia/EDA-ITESO-2015 24 5
csteacherd22/preAPCS-4th-1415 23 7
+projbdic32/bdi-c32 23 7
profwpollock/COP-2805-2015 23 4
limingth/meteor-lean-startup-camp 22 18
raquel-oliveira/historinha 22 2
@@ -20,34 +20,34 @@ amchristi/cs362s15 20 4
gamondue/GOR5F 20 2
wgdomenzain/UAG.IDS.8010.2015.1 20 2
cretchas/projeto_es_2015_1 19 3
-hoenirvili/EDeC 19 3
snags88/euler-club 19 3
mskubenich/swan_rc3 18 8
bennieandthejets/SoftwareEngineering 18 6
-highya/ztb-leetcode 18 5
EScommander/Norco-GAM-79-Spr2015-CartGame 18 4
+highya/ztb-leetcode 18 4
asbezrukov/tvp-lab8 17 6
RShankar/Senior-Seminar-on-Social-Web 17 5
wgdomenzain/UAG.IDS.5010.2015.1 17 5
JJjie/HIT-CSDN-WEB 17 3
-brainix/basilisk 16 5
FcoMondro/ProgramacionWeb6D 16 2
annamel/acroparallels2015 16 2
Kentverger/wrk 15 16
+brainix/basilisk 15 5
zachmay/inventory616 15 4
JamesMuir/Creme_eggs 15 3
MahikanthNag/JAVAians 15 3
hieuletrung/iot-alljoyn 15 3
+hoenirvili/EDeC 15 3
rellermeyer/course_os 15 3
ghaida/gdisjc-website 15 2
polynquintela/CMSC128Project7L 15 2
-FreeCodeCamp/freecodecamp 14 123
+FreeCodeCamp/freecodecamp 14 122
iojs/iojs-es 14 43
rubis-lab/Vehicle-Dynamics-Simulator 14 10
jedepaepe/PeoplePicker 14 7
-mohammadKarimi/Bellatrix.OneSpace 14 4
-NielsRavn/AcmeInc 14 3
+mohammadKarimi/Bellatrix.OneSpace 14 3
gokcer/atilim-comodo-java-egitim 14 2
-jafuentest/totem 14 2
joemahmah/2022-frc-2015 14 2
+sindresorhus/awesome-scifi 13 214
+pychess/pychess 13 24
diff --git
a/regression-test/data/variant_p2/sql/repositoriesWithTheMostPeopleWhoHavePushAccess1.out
b/regression-test/data/variant_p2/sql/repositoriesWithTheMostPeopleWhoHavePushAccess1.out
index aebd7fe84f1..2ba973dfe0f 100644
---
a/regression-test/data/variant_p2/sql/repositoriesWithTheMostPeopleWhoHavePushAccess1.out
+++
b/regression-test/data/variant_p2/sql/repositoriesWithTheMostPeopleWhoHavePushAccess1.out
@@ -1,5 +1,6 @@
-- This file is automatically generated. You should know what you did if you
want to edit this
-- !repositoriesWithTheMostPeopleWhoHavePushAccess1 --
+zzzzrrr/porc 0 1
zzzsochi/trans 0 1
zzzombat/lucid-python-swftools 0 1
zzzili/json2object 0 1
@@ -49,5 +50,4 @@ zzkt/remembrance-agent 0 1
zzkt/osc 0 1
zzjhons/zravianx 0 1
zzjhons/izariam 0 1
-zzjhons/civclicker 0 1
diff --git
a/regression-test/data/variant_p2/sql/repositoriesWithTheMostPeopleWhoHavePushAccess2.out
b/regression-test/data/variant_p2/sql/repositoriesWithTheMostPeopleWhoHavePushAccess2.out
index 55b1335c1e7..ec92b757114 100644
---
a/regression-test/data/variant_p2/sql/repositoriesWithTheMostPeopleWhoHavePushAccess2.out
+++
b/regression-test/data/variant_p2/sql/repositoriesWithTheMostPeopleWhoHavePushAccess2.out
@@ -2,7 +2,7 @@
-- !repositoriesWithTheMostPeopleWhoHavePushAccess2 --
zzzzzzzzzzzzzzzzzzzzzzzzzzz/project 0 0
zzzzsong/testup 0 2
-zzzzrrr/porc 0 2
+zzzzrrr/porc 0 1
zzzzBov/oAuthTwitterWrapper 0 0
zzzzBov/npm-expansions 0 0
zzzsochi/trans 0 1
@@ -29,7 +29,7 @@ zzz40500/InboxLayout 0 1
zzyss86/zepto-learn 0 1
zzyss86/tuijs-blog 0 2
zzyss86/Smarthosts 0 1
-zzyss86/LunarCalendar 0 23
+zzyss86/LunarCalendar 0 22
zzyss86/LESS-CSS3 0 1
zzyjan/MercuryProject1 0 0
zzyfisherman/moose 0 0
diff --git
a/regression-test/data/variant_p2/sql/repositoriesWithTheMostPeopleWhoHavePushAccess3.out
b/regression-test/data/variant_p2/sql/repositoriesWithTheMostPeopleWhoHavePushAccess3.out
index 9dd30f4455e..a1baa1b42ea 100644
---
a/regression-test/data/variant_p2/sql/repositoriesWithTheMostPeopleWhoHavePushAccess3.out
+++
b/regression-test/data/variant_p2/sql/repositoriesWithTheMostPeopleWhoHavePushAccess3.out
@@ -1,53 +1,53 @@
-- This file is automatically generated. You should know what you did if you
want to edit this
-- !repositoriesWithTheMostPeopleWhoHavePushAccess3 --
-edx/edx-platform 62 205
-NixOS/nixpkgs 53 133
-aosp-exchange-group/fuck-2014-flirt-2015 45 158
-GoogleCloudPlatform/kubernetes 37 1303
-dotnet/roslyn 36 1626
-guardian/frontend 36 176
-mongodb/mongo 35 632
-JuliaLang/julia 32 517
-dotnet/corefx 30 1389
+edx/edx-platform 62 204
+NixOS/nixpkgs 53 132
+aosp-exchange-group/fuck-2014-flirt-2015 44 153
+GoogleCloudPlatform/kubernetes 37 1288
+dotnet/roslyn 36 1608
+guardian/frontend 36 172
+mongodb/mongo 34 617
+JuliaLang/julia 32 509
+dotnet/corefx 30 1374
neo4j/neo4j 29 227
-xbmc/xbmc 28 283
-elasticsearch/elasticsearch 27 899
-odoo/odoo 26 662
-facebook/rocksdb 25 354
-puppetlabs/puppet 25 282
-elastic/elasticsearch 24 369
-rails/rails 24 1363
-dotnet/coreclr 23 4049
-mono/mono 22 374
-angular/angular 21 1636
+xbmc/xbmc 28 280
+elasticsearch/elasticsearch 27 890
+odoo/odoo 26 654
+facebook/rocksdb 25 347
+puppetlabs/puppet 25 276
+elastic/elasticsearch 24 365
+rails/rails 24 1341
+dotnet/coreclr 23 4042
+mono/mono 22 366
+angular/angular 21 1609
google/trace-viewer 21 171
-JetBrains/kotlin 20 320
-aosp-exchange-group/share 20 402
-ceph/ceph 20 161
-rapid7/metasploit-framework 20 450
-telerik/kendo-ui-core 20 210
-docker/docker 19 2655
-reddit/reddit 19 608
-thoughtbot/guides 19 515
-CartoDB/cartodb 18 102
-mono/monodevelop 18 103
-owncloud/core 18 360
+JetBrains/kotlin 20 315
+aosp-exchange-group/share 20 372
+ceph/ceph 20 160
+rapid7/metasploit-framework 20 447
+telerik/kendo-ui-core 20 207
+docker/docker 19 2626
+reddit/reddit 19 597
+thoughtbot/guides 19 512
+CartoDB/cartodb 18 101
+owncloud/core 18 354
chef/chef 17 182
-Microsoft/TypeScript 16 1217
-django/django 16 1369
+Microsoft/TypeScript 16 1193
+django/django 16 1353
thoughtbot/hound 16 148
-thoughtbot/til 16 2769
-Azure/azure-content 15 112
-facebook/react 15 6762
-grpc/grpc 15 2313
-h2oai/h2o 15 199
-adobe/brackets 14 1463
-cockroachdb/cockroach 13 679
-emberjs/ember.js 13 1132
-jenkinsci/jenkins 13 396
-dolphin-emu/dolphin 12 344
-ember-cli/ember-cli 12 470
-openframeworks/openFrameworks 12 211
-openvswitch/ovs 12 128
-raspberrypi/documentation 12 113
+thoughtbot/til 16 2691
+Azure/azure-content 15 111
+facebook/react 15 6696
+grpc/grpc 15 2297
+h2oai/h2o 15 195
+adobe/brackets 14 1439
+cockroachdb/cockroach 13 673
+emberjs/ember.js 13 1119
+jenkinsci/jenkins 13 394
+dolphin-emu/dolphin 12 332
+ember-cli/ember-cli 12 466
+openvswitch/ovs 12 127
+raspberrypi/documentation 12 112
+scikit-learn/scikit-learn 12 814
+NativeScript/nativescript-cli 11 203
diff --git
a/regression-test/data/variant_p2/sql/repositoriesWithTheMostStarsOverOneDay1.out
b/regression-test/data/variant_p2/sql/repositoriesWithTheMostStarsOverOneDay1.out
index ca26ff418af..08b56dec73b 100644
---
a/regression-test/data/variant_p2/sql/repositoriesWithTheMostStarsOverOneDay1.out
+++
b/regression-test/data/variant_p2/sql/repositoriesWithTheMostStarsOverOneDay1.out
@@ -1,53 +1,53 @@
-- This file is automatically generated. You should know what you did if you
want to edit this
-- !repositoriesWithTheMostStarsOverOneDay1 --
-facebook/react-native 10021
-phanan/htaccess 7964
-alex/what-happens-when 7407
-facebook/react 6762
-moklick/frontend-stuff 6528
-prakhar1989/awesome-courses 6110
-yaronn/blessed-contrib 5880
-arasatasaygin/is.js 5498
-vhf/free-programming-books 5437
-tiimgreen/github-cheat-sheet 5420
-gorhill/uBlock 5415
-Flipboard/react-canvas 5187
-h5bp/Front-end-Developer-Interview-Questions 5177
-sdelements/lets-chat 5045
-iojs/io.js 4866
-bendc/frontend-guidelines 4696
-twbs/bootstrap 4475
-getify/You-Dont-Know-JS 4344
-0xAX/linux-insides 4220
-IanLunn/Hover 4102
-dotnet/coreclr 4049
-daniel-lundin/snabbt.js 3996
-angular/angular.js 3942
-Mango/slideout 3866
-twostairs/paperwork 3684
-Dogfalo/materialize 3664
-libreboard/libreboard 3469
-mbostock/d3 3422
-Selz/plyr 3403
-USArmyResearchLab/Dshell 3401
-LeaVerou/awesomplete 3390
-MengTo/Spring 3276
-muut/riotjs 3244
-wasabeef/awesome-android-ui 3225
-airbnb/javascript 3155
-sophron/wifiphisher 3142
-KeyboardFire/mkcast 3134
-google/fonts 3122
-mikechau/react-primer-draft 3044
-jhauswald/sirius 3030
-sbstjn/timesheet.js 3005
-github/gitignore 2926
-torvalds/linux 2907
-IonicaBizau/git-stats 2896
-googlesamples/android-UniversalMusicPlayer 2838
-nwjs/nw.js 2829
-primer/primer 2816
-lukehoban/es6features 2810
-FortAwesome/Font-Awesome 2798
-driftyco/ionic 2783
+facebook/react-native 9918
+phanan/htaccess 7954
+alex/what-happens-when 7307
+facebook/react 6696
+moklick/frontend-stuff 6466
+prakhar1989/awesome-courses 5998
+yaronn/blessed-contrib 5779
+arasatasaygin/is.js 5493
+vhf/free-programming-books 5395
+tiimgreen/github-cheat-sheet 5315
+gorhill/uBlock 5299
+Flipboard/react-canvas 5174
+h5bp/Front-end-Developer-Interview-Questions 5134
+sdelements/lets-chat 5039
+iojs/io.js 4729
+bendc/frontend-guidelines 4655
+twbs/bootstrap 4428
+getify/You-Dont-Know-JS 4315
+0xAX/linux-insides 4171
+dotnet/coreclr 4042
+IanLunn/Hover 3983
+daniel-lundin/snabbt.js 3925
+angular/angular.js 3893
+Mango/slideout 3834
+Dogfalo/materialize 3636
+twostairs/paperwork 3465
+USArmyResearchLab/Dshell 3398
+libreboard/libreboard 3388
+Selz/plyr 3381
+LeaVerou/awesomplete 3379
+mbostock/d3 3376
+MengTo/Spring 3270
+muut/riotjs 3203
+wasabeef/awesome-android-ui 3154
+KeyboardFire/mkcast 3133
+google/fonts 3104
+airbnb/javascript 3091
+sophron/wifiphisher 3067
+mikechau/react-primer-draft 3039
+jhauswald/sirius 3010
+sbstjn/timesheet.js 2982
+IonicaBizau/git-stats 2894
+github/gitignore 2869
+torvalds/linux 2856
+googlesamples/android-UniversalMusicPlayer 2819
+primer/primer 2807
+nwjs/nw.js 2796
+lukehoban/es6features 2785
+FortAwesome/Font-Awesome 2758
+wishstudio/flinux 2754
diff --git
a/regression-test/data/variant_p2/sql/repositoriesWithTheMostStarsOverOneDay2.out
b/regression-test/data/variant_p2/sql/repositoriesWithTheMostStarsOverOneDay2.out
index a4be8b85f18..9cd8ef1b807 100644
---
a/regression-test/data/variant_p2/sql/repositoriesWithTheMostStarsOverOneDay2.out
+++
b/regression-test/data/variant_p2/sql/repositoriesWithTheMostStarsOverOneDay2.out
@@ -1,53 +1,53 @@
-- This file is automatically generated. You should know what you did if you
want to edit this
-- !repositoriesWithTheMostStarsOverOneDay2 --
-facebook/react-native 10021
-phanan/htaccess 7964
-alex/what-happens-when 7407
-facebook/react 6762
-moklick/frontend-stuff 6528
-prakhar1989/awesome-courses 6110
-yaronn/blessed-contrib 5880
-arasatasaygin/is.js 5498
-vhf/free-programming-books 5437
-tiimgreen/github-cheat-sheet 5420
-gorhill/uBlock 5415
-Flipboard/react-canvas 5187
-h5bp/Front-end-Developer-Interview-Questions 5177
-sdelements/lets-chat 5045
-iojs/io.js 4866
-bendc/frontend-guidelines 4696
-twbs/bootstrap 4475
-getify/You-Dont-Know-JS 4344
-0xAX/linux-insides 4220
-IanLunn/Hover 4102
-dotnet/coreclr 4049
-daniel-lundin/snabbt.js 3996
-angular/angular.js 3942
-Mango/slideout 3866
-twostairs/paperwork 3684
-Dogfalo/materialize 3664
-libreboard/libreboard 3469
-mbostock/d3 3422
-Selz/plyr 3403
-USArmyResearchLab/Dshell 3401
-LeaVerou/awesomplete 3390
-MengTo/Spring 3276
-muut/riotjs 3244
-wasabeef/awesome-android-ui 3225
-airbnb/javascript 3155
-sophron/wifiphisher 3142
-KeyboardFire/mkcast 3134
-google/fonts 3122
-mikechau/react-primer-draft 3044
-jhauswald/sirius 3030
-sbstjn/timesheet.js 3005
-github/gitignore 2926
-torvalds/linux 2907
-IonicaBizau/git-stats 2896
-googlesamples/android-UniversalMusicPlayer 2838
-nwjs/nw.js 2829
-primer/primer 2816
-lukehoban/es6features 2810
-FortAwesome/Font-Awesome 2798
-driftyco/ionic 2783
+facebook/react-native 9918
+phanan/htaccess 7954
+alex/what-happens-when 7307
+facebook/react 6696
+moklick/frontend-stuff 6466
+prakhar1989/awesome-courses 5998
+yaronn/blessed-contrib 5779
+arasatasaygin/is.js 5493
+vhf/free-programming-books 5395
+tiimgreen/github-cheat-sheet 5315
+gorhill/uBlock 5299
+Flipboard/react-canvas 5174
+h5bp/Front-end-Developer-Interview-Questions 5134
+sdelements/lets-chat 5039
+iojs/io.js 4729
+bendc/frontend-guidelines 4655
+twbs/bootstrap 4428
+getify/You-Dont-Know-JS 4315
+0xAX/linux-insides 4171
+dotnet/coreclr 4042
+IanLunn/Hover 3983
+daniel-lundin/snabbt.js 3925
+angular/angular.js 3893
+Mango/slideout 3834
+Dogfalo/materialize 3636
+twostairs/paperwork 3465
+USArmyResearchLab/Dshell 3398
+libreboard/libreboard 3388
+Selz/plyr 3381
+LeaVerou/awesomplete 3379
+mbostock/d3 3376
+MengTo/Spring 3270
+muut/riotjs 3203
+wasabeef/awesome-android-ui 3154
+KeyboardFire/mkcast 3133
+google/fonts 3104
+airbnb/javascript 3091
+sophron/wifiphisher 3067
+mikechau/react-primer-draft 3039
+jhauswald/sirius 3010
+sbstjn/timesheet.js 2982
+IonicaBizau/git-stats 2894
+github/gitignore 2869
+torvalds/linux 2856
+googlesamples/android-UniversalMusicPlayer 2819
+primer/primer 2807
+nwjs/nw.js 2796
+lukehoban/es6features 2785
+FortAwesome/Font-Awesome 2758
+wishstudio/flinux 2754
diff --git
a/regression-test/data/variant_p2/sql/repositoriesWithTheMostStarsOverOneDay3.out
b/regression-test/data/variant_p2/sql/repositoriesWithTheMostStarsOverOneDay3.out
index c97893738c6..dca7d6be0cc 100644
---
a/regression-test/data/variant_p2/sql/repositoriesWithTheMostStarsOverOneDay3.out
+++
b/regression-test/data/variant_p2/sql/repositoriesWithTheMostStarsOverOneDay3.out
@@ -1,53 +1,53 @@
-- This file is automatically generated. You should know what you did if you
want to edit this
-- !repositoriesWithTheMostStarsOverOneDay3 --
-facebook/react-native 10021
-phanan/htaccess 7964
-alex/what-happens-when 7407
-facebook/react 6762
-moklick/frontend-stuff 6528
-prakhar1989/awesome-courses 6110
-yaronn/blessed-contrib 5880
-arasatasaygin/is.js 5498
-vhf/free-programming-books 5437
-tiimgreen/github-cheat-sheet 5420
-gorhill/uBlock 5415
-Flipboard/react-canvas 5187
-h5bp/Front-end-Developer-Interview-Questions 5177
-sdelements/lets-chat 5045
-iojs/io.js 4866
-bendc/frontend-guidelines 4696
-twbs/bootstrap 4475
-getify/You-Dont-Know-JS 4344
-0xAX/linux-insides 4220
-IanLunn/Hover 4102
-dotnet/coreclr 4049
-daniel-lundin/snabbt.js 3996
-angular/angular.js 3942
-Mango/slideout 3866
-twostairs/paperwork 3684
-Dogfalo/materialize 3664
-libreboard/libreboard 3469
-mbostock/d3 3422
-Selz/plyr 3403
-USArmyResearchLab/Dshell 3401
-LeaVerou/awesomplete 3390
-MengTo/Spring 3276
-muut/riotjs 3244
-wasabeef/awesome-android-ui 3225
-airbnb/javascript 3155
-sophron/wifiphisher 3142
-KeyboardFire/mkcast 3134
-google/fonts 3122
-mikechau/react-primer-draft 3044
-jhauswald/sirius 3030
-sbstjn/timesheet.js 3005
-github/gitignore 2926
-torvalds/linux 2907
-IonicaBizau/git-stats 2896
-googlesamples/android-UniversalMusicPlayer 2838
-nwjs/nw.js 2829
-primer/primer 2816
-lukehoban/es6features 2810
-FortAwesome/Font-Awesome 2798
-driftyco/ionic 2783
+facebook/react-native 9918
+phanan/htaccess 7954
+alex/what-happens-when 7307
+facebook/react 6696
+moklick/frontend-stuff 6466
+prakhar1989/awesome-courses 5998
+yaronn/blessed-contrib 5779
+arasatasaygin/is.js 5493
+vhf/free-programming-books 5395
+tiimgreen/github-cheat-sheet 5315
+gorhill/uBlock 5299
+Flipboard/react-canvas 5174
+h5bp/Front-end-Developer-Interview-Questions 5134
+sdelements/lets-chat 5039
+iojs/io.js 4729
+bendc/frontend-guidelines 4655
+twbs/bootstrap 4428
+getify/You-Dont-Know-JS 4315
+0xAX/linux-insides 4171
+dotnet/coreclr 4042
+IanLunn/Hover 3983
+daniel-lundin/snabbt.js 3925
+angular/angular.js 3893
+Mango/slideout 3834
+Dogfalo/materialize 3636
+twostairs/paperwork 3465
+USArmyResearchLab/Dshell 3398
+libreboard/libreboard 3388
+Selz/plyr 3381
+LeaVerou/awesomplete 3379
+mbostock/d3 3376
+MengTo/Spring 3270
+muut/riotjs 3203
+wasabeef/awesome-android-ui 3154
+KeyboardFire/mkcast 3133
+google/fonts 3104
+airbnb/javascript 3091
+sophron/wifiphisher 3067
+mikechau/react-primer-draft 3039
+jhauswald/sirius 3010
+sbstjn/timesheet.js 2982
+IonicaBizau/git-stats 2894
+github/gitignore 2869
+torvalds/linux 2856
+googlesamples/android-UniversalMusicPlayer 2819
+primer/primer 2807
+nwjs/nw.js 2796
+lukehoban/es6features 2785
+FortAwesome/Font-Awesome 2758
+wishstudio/flinux 2754
diff --git
a/regression-test/data/variant_p2/sql/repositoriesWithTheWorstStagnation_order.out
b/regression-test/data/variant_p2/sql/repositoriesWithTheWorstStagnation_order.out
index 9dce31a0abd..d30506eefd4 100644
---
a/regression-test/data/variant_p2/sql/repositoriesWithTheWorstStagnation_order.out
+++
b/regression-test/data/variant_p2/sql/repositoriesWithTheWorstStagnation_order.out
@@ -26,20 +26,20 @@
01org/XenGT-Preview-kernel 0 9 0
01org/XenGT-Preview-qemu 0 4 0
01org/XenGT-Preview-xen 0 4 0
-01org/appframework 0 99 0
+01org/appframework 0 97 0
01org/clloader 0 2 0
01org/cordova-google-play-games-services 0 2 0
01org/dleyna-control 0 3 0
01org/dleyna-core 0 2 0
01org/dleyna-server 0 2 0
-01org/dpdk-ovs 0 21 0
+01org/dpdk-ovs 0 20 0
01org/fiovisualizer 0 4 0
01org/hpc-speedometer 0 3 0
01org/idlf 0 2 0
01org/ioprof 0 8 0
01org/jWebAudio 0 6 0
01org/liblwm2m 0 3 0
-01org/libxcam 0 5 0
+01org/libxcam 0 4 0
01org/libyami 0 5 0
01org/luv-yocto 0 2 0
01org/mic 0 2 0
diff --git a/regression-test/data/variant_p2/sql/repositoryAffinityList2.out
b/regression-test/data/variant_p2/sql/repositoryAffinityList2.out
index 8087663833e..ac0f99a2300 100644
--- a/regression-test/data/variant_p2/sql/repositoryAffinityList2.out
+++ b/regression-test/data/variant_p2/sql/repositoryAffinityList2.out
@@ -1,53 +1,53 @@
-- This file is automatically generated. You should know what you did if you
want to edit this
-- !repositoryAffinityList2 --
-0xPIT/encoder 10 100.4
-0xmalloc/c-log 10 100.4
-0xsauby/yasuo 10 100.4
-1000Memories/TMQuiltView 10 100.4
-1001Pharmacies/dictionary 10 100.4
-10gen-labs/edda 10 100.4
-18F/hub 10 100.4
-1c7/Youtube-Auto-Subtitle-Download 10 100.4
-200Creative/spree_bootstrap_frontend 10 100.4
-201-created/ember-cli-headroom 10 100.4
-222464/AILib 10 100.4
-360works/fmangular 10 100.4
-3logic/apollo-cassandra 10 100.4
-3rdpartyeve/phealng 10 100.4
-4k3R/material-color-picker 10 100.4
-5-say/laravel-4.1-quick-start-cn 10 100.4
-504ensicsLabs/DAMM 10 100.4
-5HT/n2o.hs 10 100.4
-626Pilot/RaspberryPi-NeoPixel-WS2812 10 100.4
-6pac/SlickGrid 10 100.4
-6to5/6to5.github.io 10 100.4
-AArnott/PCLCrypto 10 100.4
-ADmad/cakephp-jwt-auth 10 100.4
-AF83/fnf-detect 10 100.4
-ARM-software/arm-trusted-firmware 10 100.4
-ARMmbed/yotta 10 100.4
-AWCN/AndroidDevWeekly 10 100.4
-ActiveState/appdirs 10 100.4
-AdamBien/afterburner.fx 10 100.4
-AdamBrodzinski/meteor-mobile-boilerplate 10 100.4
-Aegisub/Aegisub 10 100.4
-AlanChatham/UnoJoy 10 100.4
-AlbertGrobas/PolygonImageView 10 100.4
-AlexanderGrom/Qevix 10 100.4
-Alkalinee/Hurricane 10 100.4
-AlloyTeam/AlloyStick 10 100.4
-AltBeacon/spec 10 100.4
-AltspaceVR/MacMoveToRift 10 100.4
-AlxMedia/anew 10 100.4
-AminRahimi/angular-bootstrap-persian-datepicker 10 100.4
-AmpersandJS/ampersandjs.com 10 100.4
-Anahkiasen/polyglot 10 100.4
-AndreasBriese/ipLocator 10 100.4
-AndrewDryga/vagrant-box-osx-mavericks 10 100.4
-AndrewSchenk/App-Scanner 10 100.4
-Anizoptera/AzaThread 10 100.4
-Anomen/vagrant-selenium 10 100.4
-Anonyfox/meteor-scrape 10 100.4
-AnthonyDiGirolamo/todotxt-machine 10 100.4
-Antrikshy/Quibbler 10 100.4
+0install/0install 10 99.0
+0xPIT/encoder 10 99.0
+0xsauby/yasuo 10 99.0
+1000Memories/TMQuiltView 10 99.0
+1001Pharmacies/dictionary 10 99.0
+10gen-labs/edda 10 99.0
+13W/docker-cp 10 99.0
+1c7/Youtube-Auto-Subtitle-Download 10 99.0
+200Creative/spree_bootstrap_frontend 10 99.0
+201-created/ember-cli-headroom 10 99.0
+222464/AILib 10 99.0
+3logic/apollo-cassandra 10 99.0
+3rdpartyeve/phealng 10 99.0
+4k3R/material-color-picker 10 99.0
+5-say/laravel-4.1-quick-start-cn 10 99.0
+504ensicsLabs/DAMM 10 99.0
+5HT/n2o.hs 10 99.0
+626Pilot/RaspberryPi-NeoPixel-WS2812 10 99.0
+6pac/SlickGrid 10 99.0
+9a/plotclock 10 99.0
+ADmad/cakephp-jwt-auth 10 99.0
+AF83/fnf-detect 10 99.0
+ARM-software/arm-trusted-firmware 10 99.0
+ARMmbed/yotta 10 99.0
+AWCN/AndroidDevWeekly 10 99.0
+ActiveState/appdirs 10 99.0
+AdamBien/afterburner.fx 10 99.0
+AdilSoomro/ASTextField 10 99.0
+Aegisub/Aegisub 10 99.0
+AlanChatham/UnoJoy 10 99.0
+AlbertGrobas/PolygonImageView 10 99.0
+AlexanderGrom/Qevix 10 99.0
+AlibabaTech/fastjson 10 99.0
+Alkalinee/Hurricane 10 99.0
+AlloyTeam/AlloyStick 10 99.0
+AltBeacon/spec 10 99.0
+AltspaceVR/MacMoveToRift 10 99.0
+AlxMedia/anew 10 99.0
+AminRahimi/angular-bootstrap-persian-datepicker 10 99.0
+AmpersandJS/ampersandjs.com 10 99.0
+AnFengDe/AnFengDe_EPUB 10 99.0
+Anahkiasen/polyglot 10 99.0
+AndreasBriese/ipLocator 10 99.0
+AndrewDryga/vagrant-box-osx-mavericks 10 99.0
+Anizoptera/AzaThread 10 99.0
+Anomen/vagrant-selenium 10 99.0
+Anonyfox/meteor-scrape 10 99.0
+AnthonyDiGirolamo/todotxt-machine 10 99.0
+Appletone/SwiftObjcCocoapodsExample 10 99.0
+AquaSoftGmbH/RefCountTracer 10 99.0
diff --git a/regression-test/data/variant_p2/sql/sql02.out
b/regression-test/data/variant_p2/sql/sql02.out
index 8cbf5e8227a..828dc276fa3 100644
--- a/regression-test/data/variant_p2/sql/sql02.out
+++ b/regression-test/data/variant_p2/sql/sql02.out
@@ -1,4 +1,4 @@
-- This file is automatically generated. You should know what you did if you
want to edit this
-- !sql02 --
-21881363
+21627264
diff --git a/regression-test/data/variant_p2/sql/sql03.out
b/regression-test/data/variant_p2/sql/sql03.out
index d033b827579..4aca237047e 100644
--- a/regression-test/data/variant_p2/sql/sql03.out
+++ b/regression-test/data/variant_p2/sql/sql03.out
@@ -1,4 +1,4 @@
-- This file is automatically generated. You should know what you did if you
want to edit this
-- !sql03 --
-21881363
+21627264
diff --git a/regression-test/data/variant_p2/sql/sql06.out
b/regression-test/data/variant_p2/sql/sql06.out
index 247a88c06ee..512dd4030dc 100644
--- a/regression-test/data/variant_p2/sql/sql06.out
+++ b/regression-test/data/variant_p2/sql/sql06.out
@@ -1,4 +1,4 @@
-- This file is automatically generated. You should know what you did if you
want to edit this
-- !sql06 --
-1910661
+1892193
diff --git a/regression-test/data/variant_p2/sql/theLongestRepositoryNames2.out
b/regression-test/data/variant_p2/sql/theLongestRepositoryNames2.out
index ae941f8e12f..9ee8d2bfdf5 100644
--- a/regression-test/data/variant_p2/sql/theLongestRepositoryNames2.out
+++ b/regression-test/data/variant_p2/sql/theLongestRepositoryNames2.out
@@ -2,27 +2,27 @@
-- !theLongestRepositoryNames2 --
hf/q 2
mg/i 1
-tj/n 450
+tj/n 446
0a-/M 1
bpq/1 1
bpq/q 2
-i3/i3 281
+i3/i3 278
knu/z 1
kr/fs 6
kr/hk 2
-kr/s3 9
+kr/s3 7
m8w/1 1
m8w/2 1
nf/dl 7
rf/nd 4
rr/rr 7
-ry/hl 70
+ry/hl 68
s4/s4 1
-sjl/d 8
+sjl/d 7
sjl/t 23
sm/sm 2
tj/bm 3
-tj/co 453
+tj/co 449
v8/v8 128
wq/wq 5
xtk/X 21
diff --git a/regression-test/data/variant_p2/sql/theMostToughCodeReviews.out
b/regression-test/data/variant_p2/sql/theMostToughCodeReviews.out
index e4111f443f2..de6c205b545 100644
--- a/regression-test/data/variant_p2/sql/theMostToughCodeReviews.out
+++ b/regression-test/data/variant_p2/sql/theMostToughCodeReviews.out
@@ -1,53 +1,53 @@
-- This file is automatically generated. You should know what you did if you
want to edit this
-- !theMostToughCodeReviews --
-https://github.com/Homebrew/homebrew/pull/ 257
-https://github.com/apache/spark/pull/ 198
+https://github.com/Homebrew/homebrew/pull/ 255
+https://github.com/apache/spark/pull/ 197
https://github.com/rails/rails/pull/ 171
-https://github.com/rust-lang/rust/pull/ 156
-https://github.com/docker/docker/pull/ 135
+https://github.com/rust-lang/rust/pull/ 155
+https://github.com/docker/docker/pull/ 133
https://github.com/mozilla-b2g/gaia/pull/ 123
-https://github.com/symfony/symfony/pull/ 118
+https://github.com/symfony/symfony/pull/ 117
https://github.com/GoogleCloudPlatform/kubernetes/pull/ 107
https://github.com/rust-lang/rfcs/pull/ 107
https://github.com/edx/edx-platform/pull/ 103
-https://github.com/deadlyvipers/dojo_rules/pull/ 85
https://github.com/odoo/odoo/pull/ 85
-https://github.com/NixOS/nixpkgs/pull/ 84
+https://github.com/deadlyvipers/dojo_rules/pull/ 84
https://github.com/django/django/pull/ 84
https://github.com/iojs/io.js/pull/ 84
+https://github.com/NixOS/nixpkgs/pull/ 83
https://github.com/tgstation/-tg-station/pull/ 81
https://github.com/cms-sw/cmssw/pull/ 76
-https://github.com/laravel/framework/pull/ 71
https://github.com/dotnet/corefx/pull/ 70
+https://github.com/laravel/framework/pull/ 70
https://github.com/JuliaLang/julia/pull/ 59
-https://github.com/dotnet/roslyn/pull/ 58
https://github.com/xbmc/xbmc/pull/ 58
-https://github.com/php/php-src/pull/ 56
-https://github.com/dolphin-emu/dolphin/pull/ 55
+https://github.com/dotnet/roslyn/pull/ 57
+https://github.com/php/php-src/pull/ 55
+https://github.com/dolphin-emu/dolphin/pull/ 54
https://github.com/scikit-learn/scikit-learn/pull/ 54
https://github.com/puppetlabs/puppet/pull/ 53
https://github.com/D-Programming-Language/phobos/pull/ 52
https://github.com/joomla/joomla-cms/pull/ 50
https://github.com/iojs/website/pull/ 49
https://github.com/facebook/react/pull/ 48
-https://github.com/angular/angular.js/pull/ 47
https://github.com/thoughtbot/til/pull/ 47
+https://github.com/angular/angular.js/pull/ 46
https://github.com/dotnet/coreclr/pull/ 46
-https://github.com/sympy/sympy/pull/ 46
https://github.com/TrinityCore/TrinityCore/pull/ 45
https://github.com/symfony/symfony-docs/pull/ 45
-https://github.com/caskroom/homebrew-cask/pull/ 44
+https://github.com/sympy/sympy/pull/ 45
https://github.com/ceph/ceph/pull/ 44
https://github.com/emberjs/ember.js/pull/ 44
https://github.com/scipy/scipy/pull/ 44
https://github.com/Wikia/app/pull/ 43
-https://github.com/neovim/neovim/pull/ 43
+https://github.com/caskroom/homebrew-cask/pull/ 43
https://github.com/CleverRaven/Cataclysm-DDA/pull/ 42
-https://github.com/cakephp/cakephp/pull/ 42
+https://github.com/neovim/neovim/pull/ 42
https://github.com/rapid7/metasploit-framework/pull/ 42
-https://github.com/saltstack/salt/pull/ 42
https://github.com/ManageIQ/manageiq/pull/ 41
+https://github.com/cakephp/cakephp/pull/ 41
https://github.com/owncloud/core/pull/ 41
+https://github.com/saltstack/salt/pull/ 41
https://github.com/matplotlib/matplotlib/pull/ 40
https://github.com/zendframework/zf2/pull/ 40
diff --git
a/regression-test/data/variant_p2/sql/theTotalNumberOfRepositoriesOnGithub.out
b/regression-test/data/variant_p2/sql/theTotalNumberOfRepositoriesOnGithub.out
index 40fcc46bc87..cbbafb3d903 100644
---
a/regression-test/data/variant_p2/sql/theTotalNumberOfRepositoriesOnGithub.out
+++
b/regression-test/data/variant_p2/sql/theTotalNumberOfRepositoriesOnGithub.out
@@ -1,4 +1,4 @@
-- This file is automatically generated. You should know what you did if you
want to edit this
-- !theTotalNumberOfRepositoriesOnGithub --
-3675646
+3652845
diff --git
a/regression-test/data/variant_p2/sql/theTotalNumberOfUsersOnGithub1.out
b/regression-test/data/variant_p2/sql/theTotalNumberOfUsersOnGithub1.out
index fe0d72e9622..1fccf4779dd 100644
--- a/regression-test/data/variant_p2/sql/theTotalNumberOfUsersOnGithub1.out
+++ b/regression-test/data/variant_p2/sql/theTotalNumberOfUsersOnGithub1.out
@@ -1,4 +1,4 @@
-- This file is automatically generated. You should know what you did if you
want to edit this
-- !theTotalNumberOfUsersOnGithub1 --
-1737953
+1731169
diff --git
a/regression-test/data/variant_p2/sql/theTotalNumberOfUsersOnGithub2.out
b/regression-test/data/variant_p2/sql/theTotalNumberOfUsersOnGithub2.out
index 717e8e95154..8f0e3865a09 100644
--- a/regression-test/data/variant_p2/sql/theTotalNumberOfUsersOnGithub2.out
+++ b/regression-test/data/variant_p2/sql/theTotalNumberOfUsersOnGithub2.out
@@ -1,4 +1,4 @@
-- This file is automatically generated. You should know what you did if you
want to edit this
-- !theTotalNumberOfUsersOnGithub2 --
-524456
+521556
diff --git
a/regression-test/data/variant_p2/sql/theTotalNumberOfUsersOnGithub3.out
b/regression-test/data/variant_p2/sql/theTotalNumberOfUsersOnGithub3.out
index 093f92f9766..6ce5676198a 100644
--- a/regression-test/data/variant_p2/sql/theTotalNumberOfUsersOnGithub3.out
+++ b/regression-test/data/variant_p2/sql/theTotalNumberOfUsersOnGithub3.out
@@ -1,4 +1,4 @@
-- This file is automatically generated. You should know what you did if you
want to edit this
-- !theTotalNumberOfUsersOnGithub3 --
-975615
+972089
diff --git
a/regression-test/data/variant_p2/sql/theTotalNumberOfUsersOnGithub4.out
b/regression-test/data/variant_p2/sql/theTotalNumberOfUsersOnGithub4.out
index 3b00e391e11..97cc8344cd0 100644
--- a/regression-test/data/variant_p2/sql/theTotalNumberOfUsersOnGithub4.out
+++ b/regression-test/data/variant_p2/sql/theTotalNumberOfUsersOnGithub4.out
@@ -1,4 +1,4 @@
-- This file is automatically generated. You should know what you did if you
want to edit this
-- !theTotalNumberOfUsersOnGithub4 --
-228702
+227441
diff --git a/regression-test/data/variant_p2/sql/topRepositoriesByStars.out
b/regression-test/data/variant_p2/sql/topRepositoriesByStars.out
index 1221a8714c0..150e1f5bec6 100644
--- a/regression-test/data/variant_p2/sql/topRepositoriesByStars.out
+++ b/regression-test/data/variant_p2/sql/topRepositoriesByStars.out
@@ -1,53 +1,53 @@
-- This file is automatically generated. You should know what you did if you
want to edit this
-- !topRepositoriesByStars --
-facebook/react-native 10021
-phanan/htaccess 7964
-alex/what-happens-when 7407
-facebook/react 6762
-moklick/frontend-stuff 6528
-prakhar1989/awesome-courses 6110
-yaronn/blessed-contrib 5880
-arasatasaygin/is.js 5498
-vhf/free-programming-books 5437
-tiimgreen/github-cheat-sheet 5420
-gorhill/uBlock 5415
-Flipboard/react-canvas 5187
-h5bp/Front-end-Developer-Interview-Questions 5177
-sdelements/lets-chat 5045
-iojs/io.js 4866
-bendc/frontend-guidelines 4696
-twbs/bootstrap 4475
-getify/You-Dont-Know-JS 4344
-0xAX/linux-insides 4220
-IanLunn/Hover 4102
-dotnet/coreclr 4049
-daniel-lundin/snabbt.js 3996
-angular/angular.js 3942
-Mango/slideout 3866
-twostairs/paperwork 3684
-Dogfalo/materialize 3664
-libreboard/libreboard 3469
-mbostock/d3 3422
-Selz/plyr 3403
-USArmyResearchLab/Dshell 3401
-LeaVerou/awesomplete 3390
-MengTo/Spring 3276
-muut/riotjs 3244
-wasabeef/awesome-android-ui 3225
-airbnb/javascript 3155
-sophron/wifiphisher 3142
-KeyboardFire/mkcast 3134
-google/fonts 3122
-mikechau/react-primer-draft 3044
-jhauswald/sirius 3030
-sbstjn/timesheet.js 3005
-github/gitignore 2926
-torvalds/linux 2907
-IonicaBizau/git-stats 2896
-googlesamples/android-UniversalMusicPlayer 2838
-nwjs/nw.js 2829
-primer/primer 2816
-lukehoban/es6features 2810
-FortAwesome/Font-Awesome 2798
-driftyco/ionic 2783
+facebook/react-native 9918
+phanan/htaccess 7954
+alex/what-happens-when 7307
+facebook/react 6696
+moklick/frontend-stuff 6466
+prakhar1989/awesome-courses 5998
+yaronn/blessed-contrib 5779
+arasatasaygin/is.js 5493
+vhf/free-programming-books 5395
+tiimgreen/github-cheat-sheet 5315
+gorhill/uBlock 5299
+Flipboard/react-canvas 5174
+h5bp/Front-end-Developer-Interview-Questions 5134
+sdelements/lets-chat 5039
+iojs/io.js 4729
+bendc/frontend-guidelines 4655
+twbs/bootstrap 4428
+getify/You-Dont-Know-JS 4315
+0xAX/linux-insides 4171
+dotnet/coreclr 4042
+IanLunn/Hover 3983
+daniel-lundin/snabbt.js 3925
+angular/angular.js 3893
+Mango/slideout 3834
+Dogfalo/materialize 3636
+twostairs/paperwork 3465
+USArmyResearchLab/Dshell 3398
+libreboard/libreboard 3388
+Selz/plyr 3381
+LeaVerou/awesomplete 3379
+mbostock/d3 3376
+MengTo/Spring 3270
+muut/riotjs 3203
+wasabeef/awesome-android-ui 3154
+KeyboardFire/mkcast 3133
+google/fonts 3104
+airbnb/javascript 3091
+sophron/wifiphisher 3067
+mikechau/react-primer-draft 3039
+jhauswald/sirius 3010
+sbstjn/timesheet.js 2982
+IonicaBizau/git-stats 2894
+github/gitignore 2869
+torvalds/linux 2856
+googlesamples/android-UniversalMusicPlayer 2819
+primer/primer 2807
+nwjs/nw.js 2796
+lukehoban/es6features 2785
+FortAwesome/Font-Awesome 2758
+wishstudio/flinux 2754
diff --git
a/regression-test/data/variant_p2/sql/whatIsTheBestDayOfTheWeekToCatchAStar.out
b/regression-test/data/variant_p2/sql/whatIsTheBestDayOfTheWeekToCatchAStar.out
index 03d42c917e0..d78de9a3877 100644
---
a/regression-test/data/variant_p2/sql/whatIsTheBestDayOfTheWeekToCatchAStar.out
+++
b/regression-test/data/variant_p2/sql/whatIsTheBestDayOfTheWeekToCatchAStar.out
@@ -1,10 +1,10 @@
-- This file is automatically generated. You should know what you did if you
want to edit this
-- !whatIsTheBestDayOfTheWeekToCatchAStar --
-1 413283
-2 595194
-3 656708
-4 618366
-5 606669
-6 606171
-7 454694
+1 405443
+2 584733
+3 642275
+4 614670
+5 604248
+6 597259
+7 452999
diff --git
a/regression-test/data/variant_p2/sql/whoAreAllThosePeopleGivingStars1.out
b/regression-test/data/variant_p2/sql/whoAreAllThosePeopleGivingStars1.out
index e34c40c6ca6..15e27f904c0 100644
--- a/regression-test/data/variant_p2/sql/whoAreAllThosePeopleGivingStars1.out
+++ b/regression-test/data/variant_p2/sql/whoAreAllThosePeopleGivingStars1.out
@@ -1,53 +1,53 @@
-- This file is automatically generated. You should know what you did if you
want to edit this
-- !whoAreAllThosePeopleGivingStars1 --
-mcanthony 6085
-pkt 3437
+mcanthony 6013
kojiwakayama 3388
-maoabc1818 2392
+pkt 3375
+maoabc1818 2336
trnsz 2227
JT5D 2020
-jiangplus 2008
-tejasmanohar 1946
+jiangplus 1958
+tejasmanohar 1899
xavierdutreilh 1878
-fountainhead 1861
+fountainhead 1858
ARoiD 1610
-nikolay 1401
-Jerzerak 1358
-scratcher28 1349
-xu6148152 1339
-ArtemKulyabin 1240
-yoshuawuyts 1195
-timelyportfolio 1193
-frozzare 1170
-mkhoeini 1106
-kgryte 1098
-nazeeruddinikram 1065
-AUS3RIS 1058
-Doppp 1028
+nikolay 1373
+Jerzerak 1344
+scratcher28 1333
+xu6148152 1281
+ArtemKulyabin 1193
+yoshuawuyts 1184
+timelyportfolio 1183
+frozzare 1152
+mkhoeini 1104
+kgryte 1094
+nazeeruddinikram 1064
+AUS3RIS 1027
+Doppp 1019
adolphenom 1009
marceloboeira 990
-denji 953
-sescobb27 953
-Kaom 950
-se77en 941
-hbm1985 909
-pillowsoft 898
-gkze 891
-kwcto 890
-shunwang 872
-wrjqss 872
-trietptm 864
-hanton 860
-cwonrails 845
+sescobb27 952
+Kaom 948
+denji 939
+se77en 910
+hbm1985 908
+pillowsoft 883
+gkze 872
+shunwang 870
+wrjqss 870
+kwcto 869
+trietptm 863
+cwonrails 837
+hanton 834
SuriyaaKudoIsc 833
-0x73 820
gashouse 815
-swhgoon 810
-RincLiu 791
+swhgoon 800
TetragrammatonHermit 791
-eerie 789
-edersohe 786
+RincLiu 787
+eerie 779
savage69kr 774
-pingjiang 763
ibmendoza 761
+pingjiang 760
+0x73 752
+syswow 750
diff --git a/regression-test/suites/variant_p0/load.groovy
b/regression-test/suites/variant_p0/load.groovy
index aa6bc7159f3..0501d3ce52f 100644
--- a/regression-test/suites/variant_p0/load.groovy
+++ b/regression-test/suites/variant_p0/load.groovy
@@ -337,7 +337,7 @@ suite("regression_test_variant", "variant_type"){
sql """insert into ${table_name} values (6, '{"j" : 1}'), (1, '{"a" :
1}')"""
sql """insert into ${table_name} values (6, '{"k" : 1}'), (1, '{"a" :
1}')"""
sql "select * from ${table_name}"
- qt_sql_36_1 "select v:a, v:b, v:c from ${table_name} order by k limit
10"
+ qt_sql_36_1 "select cast(v:a as int), cast(v:b as int), cast(v:c as
int) from ${table_name} order by k limit 10"
sql "DELETE FROM ${table_name} WHERE k=1"
sql "select * from ${table_name}"
qt_sql_36_2 "select * from ${table_name} where k > 3 order by k desc
limit 10"
diff --git a/regression-test/suites/variant_p2/load.groovy
b/regression-test/suites/variant_p2/load.groovy
index 1a403d4504a..5813d02fb63 100644
--- a/regression-test/suites/variant_p2/load.groovy
+++ b/regression-test/suites/variant_p2/load.groovy
@@ -122,6 +122,7 @@ suite("github_event_advance_p2", "variant_type,p2"){
break;
}
if (result[0][2].equals("CANCELLED")) {
+ log.warn("load failed: $result")
assertTrue(false, "load failed: $result")
break;
}
---------------------------------------------------------------------
To unsubscribe, e-mail: commits-unsubscr...@doris.apache.org
For additional commands, e-mail: commits-h...@doris.apache.org
