0

Please login or register to vote for this query.

(click on this box to dismiss)

Q&A for science fiction and fantasy enthusiasts

--Set ##a## = 0 if you want all lotm languages
--Set ##a## = 1 if you want all lotm languages that you can have answers for if you want to be eligible for
--@Bubbler's bounty with no deadline from May 31, 2023
DECLARE @a INT
SET @a = ##a##
IF @a=0
SELECT p.Id AS [Post Link],p.PostTypeId, u.DisplayName, p.CreationDate, p.Score, p.Tags
FROM Posts p
INNER JOIN Users u ON p.OwnerUserId = u.Id
WHERE p.PostTypeId = 1
AND p.Tags LIKE '%language-of-the-month%'
AND NOT p.PostTypeId = 10
AND NOT p.PostTypeId = 14
AND NOT p.Tags LIKE '%status-completed%'
AND NOT p.Tags LIKE '%status-declined%'
AND NOT p.Tags LIKE '%feature-request%'
AND NOT p.Tags LIKE '%meta%'
AND NOT p.Title LIKE '%dead%'
AND NOT p.Title LIKE '%event%'
AND NOT p.Title LIKE '%Reviving%'
AND NOT p.Title LIKE '%Nominations%'
ORDER BY 4 DESC
ELSE IF @a=1
SELECT p.Id AS [Post Link],p.PostTypeId,u.DisplayName,p.CreationDate,p.Score,p.Tags
FROM Posts p
INNER JOIN Users u ON p.OwnerUserId = u.Id
WHERE p.PostTypeId = 1
AND p.Tags LIKE '%language-of-the-month%'
AND NOT p.PostTypeId = 10
AND NOT p.PostTypeId = 14
AND NOT p.Tags LIKE '%status-completed%'
AND NOT p.Tags LIKE '%status-declined%'
AND NOT p.Tags LIKE '%feature-request%'
AND NOT p.Tags LIKE '%meta%'
AND NOT p.Title LIKE '%dead%'
AND NOT p.Title LIKE '%event%'
AND NOT p.Title LIKE '%Reviving%'
AND NOT p.Title LIKE '%Nominations%'
AND NOT p.Title LIKE '%Whispers%'
AND NOT p.Title LIKE '%Vyxal%'
ORDER BY 4 DESC
ELSE SELECT 'Error'

fork query

edited may 14

created may 14 CrSb0001