Skip to content

Instantly share code, notes, and snippets.

@quellhorst

quellhorst/gist:192939

Created September 24, 2009 18:33
Show Gist options
  • Save quellhorst/192939 to your computer and use it in GitHub Desktop.
Save quellhorst/192939 to your computer and use it in GitHub Desktop.
Download ZIP
Raw
gistfile1.sql
mysql: (citycliq_db@mysql50-6-master) [citycliq_production]> select * from page_views where ip_address = '75.85.10.222';
+---------+------------------+---------------------------------------------------------------------------+---------+--------------+------------------------------------------------------------------------------------+------------------------------------------------------------------------------------------+---------------------+
| id | host | request_url | session | ip_address | referer | user_agent | created_at |
+---------+------------------+---------------------------------------------------------------------------+---------+--------------+------------------------------------------------------------------------------------+------------------------------------------------------------------------------------------+---------------------+
| 2101436 | www.citycliq.com | / | NULL | 75.85.10.222 | NULL | Mozilla/5.0 (Windows; U; Windows NT 5.1; en-US; rv:1.9.1.3) Gecko/20090824 Firefox/3.5.3 | 2009-09-23 19:23:01 |
| 2102614 | www.citycliq.com | / | NULL | 75.85.10.222 | NULL | Mozilla/5.0 (Windows; U; Windows NT 5.1; en-US; rv:1.9.1.3) Gecko/20090824 Firefox/3.5.3 | 2009-09-23 20:43:49 |
| 2102624 | www.citycliq.com | /businesses/new | NULL | 75.85.10.222 | http://www.citycliq.com/ | Mozilla/5.0 (Windows; U; Windows NT 5.1; en-US; rv:1.9.1.3) Gecko/20090824 Firefox/3.5.3 | 2009-09-23 20:44:17 |
| 2102630 | www.citycliq.com | /businesses/check_subdomain | NULL | 75.85.10.222 | http://www.citycliq.com/businesses/new | Mozilla/5.0 (Windows; U; Windows NT 5.1; en-US; rv:1.9.1.3) Gecko/20090824 Firefox/3.5.3 | 2009-09-23 20:44:44 |
| 2102631 | www.citycliq.com | /businesses/check_subdomain | NULL | 75.85.10.222 | http://www.citycliq.com/businesses/new | Mozilla/5.0 (Windows; U; Windows NT 5.1; en-US; rv:1.9.1.3) Gecko/20090824 Firefox/3.5.3 | 2009-09-23 20:44:49 |
| 2102637 | www.citycliq.com | /businesses | NULL | 75.85.10.222 | http://www.citycliq.com/businesses/new | Mozilla/5.0 (Windows; U; Windows NT 5.1; en-US; rv:1.9.1.3) Gecko/20090824 Firefox/3.5.3 | 2009-09-23 20:46:18 |
| 2102638 | www.citycliq.com | /thank_you | NULL | 75.85.10.222 | http://www.citycliq.com/businesses/new | Mozilla/5.0 (Windows; U; Windows NT 5.1; en-US; rv:1.9.1.3) Gecko/20090824 Firefox/3.5.3 | 2009-09-23 20:46:24 |
| 2102639 | www.citycliq.com | /dashboard | NULL | 75.85.10.222 | NULL | Mozilla/5.0 (Windows; U; Windows NT 5.1; en-US; rv:1.9.1.3) Gecko/20090824 Firefox/3.5.3 | 2009-09-23 20:46:31 |
| 2102645 | www.citycliq.com | /businesses/newyorkfullycustomwebsitedesigncom?preview=true | NULL | 75.85.10.222 | http://www.citycliq.com/dashboard | Mozilla/5.0 (Windows; U; Windows NT 5.1; en-US; rv:1.9.1.3) Gecko/20090824 Firefox/3.5.3 | 2009-09-23 20:46:52 |
| 2102646 | www.citycliq.com | /logout | NULL | 75.85.10.222 | http://www.citycliq.com/businesses/newyorkfullycustomwebsitedesigncom?preview=true | Mozilla/5.0 (Windows; U; Windows NT 5.1; en-US; rv:1.9.1.3) Gecko/20090824 Firefox/3.5.3 | 2009-09-23 20:47:01 |
| 2102647 | www.citycliq.com | / | NULL | 75.85.10.222 | http://www.citycliq.com/businesses/newyorkfullycustomwebsitedesigncom?preview=true | Mozilla/5.0 (Windows; U; Windows NT 5.1; en-US; rv:1.9.1.3) Gecko/20090824 Firefox/3.5.3 | 2009-09-23 20:47:01 |
| 2103139 | www.citycliq.com | /businesses/new | NULL | 75.85.10.222 | http://www.citycliq.com/ | Mozilla/5.0 (Windows; U; Windows NT 5.1; en-US; rv:1.9.1.3) Gecko/20090824 Firefox/3.5.3 | 2009-09-23 21:29:44 |
| 2103152 | www.citycliq.com | /businesses | NULL | 75.85.10.222 | http://www.citycliq.com/businesses/new | Mozilla/5.0 (Windows; U; Windows NT 5.1; en-US; rv:1.9.1.3) Gecko/20090824 Firefox/3.5.3 | 2009-09-23 21:31:26 |
| 2103153 | www.citycliq.com | /thank_you | NULL | 75.85.10.222 | http://www.citycliq.com/businesses/new | Mozilla/5.0 (Windows; U; Windows NT 5.1; en-US; rv:1.9.1.3) Gecko/20090824 Firefox/3.5.3 | 2009-09-23 21:31:32 |
| 2103156 | www.citycliq.com | /dashboard | NULL | 75.85.10.222 | NULL | Mozilla/5.0 (Windows; U; Windows NT 5.1; en-US; rv:1.9.1.3) Gecko/20090824 Firefox/3.5.3 | 2009-09-23 21:31:38 |
| 2103157 | www.citycliq.com | /businesses/aandatowing?preview=true | NULL | 75.85.10.222 | http://www.citycliq.com/dashboard | Mozilla/5.0 (Windows; U; Windows NT 5.1; en-US; rv:1.9.1.3) Gecko/20090824 Firefox/3.5.3 | 2009-09-23 21:31:44 |
| 2103159 | www.citycliq.com | /logout | NULL | 75.85.10.222 | http://www.citycliq.com/businesses/aandatowing?preview=true | Mozilla/5.0 (Windows; U; Windows NT 5.1; en-US; rv:1.9.1.3) Gecko/20090824 Firefox/3.5.3 | 2009-09-23 21:32:01 |
| 2103160 | www.citycliq.com | / | NULL | 75.85.10.222 | http://www.citycliq.com/businesses/aandatowing?preview=true | Mozilla/5.0 (Windows; U; Windows NT 5.1; en-US; rv:1.9.1.3) Gecko/20090824 Firefox/3.5.3 | 2009-09-23 21:32:01 |
| 2103163 | www.citycliq.com | /businesses/new | NULL | 75.85.10.222 | http://www.citycliq.com/ | Mozilla/5.0 (Windows; U; Windows NT 5.1; en-US; rv:1.9.1.3) Gecko/20090824 Firefox/3.5.3 | 2009-09-23 21:32:55 |
| 2103171 | www.citycliq.com | /businesses | NULL | 75.85.10.222 | http://www.citycliq.com/businesses/new | Mozilla/5.0 (Windows; U; Windows NT 5.1; en-US; rv:1.9.1.3) Gecko/20090824 Firefox/3.5.3 | 2009-09-23 21:34:29 |
| 2103176 | www.citycliq.com | /businesses | NULL | 75.85.10.222 | http://www.citycliq.com/businesses | Mozilla/5.0 (Windows; U; Windows NT 5.1; en-US; rv:1.9.1.3) Gecko/20090824 Firefox/3.5.3 | 2009-09-23 21:35:09 |
| 2103177 | www.citycliq.com | /thank_you | NULL | 75.85.10.222 | http://www.citycliq.com/businesses | Mozilla/5.0 (Windows; U; Windows NT 5.1; en-US; rv:1.9.1.3) Gecko/20090824 Firefox/3.5.3 | 2009-09-23 21:35:15 |
| 2103180 | www.citycliq.com | /dashboard | NULL | 75.85.10.222 | NULL | Mozilla/5.0 (Windows; U; Windows NT 5.1; en-US; rv:1.9.1.3) Gecko/20090824 Firefox/3.5.3 | 2009-09-23 21:35:22 |
| 2103187 | www.citycliq.com | /logout | NULL | 75.85.10.222 | http://www.citycliq.com/dashboard | Mozilla/5.0 (Windows; U; Windows NT 5.1; en-US; rv:1.9.1.3) Gecko/20090824 Firefox/3.5.3 | 2009-09-23 21:35:47 |
| 2103188 | www.citycliq.com | / | NULL | 75.85.10.222 | http://www.citycliq.com/dashboard | Mozilla/5.0 (Windows; U; Windows NT 5.1; en-US; rv:1.9.1.3) Gecko/20090824 Firefox/3.5.3 | 2009-09-23 21:35:47 |
| 2103189 | www.citycliq.com | /businesses/new | NULL | 75.85.10.222 | http://www.citycliq.com/ | Mozilla/5.0 (Windows; U; Windows NT 5.1; en-US; rv:1.9.1.3) Gecko/20090824 Firefox/3.5.3 | 2009-09-23 21:35:50 |
| 2103209 | www.citycliq.com | /businesses | NULL | 75.85.10.222 | http://www.citycliq.com/businesses/new | Mozilla/5.0 (Windows; U; Windows NT 5.1; en-US; rv:1.9.1.3) Gecko/20090824 Firefox/3.5.3 | 2009-09-23 21:36:59 |
| 2103218 | www.citycliq.com | /businesses | NULL | 75.85.10.222 | http://www.citycliq.com/businesses | Mozilla/5.0 (Windows; U; Windows NT 5.1; en-US; rv:1.9.1.3) Gecko/20090824 Firefox/3.5.3 | 2009-09-23 21:37:24 |
| 2103220 | www.citycliq.com | /thank_you | NULL | 75.85.10.222 | http://www.citycliq.com/businesses | Mozilla/5.0 (Windows; U; Windows NT 5.1; en-US; rv:1.9.1.3) Gecko/20090824 Firefox/3.5.3 | 2009-09-23 21:37:29 |
| 2103222 | www.citycliq.com | /dashboard | NULL | 75.85.10.222 | NULL | Mozilla/5.0 (Windows; U; Windows NT 5.1; en-US; rv:1.9.1.3) Gecko/20090824 Firefox/3.5.3 | 2009-09-23 21:37:35 |
| 2103224 | www.citycliq.com | /logout | NULL | 75.85.10.222 | http://www.citycliq.com/dashboard | Mozilla/5.0 (Windows; U; Windows NT 5.1; en-US; rv:1.9.1.3) Gecko/20090824 Firefox/3.5.3 | 2009-09-23 21:37:39 |
| 2103225 | www.citycliq.com | / | NULL | 75.85.10.222 | http://www.citycliq.com/dashboard | Mozilla/5.0 (Windows; U; Windows NT 5.1; en-US; rv:1.9.1.3) Gecko/20090824 Firefox/3.5.3 | 2009-09-23 21:37:39 |
| 2103229 | www.citycliq.com | /businesses/new | NULL | 75.85.10.222 | http://www.citycliq.com/ | Mozilla/5.0 (Windows; U; Windows NT 5.1; en-US; rv:1.9.1.3) Gecko/20090824 Firefox/3.5.3 | 2009-09-23 21:37:52 |
| 2103254 | www.citycliq.com | /businesses | NULL | 75.85.10.222 | http://www.citycliq.com/businesses/new | Mozilla/5.0 (Windows; U; Windows NT 5.1; en-US; rv:1.9.1.3) Gecko/20090824 Firefox/3.5.3 | 2009-09-23 21:39:03 |
| 2103257 | www.citycliq.com | /thank_you | NULL | 75.85.10.222 | http://www.citycliq.com/businesses/new | Mozilla/5.0 (Windows; U; Windows NT 5.1; en-US; rv:1.9.1.3) Gecko/20090824 Firefox/3.5.3 | 2009-09-23 21:39:07 |
| 2103260 | www.citycliq.com | /dashboard | NULL | 75.85.10.222 | NULL | Mozilla/5.0 (Windows; U; Windows NT 5.1; en-US; rv:1.9.1.3) Gecko/20090824 Firefox/3.5.3 | 2009-09
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment