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;