gh-query

bg-github

SELECT
  repos.repo_name
FROM
  `bigquery-public-data.github_repos.sample_repos` repos
LEFT JOIN
  `bigquery-public-data.github_repos.sample_files` files
ON
  repos.repo_name = files.repo_name
LEFT JOIN
  `bigquery-public-data.github_repos.sample_contents` contents
ON
  files.id = contents.id
WHERE
  NOT contents.binary
  AND contents.content like '%MRN%'
  AND contents.content like '%Last%'
GROUP BY
  repos.repo_name, repos.watch_count
ORDER BY
  repos.watch_count DESC
LIMIT
  30