Skip to content

Instantly share code, notes, and snippets.

@till

till/php-bigquery.sql

Created December 31, 2014 03:01
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 till/0c9b5d1fe89616cfebea to your computer and use it in GitHub Desktop.
Save till/0c9b5d1fe89616cfebea to your computer and use it in GitHub Desktop.
Download ZIP
Raw
php-bigquery.sql
SELECT
req.urlShort,
req.resp_x_powered_by,
req.resp_server
FROM [httparchive:runs.latest_requests] AS req
WHERE (
REGEXP_MATCH(req.resp_server, r'PHP')
OR
REGEXP_MATCH(req.resp_x_powered_by, r'PHP')
)
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment