[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>