Skip to content

Instantly share code, notes, and snippets.

@Ironholds

Ironholds/gaah

Created September 30, 2014 18:11
Show Gist options

  • Select an option

    Learn more about clone URLs
  • Save Ironholds/caf326d56288fb725ae1 to your computer and use it in GitHub Desktop.

Select an option

Learn more about clone URLs
Save Ironholds/caf326d56288fb725ae1 to your computer and use it in GitHub Desktop.
Download ZIP
Raw
gaah
SELECT parse_url(concat('http://bla.org/',uri_path), 'FILE')
FROM wmf_raw.webrequest
WHERE year = 2014 AND month = 09 AND day = 23 AND
hour = 07 AND webrequest_source='upload' LIMIT 5;
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment