gistfile1.txt

select * from reporting_hourly limit 5;
+----+-------+-------------+------------+----------+------------+-------------+---------+---------------------+-----+---------+---------------------+-------------+----------+--------+---------------------+----------+-------------+--------+-------+-------------+
| id | count | campaign_id | event_type | movie_id | paysite_id | tubesite_id | browser | time                | asn | zone_id | count_thirdparty_id | views_count | external | repeat | visit_view_time     | price    | language_id | geo_id | os_id | platform_id |
+----+-------+-------------+------------+----------+------------+-------------+---------+---------------------+-----+---------+---------------------+-------------+----------+--------+---------------------+----------+-------------+--------+-------+-------------+
|  1 |     1 |           0 |          3 |        0 |          0 |           2 | Firefox | 2015-04-21 09:00:00 |   0 |       3 |                   1 |           0 |        0 |      0 | 0000-00-00 00:00:00 | 0.000000 |          73 |      2 |     4 |           2 |
|  2 |     1 |           3 |          3 |        5 |          0 |           2 | Firefox | 2015-04-21 09:00:00 |   0 |       3 |                   1 |           0 |        0 |      0 | 0000-00-00 00:00:00 | 0.000000 |          73 |      2 |     4 |           2 |
|  3 |     1 |           0 |          3 |        0 |          0 |           1 | Firefox | 2015-04-21 09:00:00 |   0 |       4 |                   1 |           0 |        0 |      0 | 0000-00-00 00:00:00 | 0.000000 |          73 |      2 |     4 |           2 |
|  4 |     1 |           3 |          3 |        4 |          0 |           1 | Firefox | 2015-04-21 09:00:00 |   0 |       4 |                   1 |           0 |        0 |      0 | 0000-00-00 00:00:00 | 0.000000 |          73 |      2 |     4 |           2 |
|  5 |     1 |           3 |          3 |        5 |          0 |           1 | Firefox | 2015-04-21 09:00:00 |   0 |       4 |                   1 |           0 |        0 |      0 | 0000-00-00 00:00:00 | 0.000000 |          73 |      2 |     4 |           2 |
+----+-------+-------------+------------+----------+------------+-------------+---------+---------------------+-----+---------+---------------------+-------------+----------+--------+---------------------+----------+-------------+--------+-------+-------------+