bigcode/commitpackmeta

1SELECT2  *3FROM (4  SELECT5    repo_name,6    lang.name AS language_name7  FROM8    `bigquery-public-data.github_repos.languages` AS lang_table,9    UNNEST(LANGUAGE) AS lang) lang_table10JOIN11  `bigquery-public-data.github_repos.licenses` AS license_table12ON13  license_table.repo_name = lang_table.repo_name14JOIN (15  SELECT16    *17  FROM18    `bigquery-public-data.github_repos.commits` AS commits_table,19    UNNEST(repo_name) AS unnested_repo_name) commits_table20ON21  commits_table.unnested_repo_name = lang_table.repo_name22WHERE23  ((license_table.license LIKE 'mit')24    OR (license_table.license LIKE 'artistic-2.0')25    OR (license_table.license LIKE 'isc')26    OR (license_table.license LIKE 'cc0-1.0')27    OR (license_table.license LIKE 'apache-2.0')28    OR (license_table.license LIKE 'unlicense')29    OR (license_table.license LIKE 'bsd-3-clause')30    OR (license_table.license LIKE 'bsd-2-clause'))31AND32  ( (LENGTH(commits_table.message) > 10) )33AND 34  ( (LENGTH(commits_table.message) < 10000) )35AND commits_table.message NOT IN ('update readme.md', 'initial commit', 'update', 'Mirroring from micro.blog.', 'update data.json', 'update data.js', 'add files via upload', 'update readme', "Can't you see I'm updating the time?", 'pi push', 'dummy', 'update index.html', 'first commit', 'create readme.md', 'heartbeat update', 'updated readme', 'update log', 'test', 'no message', 'readme', 'wip', 'updates', 'commit', 'update _config.yaml')36AND commits_table.message not like 'Merge%';