gistfile1.txt

+-----------+-------------+---------------------+
| ticket_id | external_id | created             |
+-----------+-------------+---------------------+
|      6177 | 1           | 2010-08-17 15:37:41 |
|      6178 | 1           | 2010-08-17 15:44:01 |
|      5763 | 1000055959  | 2010-06-18 10:36:17 |
|      4988 | 1000055961  | 2010-02-12 13:19:35 |
|      4983 | 1000055963  | 2010-02-12 12:13:47 |
|      4299 | 1000055967  | 2009-10-16 13:41:48 |
|      5803 | 0           | 2010-06-18 12:35:24 |
|      6375 | 1           | 2010-09-24 10:14:13 |
|      4316 | 1000067979  | 2009-10-16 16:24:35 |
|      5789 | 1000067976  | 2010-06-18 12:26:13 |
|      4307 | 1000067984  | 2009-10-16 14:09:22 |
|      4310 | 1000067983  | 2009-10-16 14:09:23 |
|      5119 | 0           | 2010-03-05 11:22:45 |
|      6404 | 0           | 2010-09-30 10:23:22 |
|      6430 | 1000071824  | 2010-10-04 18:05:44 |
|      6491 | 1           | 2010-10-15 18:03:00 |
|      6508 | 1           | 2010-10-22 11:18:38 |
|      6595 | 1           | 2010-11-05 18:31:47 |
|      6597 | 1           | 2010-11-05 18:44:30 |
|      6680 | 1           | 2010-11-12 17:15:53 |
|      6714 | 1           | 2010-11-19 16:40:03 |
|      6848 | 0           | 2010-12-21 09:06:16 |
|      6847 | 0           | 2010-12-21 09:06:07 |
|      6687 | 0           | 2010-11-15 14:06:25 |
|      6632 | 0           | 2010-11-12 13:26:04 |
|      6631 | 0           | 2010-11-12 13:23:36 |
|      6590 | 0           | 2010-11-05 17:22:40 |
|      6285 | 0           | 2010-09-10 12:36:07 |
|      5895 | 0           | 2010-07-07 13:05:46 |
|      5800 | 0           | 2010-06-18 12:34:00 |
|      5776 | 0           | 2010-06-18 11:55:40 |
|      5760 | 0           | 2010-06-18 10:29:29 |
|      5752 | 0           | 2010-06-16 12:35:20 |
|      6870 | 0           | 2011-01-03 11:26:59 |
|      5636 | 0           | 2010-06-03 13:52:34 |
|      5623 | 0           | 2010-05-27 10:35:33 |
|      5622 | 0           | 2010-05-27 10:30:51 |
|      6996 | 0           | 2011-02-04 11:43:38 |
|      7090 | 0           | 2011-02-18 10:59:03 |
|      7108 | 0           | 2011-02-18 14:10:42 |
|      5033 | 0           | 2010-02-18 13:52:29 |
|      5034 | 0           | 2010-02-18 13:52:30 |
|      5035 | 0           | 2010-02-18 13:52:30 |
|      7177 | 0           | 2011-03-04 10:40:20 |
|      7224 | 0           | 2011-03-11 12:32:05 |
|      7352 | 0           | 2011-04-11 12:57:37 |
|      7353 | 0           | 2011-04-11 13:31:52 |
|      7357 | 0           | 2011-04-11 16:28:13 |
|      7369 | 0           | 2011-04-14 16:09:39 |
|      7370 | 0           | 2011-04-15 09:46:14 |
|      7361 | 0           | 2011-04-13 15:26:48 |
+-----------+-------------+---------------------+