softwareheritage=> SELECT DISTINCT ON (ov.visit) ov.visit, ov.type, ov.date, ovs.date as status_date, ovs.status FROM origin_visit ov INNER JOIN origin o ON o.id = ov.origin INNER JOIN origin_visit_status ovs USING (origin, visit) WHERE o.url = 'https://github.com/python/cpython' ORDER BY ov.visit ASC, ovs.date DESC; visit | type | date | last_status_date | last_status -------+------+-------------------------------+-------------------------------+------------- 1 | git | 2015-08-09 01:50:27.739002+00 | 2015-08-09 01:50:27.739002+00 | full 2 | git | 2016-03-15 17:22:43.546268+00 | 2016-03-15 17:22:43.546268+00 | full 3 | git | 2016-03-27 18:46:40.816045+00 | 2016-03-27 18:46:40.816045+00 | full 4 | git | 2016-04-04 09:46:06.594034+00 | 2016-04-04 09:46:06.594034+00 | full 5 | git | 2016-06-01 05:37:35.428762+00 | 2016-06-01 05:37:35.428762+00 | full 6 | git | 2016-06-16 09:49:09.802569+00 | 2016-06-16 09:49:09.802569+00 | full 7 | git | 2016-08-13 20:00:28.724135+00 | 2016-08-13 20:00:28.724135+00 | full 8 | git | 2016-08-17 04:54:28.578226+00 | 2016-08-17 04:54:28.578226+00 | full 9 | git | 2016-08-29 16:34:18.686581+00 | 2016-08-29 16:34:18.686581+00 | full 10 | git | 2016-09-07 06:26:03.673207+00 | 2016-09-07 06:26:03.673207+00 | full 11 | git | 2016-09-14 08:41:36.564949+00 | 2016-09-14 08:41:36.564949+00 | full 12 | git | 2016-09-23 08:50:51.526694+00 | 2016-09-23 08:50:51.526694+00 | full 13 | git | 2017-02-16 07:59:08.276504+00 | 2017-02-16 07:59:08.276504+00 | partial 14 | git | 2017-05-05 06:22:05.182498+00 | 2017-05-05 06:22:05.182498+00 | full 15 | git | 2018-03-03 14:56:52.264666+00 | 2018-03-03 14:56:52.264666+00 | partial 16 | git | 2018-06-05 15:23:48.247372+00 | 2018-06-05 15:23:48.247372+00 | partial 17 | git | 2018-06-29 00:36:23.333685+00 | 2018-06-29 00:36:23.333685+00 | partial 18 | git | 2018-07-06 04:48:03.262723+00 | 2018-07-06 04:48:03.262723+00 | partial 19 | git | 2018-07-11 00:15:18.379304+00 | 2018-07-11 00:15:18.379304+00 | partial 20 | git | 2018-07-11 23:29:54.057517+00 | 2018-07-11 23:29:54.057517+00 | partial 21 | git | 2018-07-13 01:42:11.111385+00 | 2018-07-13 01:42:11.111385+00 | partial 22 | git | 2018-07-13 17:47:20.369667+00 | 2018-07-13 17:47:20.369667+00 | partial 23 | git | 2018-07-14 03:07:41.08928+00 | 2018-07-14 03:07:41.08928+00 | partial 24 | git | 2018-07-14 15:07:59.328917+00 | 2018-07-14 15:07:59.328917+00 | partial 25 | git | 2018-07-15 09:57:07.004397+00 | 2018-07-15 09:57:07.004397+00 | partial 26 | git | 2018-07-15 18:07:47.241913+00 | 2018-07-15 18:07:47.241913+00 | partial 27 | git | 2018-07-17 05:25:27.236151+00 | 2018-07-17 05:25:27.236151+00 | partial 28 | git | 2018-07-18 10:55:12.645412+00 | 2018-07-18 10:55:12.645412+00 | partial 29 | git | 2018-07-19 03:50:21.165414+00 | 2018-07-19 03:50:21.165414+00 | partial 30 | git | 2018-07-19 18:50:42.348047+00 | 2018-07-19 18:50:42.348047+00 | partial 31 | git | 2018-07-20 13:38:59.9417+00 | 2018-07-20 13:38:59.9417+00 | partial 32 | git | 2018-07-28 10:57:30.235203+00 | 2018-07-28 10:57:30.235203+00 | partial 33 | git | 2018-08-29 19:48:17.276148+00 | 2018-08-29 19:48:17.276148+00 | partial 34 | git | 2018-08-30 17:31:59.471929+00 | 2018-08-30 17:31:59.471929+00 | partial 35 | git | 2018-08-31 04:59:46.840014+00 | 2018-08-31 04:59:46.840014+00 | partial 36 | git | 2018-09-01 21:14:55.38103+00 | 2018-09-01 21:14:55.38103+00 | partial 37 | git | 2018-09-02 10:35:37.644481+00 | 2018-09-02 10:35:37.644481+00 | partial 38 | git | 2018-09-02 23:04:49.192911+00 | 2018-09-02 23:04:49.192911+00 | partial 39 | git | 2018-09-03 15:06:38.546511+00 | 2018-09-03 15:06:38.546511+00 | partial 40 | git | 2018-09-04 12:23:40.650738+00 | 2018-09-04 12:23:40.650738+00 | partial 41 | git | 2018-09-06 02:19:17.356141+00 | 2018-09-06 02:19:17.356141+00 | partial 42 | git | 2018-09-06 10:10:08.899682+00 | 2018-09-06 10:10:08.899682+00 | partial 43 | git | 2018-09-06 21:11:07.165577+00 | 2018-09-06 21:11:07.165577+00 | partial 44 | git | 2018-09-08 03:31:34.120029+00 | 2018-09-08 03:31:34.120029+00 | partial 45 | git | 2018-09-10 13:16:18.957123+00 | 2018-09-10 13:16:18.957123+00 | partial 46 | git | 2018-09-11 12:02:16.17506+00 | 2018-09-11 12:02:16.17506+00 | partial 47 | git | 2018-09-16 16:54:42.910339+00 | 2018-09-16 16:54:42.910339+00 | partial 48 | git | 2018-09-17 12:23:51.366085+00 | 2018-09-17 12:23:51.366085+00 | partial 49 | git | 2018-09-18 04:47:14.854145+00 | 2018-09-18 04:47:14.854145+00 | partial 50 | git | 2018-09-19 00:12:34.633115+00 | 2018-09-19 00:12:34.633115+00 | partial 51 | git | 2018-09-20 02:33:52.76492+00 | 2018-09-20 02:33:52.76492+00 | partial 52 | git | 2018-09-20 20:15:56.698628+00 | 2018-09-20 20:15:56.698628+00 | full 53 | git | 2018-09-20 22:33:15.127139+00 | 2018-09-20 22:33:15.127139+00 | full 54 | git | 2018-09-21 20:54:47.156741+00 | 2018-09-21 20:54:47.156741+00 | partial 55 | git | 2018-09-23 11:50:31.266525+00 | 2018-09-23 11:50:31.266525+00 | full 56 | git | 2018-09-24 20:03:32.886445+00 | 2018-09-24 20:03:32.886445+00 | full 57 | git | 2018-09-25 02:58:03.443585+00 | 2018-09-25 02:58:03.443585+00 | full 58 | git | 2018-09-27 06:19:53.978236+00 | 2018-09-27 06:19:53.978236+00 | full 59 | git | 2018-09-28 17:11:37.081062+00 | 2018-09-28 17:11:37.081062+00 | partial 60 | git | 2018-09-29 21:57:24.418869+00 | 2018-09-29 21:57:24.418869+00 | full 61 | git | 2018-10-01 02:34:10.901134+00 | 2018-10-01 02:34:10.901134+00 | full 62 | git | 2018-10-01 05:43:27.134214+00 | 2018-10-01 05:43:27.134214+00 | full 63 | git | 2018-10-05 15:48:04.298225+00 | 2018-10-05 15:48:04.298225+00 | full 64 | git | 2018-10-08 12:47:47.275795+00 | 2018-10-08 12:47:47.275795+00 | full 65 | git | 2018-10-09 10:34:11.824382+00 | 2018-10-09 10:34:11.824382+00 | full 66 | git | 2018-10-09 20:48:50.328618+00 | 2018-10-09 20:48:50.328618+00 | full 67 | git | 2018-10-10 08:59:00.671019+00 | 2018-10-10 08:59:00.671019+00 | full 68 | git | 2018-10-11 23:58:43.850242+00 | 2018-10-11 23:58:43.850242+00 | full 69 | git | 2018-10-13 17:19:04.995245+00 | 2018-10-13 17:19:04.995245+00 | full