Created by
mason.malone
| [masonm@officebackup ~]$ sudo mysql identity_production
[sudo] password for masonm:
Reading table information for completion of table and column names
You can turn off this feature to get a quicker startup with -A
Welcome to the MySQL monitor. Commands end with ; or \g.
Your MySQL connection id is 48128
Server version: 5.6.31-log MySQL Community Server (GPL)
Copyright (c) 2000, 2016, Oracle and/or its affiliates. All rights reserved.
Oracle is a registered trademark of Oracle Corporation and/or its
affiliates. Other names may be trademarks of their respective
owners.
Type 'help;' or '\h' for help. Type '\c' to clear the current input statement.
mysql> select * from urls where url like '%subscribers/new%';
+----------+--------------------------------------------------------+----------+---------------------+---------------------+-------------+---------------------+---------+
| id | url | external | first_access | last_access | last_status | scope_expression_id | host_id |
+----------+--------------------------------------------------------+----------+---------------------+---------------------+-------------+---------------------+---------+
| 9918610 | /subscribers/new | 0 | 2016-01-13 10:21:51 | 2016-02-29 16:14:51 | 302 | 0 | 42555 |
| 9975996 | /subscribers/new | 0 | 2016-01-20 16:20:57 | 2016-07-12 01:12:59 | 302 | 0 | 19099 |
| 9996246 | /subscribers/new' | 0 | 2016-01-23 14:22:18 | 2016-07-10 12:02:08 | 404 | NULL | 19099 |
| 11071893 | /https:/notices.jci.org/subscribers/new | 0 | 2016-04-27 15:41:54 | 2016-05-27 06:36:55 | 404 | NULL | 35885 |
| 11468282 | /https://notices.jci.org/subscribers/new | 0 | 2016-06-06 12:27:13 | 2016-06-08 14:29:27 | 404 | NULL | 35885 |
| 11468306 | /https://notices.jci.org/subscribers/new | 0 | 2016-06-06 12:21:05 | 2016-06-08 14:11:13 | 404 | NULL | 174940 |
| 11693510 | /kiosks/action=https://notices.jci.org/subscribers/new | 0 | 2016-07-05 05:54:30 | 2016-07-05 05:54:30 | 302 | 0 | 35885 |
| 11695095 | notices.jci.org/subscribers/new | 1 | 2016-07-05 05:54:30 | 2016-07-05 05:54:31 | 302 | 0 | 35885 |
+----------+--------------------------------------------------------+----------+---------------------+---------------------+-------------+---------------------+---------+
8 rows in set (48.94 sec)
mysql> select * from hosts where id = 19099;
+-------+-----------------+-----------+
| id | host | domain_id |
+-------+-----------------+-----------+
| 19099 | notices.jci.org | 4 |
+-------+-----------------+-----------+
1 row in set (0.02 sec)
mysql> select count(*) from tracks where created_at > '2016-01-01' and request_url_id = 9975996
-> ;
+----------+
| count(*) |
+----------+
| 2002 |
+----------+
1 row in set (10.15 sec)
mysql>
|