2

Please login or register to vote for this query.

(click on this box to dismiss)

Exclude any particular category of buzzword by setting its 'ignore' threshold to a large negative number.

Q&A for scientists, academics, teachers, and students in the field of chemistry

-- AnyScore: Ignore any question with score above:
-- DoubtScore: Ignore '*doubt*' titled questions with score above:
-- ConfusScore: Ignore '*confus*' titled questions with score above:
-- QuesScore: Ignore '*question*' titled questions with score above:
-- HelpScore: Ignore '*help*' titled questions with score above:
-- ProblemScore: Ignore '*problem*' titled questions with score above:
-- ChemScore: Ignore '*chem*' titled questions with score above:
-- ExptScore: Ignore '*experiment*' titled questions with score above:
-- ExerciseScore: Ignore '*exercise*' titled questions with score above:
-- CalcScore: Ignore '*calculat*' titled questions with score above:
-- ClosedQs: Include closed questions (Y/N)?
DECLARE @AnyScore int = ##AnyScore:int?1000000##
DECLARE @DoubtScore int = ##DoubtScore:int?2##
DECLARE @ConfusScore int = ##ConfusScore:int?2##
DECLARE @QuesScore int = ##QuesScore:int?2##
DECLARE @HelpScore int = ##HelpScore:int?2##
DECLARE @ProblemScore int = ##ProblemScore:int?2##
DECLARE @ChemScore int = ##ChemScore:int?2##
DECLARE @ExptScore int = ##ExptScore:int?2##
DECLARE @ExerciseScore int = ##ExerciseScore:int?2##
DECLARE @CalcScore int = ##CalcScore:int?2##
DECLARE @ClosedQs nvarchar = ##ClosedQs:string?N##

SELECT p.Id AS [Post Link], p.Score AS 'Score', p.Tags AS 'Tags',
    p.ClosedDate as 'Closed Date', p.AnswerCount as '# Answers'

FROM Posts p

WHERE p.PostTypeId = 1 AND
  (
    (CHARINDEX('DOUBT', UPPER(p.Title)) > 0 AND p.Score <= @DoubtScore) OR
    (CHARINDEX('CONFUS', UPPER(p.Title)) > 0 AND p.Score <= @ConfusScore) OR
    (CHARINDEX('QUESTION', UPPER(p.Title)) > 0 AND p.Score <= @QuesScore) OR
    (CHARINDEX('HELP', UPPER(p.Title)) > 0 AND p.Score <= @HelpScore) OR
    (CHARINDEX('PROBLEM', UPPER(p.Title)) > 0 AND p.Score <= @ProblemScore) OR
    (CHARINDEX('EXPERIMENT', UPPER(p.Title)) > 0 AND p.Score <= @ExptScore) OR
    (CHARINDEX('EXERCISE', UPPER(p.Title)) > 0 AND p.Score <= @ExerciseScore) OR
    (CHARINDEX(' CHEMISTR', UPPER(p.Title)) > 0 AND p.Score <= @ChemScore) OR
    (CHARINDEX(' CHEMIC', UPPER(p.Title)) > 0 AND p.Score <= @ChemScore) OR
    (CHARINDEX('CHEM', UPPER(p.Title)) = 1 AND p.Score <= @ChemScore) OR
    (CHARINDEX('CALCULAT', UPPER(p.Title)) > 0 AND p.Score <= @CalcScore)
    ) AND
    (p.ClosedDate IS NULL OR UPPER(@ClosedQs) = 'Y') AND
    (p.Score <= @AnyScore)
    
ORDER BY p.Score ASC

view current version

edited sep 29 17

created apr 6 17 hBy2Py