Skip to content

Instantly share code, notes, and snippets.

@vdubyna

vdubyna/most-viewed-urls.sql

Created March 20, 2014 19:23
Show Gist options

  • Select an option

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

Select an option

Learn more about clone URLs
Save vdubyna/9671781 to your computer and use it in GitHub Desktop.
Download ZIP
Raw
most-viewed-urls.sql
select count(*) as c, ui.url from log_url_info as ui JOIN log_url as lu on lu.url_id=ui.url_id JOIN log_visitor_info as vi on lu.visitor_id=vi.visitor_id where date(lu.visit_time) = '2014-03-19' GROUP BY ui.url having c > 100;
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment