Skip to content

Instantly share code, notes, and snippets.

@janoliver

janoliver/gist:7b994b142cd32fe84bcf12369e7e7d0a

Created March 30, 2020 15:30
Show Gist options
  • Star 0 You must be signed in to star a gist
  • Fork 0 You must be signed in to fork a gist
  • Save janoliver/7b994b142cd32fe84bcf12369e7e7d0a to your computer and use it in GitHub Desktop.
Save janoliver/7b994b142cd32fe84bcf12369e7e7d0a to your computer and use it in GitHub Desktop.
Download ZIP
Raw
gistfile1.txt
SELECT
tid, bid
FROM
posts
WHERE
time IN (
DATETIME('2009-10-25 02:24:47'),
DATETIME('2007-10-28 02:09:55'),
DATETIME('2007-10-28 02:32:01'),
DATETIME('2006-10-29 02:25:44'),
DATETIME('2006-10-29 02:44:50'),
DATETIME('2008-10-26 02:00:02'),
DATETIME('2008-10-26 02:14:21'),
DATETIME('2008-10-26 02:01:38'),
DATETIME('2008-10-26 02:02:07'),
DATETIME('2008-10-26 02:24:20'),
DATETIME('2008-10-26 02:00:20'),
DATETIME('2008-10-26 02:00:39'),
DATETIME('2008-10-26 02:37:32'),
DATETIME('2008-10-26 02:49:34'),
DATETIME('2008-10-26 02:43:08'),
DATETIME('2008-10-26 02:03:30'),
DATETIME('2008-10-26 02:08:58'),
DATETIME('2008-10-26 02:03:42'),
DATETIME('2009-10-25 02:13:01'),
DATETIME('2009-10-25 02:01:34'),
DATETIME('2009-10-25 02:37:09'),
DATETIME('2009-10-25 02:00:15'),
DATETIME('2009-10-25 02:07:29'),
DATETIME('2009-10-25 02:04:25'),
DATETIME('2009-10-25 02:09:37'),
DATETIME('2009-10-25 02:00:27'),
DATETIME('2009-10-25 02:50:31'),
DATETIME('2009-10-25 02:03:45'),
DATETIME('2009-10-25 02:42:09'),
DATETIME('2009-10-25 02:01:53'),
DATETIME('2009-10-25 02:36:45'),
DATETIME('2009-10-25 02:02:28'),
DATETIME('2009-10-25 02:26:22'),
DATETIME('2009-10-25 02:09:01'),
DATETIME('2007-10-28 02:36:00'),
DATETIME('2010-10-31 02:56:02'),
DATETIME('2010-10-31 02:00:52'),
DATETIME('2010-10-31 02:31:58'),
DATETIME('2010-10-31 02:03:10'),
DATETIME('2010-10-31 02:28:33'),
DATETIME('2010-10-31 02:44:25'),
DATETIME('2010-10-31 02:29:10'),
DATETIME('2010-10-31 02:06:02'),
DATETIME('2010-10-31 02:06:38'),
DATETIME('2010-10-31 02:06:52'),
DATETIME('2010-10-31 02:15:52'),
DATETIME('2010-10-31 02:22:57'),
DATETIME('2010-10-31 02:23:51'),
DATETIME('2007-10-28 02:29:17'),
DATETIME('2011-10-30 02:13:49'),
DATETIME('2011-10-30 02:01:37'),
DATETIME('2011-10-30 02:06:19'),
DATETIME('2011-10-30 02:08:30'),
DATETIME('2011-10-30 02:00:46'),
DATETIME('2011-10-30 02:07:59'),
DATETIME('2011-10-30 02:24:03'),
DATETIME('2011-10-30 02:19:46'),
DATETIME('2011-10-30 02:13:51'),
DATETIME('2011-10-30 02:13:27'),
DATETIME('2011-10-30 02:15:59'),
DATETIME('2006-10-29 02:49:56'),
DATETIME('2011-10-30 02:18:34'),
DATETIME('2009-10-25 02:10:25'),
DATETIME('2012-10-28 02:08:47'),
DATETIME('2012-10-28 02:02:05'),
DATETIME('2012-10-28 02:02:47'),
DATETIME('2012-10-28 02:27:44'),
DATETIME('2012-10-28 02:11:57'),
DATETIME('2012-10-28 02:22:39'),
DATETIME('2012-10-28 02:04:41'),
DATETIME('2012-10-28 02:21:43'),
DATETIME('2012-10-28 02:46:43'),
DATETIME('2012-10-28 02:08:25'),
DATETIME('2012-10-28 02:32:41'),
DATETIME('2012-10-28 02:19:39'),
DATETIME('2012-10-28 02:04:03'),
DATETIME('2012-10-28 02:59:31'),
DATETIME('2012-10-28 02:55:38'),
DATETIME('2012-10-28 02:20:06'),
DATETIME('2012-10-28 02:58:54'),
DATETIME('2013-10-27 02:19:16'),
DATETIME('2013-10-27 02:21:34'),
DATETIME('2013-10-27 02:32:13'),
DATETIME('2013-10-27 02:00:32'),
DATETIME('2013-10-27 02:15:28'),
DATETIME('2013-10-27 02:06:07'),
DATETIME('2013-10-27 02:45:51'),
DATETIME('2013-10-27 02:01:02'),
DATETIME('2013-10-27 02:22:04'),
DATETIME('2013-10-27 02:00:07'),
DATETIME('2009-10-25 02:20:16'),
DATETIME('2013-10-27 02:00:35'),
DATETIME('2013-10-27 02:08:29'),
DATETIME('2014-10-26 02:19:44'),
DATETIME('2014-10-26 02:10:38'),
DATETIME('2014-10-26 02:39:19'),
DATETIME('2014-10-26 02:03:23'),
DATETIME('2014-10-26 02:13:00'),
DATETIME('2013-10-27 02:07:17'),
DATETIME('2014-10-26 02:06:53'),
DATETIME('2014-10-26 02:26:36'),
DATETIME('2014-10-26 02:01:10'),
DATETIME('2014-10-26 02:07:42'),
DATETIME('2014-10-26 02:02:02'),
DATETIME('2014-10-26 02:18:32'),
DATETIME('2015-10-25 02:59:57'),
DATETIME('2015-10-25 02:44:07'),
DATETIME('2015-10-25 02:05:02'),
DATETIME('2015-10-25 02:11:55'),
DATETIME('2010-10-31 02:08:26'),
DATETIME('2015-10-25 02:00:02'),
DATETIME('2015-10-25 02:39:18'),
DATETIME('2015-10-25 02:22:22'),
DATETIME('2015-10-25 02:38:05'),
DATETIME('2015-10-25 02:55:05'),
DATETIME('2015-10-25 02:11:33'),
DATETIME('2015-10-25 02:34:23'),
DATETIME('2016-10-30 02:02:15'),
DATETIME('2016-10-30 02:20:26'),
DATETIME('2016-10-30 02:56:41'),
DATETIME('2016-10-30 02:15:45'),
DATETIME('2016-10-30 02:54:04'),
DATETIME('2016-10-30 02:55:05'),
DATETIME('2016-10-30 02:14:53'),
DATETIME('2016-10-30 02:13:57'),
DATETIME('2015-10-25 02:23:03'),
DATETIME('2016-10-30 02:16:52'),
DATETIME('2017-10-29 02:06:57'),
DATETIME('2017-10-29 02:13:19'),
DATETIME('2017-10-29 02:14:24'),
DATETIME('2017-10-29 02:02:26'),
DATETIME('2017-10-29 02:09:57'),
DATETIME('2017-10-29 02:52:58'),
DATETIME('2017-10-29 02:15:37'),
DATETIME('2009-10-25 02:26:12'),
DATETIME('2016-10-30 02:09:00'),
DATETIME('2016-10-30 02:29:42'),
DATETIME('2017-10-29 02:00:04'),
DATETIME('2017-10-29 02:44:02'),
DATETIME('2018-10-28 02:04:35'),
DATETIME('2018-10-28 02:01:22'),
DATETIME('2018-10-28 02:05:17'),
DATETIME('2018-10-28 02:46:39'),
DATETIME('2015-10-25 02:18:06'),
DATETIME('2016-10-30 02:32:28'),
DATETIME('2019-10-27 02:07:21'),
DATETIME('2011-10-30 02:51:45'),
DATETIME('2019-10-27 02:07:15'),
DATETIME('2011-10-30 02:07:05'),
DATETIME('2016-10-30 02:06:32'),
DATETIME('2016-10-30 02:35:12'),
DATETIME('2017-10-29 02:21:45'),
DATETIME('2016-10-30 02:08:07'),
DATETIME('2010-10-31 02:08:13'),
DATETIME('2014-10-26 02:39:32'),
DATETIME('2014-10-26 02:35:56'),
DATETIME('2017-10-29 02:12:23'),
DATETIME('2019-10-27 02:14:10'),
DATETIME('2016-10-30 02:11:50'),
DATETIME('2019-10-27 02:40:11'),
DATETIME('2005-10-30 02:15:46'),
DATETIME('2008-10-26 02:43:15'),
DATETIME('2011-10-30 02:00:11'),
DATETIME('2010-10-31 02:17:03'),
DATETIME('2007-10-28 02:33:49')
);
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment