BigQuery Github public data search Semantic UI
SELECT | |
id, | |
sample_repo_name, | |
SPLIT(content, '\n') line, | |
FROM | |
[bigquery-public-data:github_repos.sample_contents] | |
WHERE | |
(sample_path LIKE '%.html' | |
OR sample_path LIKE '%.json' | |
OR sample_path LIKE '%.js') | |
AND NOT binary | |
HAVING (line CONTAINS 'semantic.js' OR line CONTAINS 'semantic.min.js' OR line CONTAINS 'semantic-ui-css' | |
OR line CONTAINS 'semantic-ui.js' | |
OR line CONTAINS 'semantic-ui-less' | |
OR line CONTAINS 'less-plugin-semantic-ui' | |
OR line CONTAINS 'semantic-ui-ember' | |
OR line CONTAINS 'semantic:ui' | |
OR line CONTAINS 'semantic:ui-css' | |
) IGNORE CASE; | |
Sign up for free
to join this conversation on GitHub.
Already have an account?
Sign in to comment