Create a gist now

Instantly share code, notes, and snippets.

What would you like to do?
A query against the GitHub Archive for "seven dirty word" usage in 2012
SELECT repository_name, repository_language, repository_description, repository_watchers, payload_commit_msg, url, PARSE_UTC_USEC(created_at) as timestamp
FROM [githubarchive:github.timeline]
WHERE type="PushEvent"
AND (
LOWER(payload_commit_msg) CONTAINS "shit" OR
LOWER(payload_commit_msg) CONTAINS "piss" OR
LOWER(payload_commit_msg) CONTAINS "fuck" OR
LOWER(payload_commit_msg) CONTAINS "cunt" OR
LOWER(payload_commit_msg) CONTAINS "cocksucker" OR
LOWER(payload_commit_msg) CONTAINS "motherfucker" OR
LOWER(payload_commit_msg) CONTAINS "tits"
)
AND PARSE_UTC_USEC(created_at) >= PARSE_UTC_USEC('2012-01-01 00:00:00')
ORDER BY timestamp DESC;
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment