SELECT '2012-02-01' as date, COUNT(DISTINCT(Posts.OwnerUs...

0

Please login or register to vote for this query.

(click on this box to dismiss)

Christianity

Q&A for committed Christians, experts in Christianity and those interested in learning more

SELECT '2012-02-01' as date, COUNT(DISTINCT(Posts.OwnerUserId)) FROM Posts LEFT JOIN Votes on Votes.PostId = Posts.Id LEFT JOIN PostTags on PostTags.PostId = Posts.Id LEFT JOIN Tags ON Tags.Id = PostTags.TagId WHERE Tags.TagName IN (  'slack', 'slack-api', 'slack-commands','slack-block-kit',  'slack-dialog')  AND CASE WHEN Votes.CreationDate IS NOT NULL THEN CONCAT(YEAR(Votes.CreationDate), '-', RIGHT('0' + CONVERT(varchar(10), MONTH(Votes.CreationDate)), 2) , '-01') ELSE CONCAT(YEAR(Posts.CreationDate), '-', RIGHT('0' + CONVERT(varchar(10), MONTH(Posts.CreationDate)), 2) , '-01') END  >= '2008-10-01' AND CASE WHEN Votes.CreationDate IS NOT NULL THEN CONCAT(YEAR(Votes.CreationDate), '-', RIGHT('0' + CONVERT(varchar(10), MONTH(Votes.CreationDate)), 2) , '-01')  ELSE CONCAT(YEAR(Posts.CreationDate), '-', RIGHT('0' + CONVERT(varchar(10), MONTH(Posts.CreationDate)), 2) , '-01') END  < '2012-02-01' UNION
SELECT '2012-03-01' as date, COUNT(DISTINCT(Posts.OwnerUserId)) FROM Posts LEFT JOIN Votes on Votes.PostId = Posts.Id LEFT JOIN PostTags on PostTags.PostId = Posts.Id LEFT JOIN Tags ON Tags.Id = PostTags.TagId WHERE Tags.TagName IN (  'slack', 'slack-api', 'slack-commands','slack-block-kit',  'slack-dialog')  AND CASE WHEN Votes.CreationDate IS NOT NULL THEN CONCAT(YEAR(Votes.CreationDate), '-', RIGHT('0' + CONVERT(varchar(10), MONTH(Votes.CreationDate)), 2) , '-01') ELSE CONCAT(YEAR(Posts.CreationDate), '-', RIGHT('0' + CONVERT(varchar(10), MONTH(Posts.CreationDate)), 2) , '-01') END  >= '2008-10-01' AND CASE WHEN Votes.CreationDate IS NOT NULL THEN CONCAT(YEAR(Votes.CreationDate), '-', RIGHT('0' + CONVERT(varchar(10), MONTH(Votes.CreationDate)), 2) , '-01')  ELSE CONCAT(YEAR(Posts.CreationDate), '-', RIGHT('0' + CONVERT(varchar(10), MONTH(Posts.CreationDate)), 2) , '-01') END  < '2012-03-01' UNION
SELECT '2012-04-01' as date, COUNT(DISTINCT(Posts.OwnerUserId)) FROM Posts LEFT JOIN Votes on Votes.PostId = Posts.Id LEFT JOIN PostTags on PostTags.PostId = Posts.Id LEFT JOIN Tags ON Tags.Id = PostTags.TagId WHERE Tags.TagName IN (  'slack', 'slack-api', 'slack-commands','slack-block-kit',  'slack-dialog')  AND CASE WHEN Votes.CreationDate IS NOT NULL THEN CONCAT(YEAR(Votes.CreationDate), '-', RIGHT('0' + CONVERT(varchar(10), MONTH(Votes.CreationDate)), 2) , '-01') ELSE CONCAT(YEAR(Posts.CreationDate), '-', RIGHT('0' + CONVERT(varchar(10), MONTH(Posts.CreationDate)), 2) , '-01') END  >= '2008-10-01' AND CASE WHEN Votes.CreationDate IS NOT NULL THEN CONCAT(YEAR(Votes.CreationDate), '-', RIGHT('0' + CONVERT(varchar(10), MONTH(Votes.CreationDate)), 2) , '-01')  ELSE CONCAT(YEAR(Posts.CreationDate), '-', RIGHT('0' + CONVERT(varchar(10), MONTH(Posts.CreationDate)), 2) , '-01') END  < '2012-04-01' UNION
SELECT '2012-05-01' as date, COUNT(DISTINCT(Posts.OwnerUserId)) FROM Posts LEFT JOIN Votes on Votes.PostId = Posts.Id LEFT JOIN PostTags on PostTags.PostId = Posts.Id LEFT JOIN Tags ON Tags.Id = PostTags.TagId WHERE Tags.TagName IN (  'slack', 'slack-api', 'slack-commands','slack-block-kit',  'slack-dialog')  AND CASE WHEN Votes.CreationDate IS NOT NULL THEN CONCAT(YEAR(Votes.CreationDate), '-', RIGHT('0' + CONVERT(varchar(10), MONTH(Votes.CreationDate)), 2) , '-01') ELSE CONCAT(YEAR(Posts.CreationDate), '-', RIGHT('0' + CONVERT(varchar(10), MONTH(Posts.CreationDate)), 2) , '-01') END  >= '2008-10-01' AND CASE WHEN Votes.CreationDate IS NOT NULL THEN CONCAT(YEAR(Votes.CreationDate), '-', RIGHT('0' + CONVERT(varchar(10), MONTH(Votes.CreationDate)), 2) , '-01')  ELSE CONCAT(YEAR(Posts.CreationDate), '-', RIGHT('0' + CONVERT(varchar(10), MONTH(Posts.CreationDate)), 2) , '-01') END  < '2012-05-01' UNION
SELECT '2012-06-01' as date, COUNT(DISTINCT(Posts.OwnerUserId)) FROM Posts LEFT JOIN Votes on Votes.PostId = Posts.Id LEFT JOIN PostTags on PostTags.PostId = Posts.Id LEFT JOIN Tags ON Tags.Id = PostTags.TagId WHERE Tags.TagName IN (  'slack', 'slack-api', 'slack-commands','slack-block-kit',  'slack-dialog')  AND CASE WHEN Votes.CreationDate IS NOT NULL THEN CONCAT(YEAR(Votes.CreationDate), '-', RIGHT('0' + CONVERT(varchar(10), MONTH(Votes.CreationDate)), 2) , '-01') ELSE CONCAT(YEAR(Posts.CreationDate), '-', RIGHT('0' + CONVERT(varchar(10), MONTH(Posts.CreationDate)), 2) , '-01') END  >= '2008-10-01' AND CASE WHEN Votes.CreationDate IS NOT NULL THEN CONCAT(YEAR(Votes.CreationDate), '-', RIGHT('0' + CONVERT(varchar(10), MONTH(Votes.CreationDate)), 2) , '-01')  ELSE CONCAT(YEAR(Posts.CreationDate), '-', RIGHT('0' + CONVERT(varchar(10), MONTH(Posts.CreationDate)), 2) , '-01') END  < '2012-06-01' UNION
SELECT '2012-07-01' as date, COUNT(DISTINCT(Posts.OwnerUserId)) FROM Posts LEFT JOIN Votes on Votes.PostId = Posts.Id LEFT JOIN PostTags on PostTags.PostId = Posts.Id LEFT JOIN Tags ON Tags.Id = PostTags.TagId WHERE Tags.TagName IN (  'slack', 'slack-api', 'slack-commands','slack-block-kit',  'slack-dialog')  AND CASE WHEN Votes.CreationDate IS NOT NULL THEN CONCAT(YEAR(Votes.CreationDate), '-', RIGHT('0' + CONVERT(varchar(10), MONTH(Votes.CreationDate)), 2) , '-01') ELSE CONCAT(YEAR(Posts.CreationDate), '-', RIGHT('0' + CONVERT(varchar(10), MONTH(Posts.CreationDate)), 2) , '-01') END  >= '2008-10-01' AND CASE WHEN Votes.CreationDate IS NOT NULL THEN CONCAT(YEAR(Votes.CreationDate), '-', RIGHT('0' + CONVERT(varchar(10), MONTH(Votes.CreationDate)), 2) , '-01')  ELSE CONCAT(YEAR(Posts.CreationDate), '-', RIGHT('0' + CONVERT(varchar(10), MONTH(Posts.CreationDate)), 2) , '-01') END  < '2012-07-01' UNION
SELECT '2012-08-01' as date, COUNT(DISTINCT(Posts.OwnerUserId)) FROM Posts LEFT JOIN Votes on Votes.PostId = Posts.Id LEFT JOIN PostTags on PostTags.PostId = Posts.Id LEFT JOIN Tags ON Tags.Id = PostTags.TagId WHERE Tags.TagName IN (  'slack', 'slack-api', 'slack-commands','slack-block-kit',  'slack-dialog')  AND CASE WHEN Votes.CreationDate IS NOT NULL THEN CONCAT(YEAR(Votes.CreationDate), '-', RIGHT('0' + CONVERT(varchar(10), MONTH(Votes.CreationDate)), 2) , '-01') ELSE CONCAT(YEAR(Posts.CreationDate), '-', RIGHT('0' + CONVERT(varchar(10), MONTH(Posts.CreationDate)), 2) , '-01') END  >= '2008-10-01' AND CASE WHEN Votes.CreationDate IS NOT NULL THEN CONCAT(YEAR(Votes.CreationDate), '-', RIGHT('0' + CONVERT(varchar(10), MONTH(Votes.CreationDate)), 2) , '-01')  ELSE CONCAT(YEAR(Posts.CreationDate), '-', RIGHT('0' + CONVERT(varchar(10), MONTH(Posts.CreationDate)), 2) , '-01') END  < '2012-08-01' UNION
SELECT '2012-09-01' as date, COUNT(DISTINCT(Posts.OwnerUserId)) FROM Posts LEFT JOIN Votes on Votes.PostId = Posts.Id LEFT JOIN PostTags on PostTags.PostId = Posts.Id LEFT JOIN Tags ON Tags.Id = PostTags.TagId WHERE Tags.TagName IN (  'slack', 'slack-api', 'slack-commands','slack-block-kit',  'slack-dialog')  AND CASE WHEN Votes.CreationDate IS NOT NULL THEN CONCAT(YEAR(Votes.CreationDate), '-', RIGHT('0' + CONVERT(varchar(10), MONTH(Votes.CreationDate)), 2) , '-01') ELSE CONCAT(YEAR(Posts.CreationDate), '-', RIGHT('0' + CONVERT(varchar(10), MONTH(Posts.CreationDate)), 2) , '-01') END  >= '2008-10-01' AND CASE WHEN Votes.CreationDate IS NOT NULL THEN CONCAT(YEAR(Votes.CreationDate), '-', RIGHT('0' + CONVERT(varchar(10), MONTH(Votes.CreationDate)), 2) , '-01')  ELSE CONCAT(YEAR(Posts.CreationDate), '-', RIGHT('0' + CONVERT(varchar(10), MONTH(Posts.CreationDate)), 2) , '-01') END  < '2012-09-01' UNION
SELECT '2012-10-01' as date, COUNT(DISTINCT(Posts.OwnerUserId)) FROM Posts LEFT JOIN Votes on Votes.PostId = Posts.Id LEFT JOIN PostTags on PostTags.PostId = Posts.Id LEFT JOIN Tags ON Tags.Id = PostTags.TagId WHERE Tags.TagName IN (  'slack', 'slack-api', 'slack-commands','slack-block-kit',  'slack-dialog')  AND CASE WHEN Votes.CreationDate IS NOT NULL THEN CONCAT(YEAR(Votes.CreationDate), '-', RIGHT('0' + CONVERT(varchar(10), MONTH(Votes.CreationDate)), 2) , '-01') ELSE CONCAT(YEAR(Posts.CreationDate), '-', RIGHT('0' + CONVERT(varchar(10), MONTH(Posts.CreationDate)), 2) , '-01') END  >= '2008-10-01' AND CASE WHEN Votes.CreationDate IS NOT NULL THEN CONCAT(YEAR(Votes.CreationDate), '-', RIGHT('0' + CONVERT(varchar(10), MONTH(Votes.CreationDate)), 2) , '-01')  ELSE CONCAT(YEAR(Posts.CreationDate), '-', RIGHT('0' + CONVERT(varchar(10), MONTH(Posts.CreationDate)), 2) , '-01') END  < '2012-10-01' UNION
SELECT '2012-11-01' as date, COUNT(DISTINCT(Posts.OwnerUserId)) FROM Posts LEFT JOIN Votes on Votes.PostId = Posts.Id LEFT JOIN PostTags on PostTags.PostId = Posts.Id LEFT JOIN Tags ON Tags.Id = PostTags.TagId WHERE Tags.TagName IN (  'slack', 'slack-api', 'slack-commands','slack-block-kit',  'slack-dialog')  AND CASE WHEN Votes.CreationDate IS NOT NULL THEN CONCAT(YEAR(Votes.CreationDate), '-', RIGHT('0' + CONVERT(varchar(10), MONTH(Votes.CreationDate)), 2) , '-01') ELSE CONCAT(YEAR(Posts.CreationDate), '-', RIGHT('0' + CONVERT(varchar(10), MONTH(Posts.CreationDate)), 2) , '-01') END  >= '2008-10-01' AND CASE WHEN Votes.CreationDate IS NOT NULL THEN CONCAT(YEAR(Votes.CreationDate), '-', RIGHT('0' + CONVERT(varchar(10), MONTH(Votes.CreationDate)), 2) , '-01')  ELSE CONCAT(YEAR(Posts.CreationDate), '-', RIGHT('0' + CONVERT(varchar(10), MONTH(Posts.CreationDate)), 2) , '-01') END  < '2012-11-01' UNION
SELECT '2012-12-01' as date, COUNT(DISTINCT(Posts.OwnerUserId)) FROM Posts LEFT JOIN Votes on Votes.PostId = Posts.Id LEFT JOIN PostTags on PostTags.PostId = Posts.Id LEFT JOIN Tags ON Tags.Id = PostTags.TagId WHERE Tags.TagName IN (  'slack', 'slack-api', 'slack-commands','slack-block-kit',  'slack-dialog')  AND CASE WHEN Votes.CreationDate IS NOT NULL THEN CONCAT(YEAR(Votes.CreationDate), '-', RIGHT('0' + CONVERT(varchar(10), MONTH(Votes.CreationDate)), 2) , '-01') ELSE CONCAT(YEAR(Posts.CreationDate), '-', RIGHT('0' + CONVERT(varchar(10), MONTH(Posts.CreationDate)), 2) , '-01') END  >= '2008-10-01' AND CASE WHEN Votes.CreationDate IS NOT NULL THEN CONCAT(YEAR(Votes.CreationDate), '-', RIGHT('0' + CONVERT(varchar(10), MONTH(Votes.CreationDate)), 2) , '-01')  ELSE CONCAT(YEAR(Posts.CreationDate), '-', RIGHT('0' + CONVERT(varchar(10), MONTH(Posts.CreationDate)), 2) , '-01') END  < '2012-12-01' UNION
SELECT '2013-01-01' as date, COUNT(DISTINCT(Posts.OwnerUserId)) FROM Posts LEFT JOIN Votes on Votes.PostId = Posts.Id LEFT JOIN PostTags on PostTags.PostId = Posts.Id LEFT JOIN Tags ON Tags.Id = PostTags.TagId WHERE Tags.TagName IN (  'slack', 'slack-api', 'slack-commands','slack-block-kit',  'slack-dialog')  AND CASE WHEN Votes.CreationDate IS NOT NULL THEN CONCAT(YEAR(Votes.CreationDate), '-', RIGHT('0' + CONVERT(varchar(10), MONTH(Votes.CreationDate)), 2) , '-01') ELSE CONCAT(YEAR(Posts.CreationDate), '-', RIGHT('0' + CONVERT(varchar(10), MONTH(Posts.CreationDate)), 2) , '-01') END  >= '2008-10-01' AND CASE WHEN Votes.CreationDate IS NOT NULL THEN CONCAT(YEAR(Votes.CreationDate), '-', RIGHT('0' + CONVERT(varchar(10), MONTH(Votes.CreationDate)), 2) , '-01')  ELSE CONCAT(YEAR(Posts.CreationDate), '-', RIGHT('0' + CONVERT(varchar(10), MONTH(Posts.CreationDate)), 2) , '-01') END  < '2013-01-01' UNION
SELECT '2013-02-01' as date, COUNT(DISTINCT(Posts.OwnerUserId)) FROM Posts LEFT JOIN Votes on Votes.PostId = Posts.Id LEFT JOIN PostTags on PostTags.PostId = Posts.Id LEFT JOIN Tags ON Tags.Id = PostTags.TagId WHERE Tags.TagName IN (  'slack', 'slack-api', 'slack-commands','slack-block-kit',  'slack-dialog')  AND CASE WHEN Votes.CreationDate IS NOT NULL THEN CONCAT(YEAR(Votes.CreationDate), '-', RIGHT('0' + CONVERT(varchar(10), MONTH(Votes.CreationDate)), 2) , '-01') ELSE CONCAT(YEAR(Posts.CreationDate), '-', RIGHT('0' + CONVERT(varchar(10), MONTH(Posts.CreationDate)), 2) , '-01') END  >= '2008-10-01' AND CASE WHEN Votes.CreationDate IS NOT NULL THEN CONCAT(YEAR(Votes.CreationDate), '-', RIGHT('0' + CONVERT(varchar(10), MONTH(Votes.CreationDate)), 2) , '-01')  ELSE CONCAT(YEAR(Posts.CreationDate), '-', RIGHT('0' + CONVERT(varchar(10), MONTH(Posts.CreationDate)), 2) , '-01') END  < '2013-02-01' UNION
SELECT '2013-03-01' as date, COUNT(DISTINCT(Posts.OwnerUserId)) FROM Posts LEFT JOIN Votes on Votes.PostId = Posts.Id LEFT JOIN PostTags on PostTags.PostId = Posts.Id LEFT JOIN Tags ON Tags.Id = PostTags.TagId WHERE Tags.TagName IN (  'slack', 'slack-api', 'slack-commands','slack-block-kit',  'slack-dialog')  AND CASE WHEN Votes.CreationDate IS NOT NULL THEN CONCAT(YEAR(Votes.CreationDate), '-', RIGHT('0' + CONVERT(varchar(10), MONTH(Votes.CreationDate)), 2) , '-01') ELSE CONCAT(YEAR(Posts.CreationDate), '-', RIGHT('0' + CONVERT(varchar(10), MONTH(Posts.CreationDate)), 2) , '-01') END  >= '2008-10-01' AND CASE WHEN Votes.CreationDate IS NOT NULL THEN CONCAT(YEAR(Votes.CreationDate), '-', RIGHT('0' + CONVERT(varchar(10), MONTH(Votes.CreationDate)), 2) , '-01')  ELSE CONCAT(YEAR(Posts.CreationDate), '-', RIGHT('0' + CONVERT(varchar(10), MONTH(Posts.CreationDate)), 2) , '-01') END  < '2013-03-01' UNION
SELECT '2013-04-01' as date, COUNT(DISTINCT(Posts.OwnerUserId)) FROM Posts LEFT JOIN Votes on Votes.PostId = Posts.Id LEFT JOIN PostTags on PostTags.PostId = Posts.Id LEFT JOIN Tags ON Tags.Id = PostTags.TagId WHERE Tags.TagName IN (  'slack', 'slack-api', 'slack-commands','slack-block-kit',  'slack-dialog')  AND CASE WHEN Votes.CreationDate IS NOT NULL THEN CONCAT(YEAR(Votes.CreationDate), '-', RIGHT('0' + CONVERT(varchar(10), MONTH(Votes.CreationDate)), 2) , '-01') ELSE CONCAT(YEAR(Posts.CreationDate), '-', RIGHT('0' + CONVERT(varchar(10), MONTH(Posts.CreationDate)), 2) , '-01') END  >= '2008-10-01' AND CASE WHEN Votes.CreationDate IS NOT NULL THEN CONCAT(YEAR(Votes.CreationDate), '-', RIGHT('0' + CONVERT(varchar(10), MONTH(Votes.CreationDate)), 2) , '-01')  ELSE CONCAT(YEAR(Posts.CreationDate), '-', RIGHT('0' + CONVERT(varchar(10), MONTH(Posts.CreationDate)), 2) , '-01') END  < '2013-04-01'

Enter Parameters

Options:
Switch to meta site
loading Hold tight while we fetch your results