Skip to content

Instantly share code, notes, and snippets.

@vdubyna

vdubyna/count_bots_by_agent.sql

Last active August 11, 2016 08:58
Show Gist options

  • Select an option

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

Select an option

Learn more about clone URLs
Save vdubyna/9671853 to your computer and use it in GitHub Desktop.
Download ZIP
Count bots by user agent
Raw
count_bots_by_agent.sql
select count(*) as c, vi.http_user_agent 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' and vi.http_user_agent like('%bot%') GROUP BY vi.http_user_agent ;
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment