Skip to content

Instantly share code, notes, and snippets.

@jarib

jarib/goldman.sql

Created August 14, 2014 22:45
Show Gist options
  • Star 0 You must be signed in to star a gist
  • Fork 0 You must be signed in to fork a gist
  • Save jarib/43f1d927fcfd3a0ba101 to your computer and use it in GitHub Desktop.
Save jarib/43f1d927fcfd3a0ba101 to your computer and use it in GitHub Desktop.
Download ZIP
Raw
goldman.sql
SELECT
id,
title,
CONCAT('http://en.wikipedia.org/w/index.php?diff=', STRING(revision_id)) AS diff_url,
revision_id,
timestamp,
contributor_ip,
PARSE_IP(contributor_ip) as contributor_ip_int
FROM publicdata:samples.wikipedia
HAVING (
(contributor_ip_int >= PARSE_IP("199.99.47.0") AND contributor_ip_int <= PARSE_IP("199.99.47.255")) # Goldman Sachs
OR (contributor_ip_int >= PARSE_IP("199.99.28.0") AND contributor_ip_int <= PARSE_IP("199.99.28.255")) # Goldman Sachs
OR (contributor_ip_int >= PARSE_IP("199.99.22.0") AND contributor_ip_int <= PARSE_IP("199.99.22.255")) # Goldman Sachs
OR (contributor_ip_int >= PARSE_IP("199.99.2.0") AND contributor_ip_int <= PARSE_IP("199.99.2.255")) # Goldman Sachs
OR (contributor_ip_int >= PARSE_IP("199.99.16.0") AND contributor_ip_int <= PARSE_IP("199.99.16.255")) # Goldman Sachs
OR (contributor_ip_int >= PARSE_IP("199.99.14.0") AND contributor_ip_int <= PARSE_IP("199.99.14.255")) # Goldman Sachs
OR (contributor_ip_int >= PARSE_IP("192.246.9.0") AND contributor_ip_int <= PARSE_IP("192.246.9.255")) # Goldman Sachs
OR (contributor_ip_int >= PARSE_IP("12.47.211.0") AND contributor_ip_int <= PARSE_IP("12.47.211.255")) # Goldman Sachs
OR (contributor_ip_int >= PARSE_IP("12.47.208.0") AND contributor_ip_int <= PARSE_IP("12.47.208.255")) # Goldman Sachs
OR (contributor_ip_int >= PARSE_IP("12.26.53.0") AND contributor_ip_int <= PARSE_IP("12.26.53.255")) # Goldman Sachs
OR (contributor_ip_int >= PARSE_IP("69.74.251.0") AND contributor_ip_int <= PARSE_IP("69.74.251.255")) # Goldman Sachs
OR (contributor_ip_int >= PARSE_IP("65.160.247.0") AND contributor_ip_int <= PARSE_IP("65.160.247.255")) # Goldman Sachs
OR (contributor_ip_int >= PARSE_IP("63.167.228.0") AND contributor_ip_int <= PARSE_IP("63.167.228.255")) # Goldman Sachs
OR (contributor_ip_int >= PARSE_IP("216.35.59.0") AND contributor_ip_int <= PARSE_IP("216.35.59.255")) # Goldman Sachs
OR (contributor_ip_int >= PARSE_IP("208.168.16.0") AND contributor_ip_int <= PARSE_IP("208.168.16.255")) # Goldman Sachs
OR (contributor_ip_int >= PARSE_IP("207.17.46.0") AND contributor_ip_int <= PARSE_IP("207.17.46.255")) # Goldman Sachs
OR (contributor_ip_int >= PARSE_IP("207.17.45.0") AND contributor_ip_int <= PARSE_IP("207.17.45.255")) # Goldman Sachs
OR (contributor_ip_int >= PARSE_IP("207.17.37.0") AND contributor_ip_int <= PARSE_IP("207.17.37.255")) # Goldman Sachs
OR (contributor_ip_int >= PARSE_IP("207.17.34.0") AND contributor_ip_int <= PARSE_IP("207.17.34.255")) # Goldman Sachs
OR (contributor_ip_int >= PARSE_IP("207.17.33.0") AND contributor_ip_int <= PARSE_IP("207.17.33.255")) # Goldman Sachs
OR (contributor_ip_int >= PARSE_IP("205.161.205.0") AND contributor_ip_int <= PARSE_IP("205.161.205.255")) # Goldman Sachs
OR (contributor_ip_int >= PARSE_IP("204.4.187.0") AND contributor_ip_int <= PARSE_IP("204.4.187.255")) # Goldman Sachs
OR (contributor_ip_int >= PARSE_IP("204.4.185.0") AND contributor_ip_int <= PARSE_IP("204.4.185.255")) # Goldman Sachs
OR (contributor_ip_int >= PARSE_IP("204.4.182.0") AND contributor_ip_int <= PARSE_IP("204.4.182.255")) # Goldman Sachs
OR (contributor_ip_int >= PARSE_IP("204.4.179.0") AND contributor_ip_int <= PARSE_IP("204.4.179.255")) # Goldman Sachs
OR (contributor_ip_int >= PARSE_IP("204.4.178.0") AND contributor_ip_int <= PARSE_IP("204.4.178.255")) # Goldman Sachs
OR (contributor_ip_int >= PARSE_IP("204.4.161.0") AND contributor_ip_int <= PARSE_IP("204.4.161.255")) # Goldman Sachs
OR (contributor_ip_int >= PARSE_IP("204.4.153.0") AND contributor_ip_int <= PARSE_IP("204.4.153.255")) # Goldman Sachs
OR (contributor_ip_int >= PARSE_IP("204.4.152.0") AND contributor_ip_int <= PARSE_IP("204.4.152.255")) # Goldman Sachs
OR (contributor_ip_int >= PARSE_IP("204.4.143.0") AND contributor_ip_int <= PARSE_IP("204.4.143.255")) # Goldman Sachs
OR (contributor_ip_int >= PARSE_IP("204.4.142.0") AND contributor_ip_int <= PARSE_IP("204.4.142.255")) # Goldman Sachs
OR (contributor_ip_int >= PARSE_IP("204.4.131.0") AND contributor_ip_int <= PARSE_IP("204.4.131.255")) # Goldman Sachs
OR (contributor_ip_int >= PARSE_IP("204.4.130.0") AND contributor_ip_int <= PARSE_IP("204.4.130.255")) # Goldman Sachs
OR (contributor_ip_int >= PARSE_IP("203.56.91.0") AND contributor_ip_int <= PARSE_IP("203.56.91.255")) # Goldman Sachs
OR (contributor_ip_int >= PARSE_IP("203.56.90.0") AND contributor_ip_int <= PARSE_IP("203.56.90.255")) # Goldman Sachs
OR (contributor_ip_int >= PARSE_IP("203.56.87.0") AND contributor_ip_int <= PARSE_IP("203.56.87.255")) # Goldman Sachs
OR (contributor_ip_int >= PARSE_IP("203.20.159.0") AND contributor_ip_int <= PARSE_IP("203.20.159.255")) # Goldman Sachs
OR (contributor_ip_int >= PARSE_IP("203.20.158.0") AND contributor_ip_int <= PARSE_IP("203.20.158.255")) # Goldman Sachs
OR (contributor_ip_int >= PARSE_IP("203.20.157.0") AND contributor_ip_int <= PARSE_IP("203.20.157.255")) # Goldman Sachs
OR (contributor_ip_int >= PARSE_IP("203.20.153.0") AND contributor_ip_int <= PARSE_IP("203.20.153.255")) # Goldman Sachs
)
ORDER BY timestamp DESC
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment