FROM (
WITH RECURSIVE "cte" AS (
SELECT DISTINCT "contributors_repository"."id", ROW_NUMBER() OVER (
ORDER BY COUNT("contributors_contribution"."id") FILTER (
WHERE (
"contributors_contribution"."type" = %s AND "contributors_contributor"."is_visible"
)) DESC) AS "num", COUNT("contributors_contribution"."id") FILTER (
WHERE (
"contributors_contribution"."type" = %s AND "contributors_contributor"."is_visible"
))
FROM "contributors_repository"
LEFT OUTER JOIN "contributors_contribution" ON ("contributors_repository"."id" =
"contributors_contribution"."repository_id")
LEFT OUTER JOIN "contributors_contributor" ON ("contributors_contribution"."contributor_id" =
"contributors_contributor"."id")
INNER JOIN "contributors_repository_labels" ON ("contributors_repository"."id" =
"contributors_repository_labels"."repository_id")
INNER JOIN "contributors_label" ON ("contributors_repository_labels"."label_id" =
"contributors_label"."id")
INNER JOIN "contributors_repository_labels" T6 ON ("contributors_repository"."id" =
T6."repository_id")
INNER JOIN "contributors_label" T7 ON (T6."label_id" = T7."id")
INNER JOIN "contributors_repository_labels" T8 ON ("contributors_repository"."id" =
T8."repository_id")
INNER JOIN "contributors_label" T9 ON (T8."label_id" = T9."id")
WHERE (
"contributors_repository"."is_visible" AND LOWER("contributors_label"."name") IN (
%s, %s, %s, %s, %s, %s, %s, %s, %s, %s
) AND LOWER(T7."name") IN (
%s, %s, %s, %s, %s, %s, %s, %s, %s, %s
) AND LOWER(T9."name") IN (
%s, %s, %s, %s, %s, %s, %s, %s, %s, %s
)
)
GROUP BY "contributors_repository"."id"
ORDER BY COUNT("contributors_contribution"."id") FILTER (
WHERE (
"contributors_contribution"."type" = %s AND "contributors_contributor"."is_visible"
)) DESC)
SELECT DISTINCT "contributors_repository"."id" AS "col1", "contributors_repository"."name" AS "col2",
"contributors_repository"."html_url" AS "col3", "contributors_repository"."is_tracked" AS "col4",
"contributors_repository"."owner_id" AS "col5", "contributors_repository"."organization_id" AS
"col6", "contributors_repository"."project_id" AS "col7", "contributors_repository"."full_name" AS
"col8", "contributors_repository"."is_visible" AS "col9", COUNT("contributors_contribution"."id")
FILTER (
WHERE (
"contributors_contribution"."type" = %s AND "contributors_contributor"."is_visible"
)) AS "pull_requests", COUNT("contributors_contribution"."id") FILTER (
WHERE (
"contributors_contribution"."type" = %s AND "contributors_contributor"."is_visible"
)) AS "issues", COUNT(DISTINCT "contributors_contribution"."contributor_id") FILTER (
WHERE "contributors_contributor"."is_visible") AS "contributors_count", "cte"."num" AS "num"
FROM "contributors_repository"
LEFT OUTER JOIN "contributors_contribution" ON ("contributors_repository"."id" =
"contributors_contribution"."repository_id")
LEFT OUTER JOIN "contributors_contributor" ON ("contributors_contribution"."contributor_id" =
"contributors_contributor"."id")
INNER JOIN "contributors_repository_labels" ON ("contributors_repository"."id" =
"contributors_repository_labels"."repository_id")
INNER JOIN "contributors_label" ON ("contributors_repository_labels"."label_id" =
"contributors_label"."id")
INNER JOIN "contributors_repository_labels" T6 ON ("contributors_repository"."id" =
T6."repository_id")
INNER JOIN "contributors_label" T7 ON (T6."label_id" = T7."id")
INNER JOIN "contributors_repository_labels" T8 ON ("contributors_repository"."id" =
T8."repository_id")
INNER JOIN "contributors_label" T9 ON (T8."label_id" = T9."id")
INNER JOIN "cte" ON "contributors_repository"."id" = ("cte"."id")
WHERE (
"contributors_repository"."is_visible" AND LOWER("contributors_label"."name") IN (
%s, %s, %s, %s, %s, %s, %s, %s, %s, %s
) AND LOWER(T7."name") IN (
%s, %s, %s, %s, %s, %s, %s, %s, %s, %s
) AND LOWER(T9."name") IN (
%s, %s, %s, %s, %s, %s, %s, %s, %s, %s
)
)
GROUP BY 1, 13
) subquery```
https://nikolay-gagarinov.sentry.io/share/issue/04bd2032be5445a4bc35290158c57e4d/
labels
mathematica.php.makefile.fortran.scss.java.nsis.c.javascript.racket sort
-issues