2

Please login or register to vote for this query.

(click on this box to dismiss)

Find question titles that do not contain the Five Ws (Who, What, When, Where and why), interrogative words, and question marks. Used to maintain high quality standards on Aviation.stackexchange.com This query MAY be useful for identifying titles that aren't phrased as a question or low quality questions. Special thanks: Ambo100 & s.tk/users/398665

Q&A about the site for members of the workforce navigating the professional setting

SELECT Id
AS [Post Link], CreationDate as [Date], Score as [Score], AnswerCount as [Answers], 'Not a question' as [Category]
FROM Posts 
WHERE ((
Title not like '%Who %'
AND Title not like '%[Ww]hat %'
AND Title not like '%What''s %'
AND Title not like '%Who''s %'
AND Title not like '%When %'
AND Title not like '%[Ww]here %'
AND Title not like '%[Ww]ere %'
AND Title not like '%[Ww]hy %'
AND Title not like '%[Ww]ould %'
AND Title not like '%[Ww]ouldn''t %'
AND Title not like '%Could %'
AND Title not like '%[Ss]hould %'
AND Title not like '%[Ss]houldn''t %'
AND Title not like '%[Hh]ow %'
AND Title not like '%[Cc]an %'
AND Title not like '%[Ii]s %'
AND Title not like '%[Mm]ay %'
AND Title not like '%If %'
AND Title not like '%[Ww]hich %'
AND Title not like '%[Ww]as %'
AND Title not like '%[Aa]re %'
AND Title not like '%[Hh]as %'
AND Title not like '%[Ww]ill %'
AND Title not like '%[Ww]on''t %'
AND Title not like '%[Hh]ave %'
AND Title not like '%[Dd]o %'
AND Title not like '%[Dd]on''t %'
AND Title not like '%[Dd]oes %'
AND Title not like '%[Dd]oesn''t %'
AND Title not like '%[Dd]id %'
AND Title not like '%[Dd]idn''t %'
AND Title not like '%[Tt]o what extent%'
AND Title not like '%Am I %'
AND Title not like '%Must %'
) AND Title  not like '%?%')
AND ClosedDate is null 
UNION
SELECT Id
AS [Post Link], CreationDate as [Date], Score as [Score], AnswerCount as [Answers], 'No question mark' as [Category]
FROM Posts 
WHERE (not (
Title not like '%Who %'
AND Title not like '%[Ww]hat %'
AND Title not like '%What''s %'
AND Title not like '%Who''s %'
AND Title not like '%When %'
AND Title not like '%[Ww]here %'
AND Title not like '%[Ww]ere %'
AND Title not like '%[Ww]hy %'
AND Title not like '%[Ww]ould %'
AND Title not like '%[Ww]ouldn''t %'
AND Title not like '%Could %'
AND Title not like '%[Ss]hould %'
AND Title not like '%[Ss]houldn''t %'
AND Title not like '%[Hh]ow %'
AND Title not like '%[Cc]an %'
AND Title not like '%[Ii]s %'
AND Title not like '%[Mm]ay %'
AND Title not like '%If %'
AND Title not like '%[Ww]hich %'
AND Title not like '%[Ww]as %'
AND Title not like '%[Aa]re %'
AND Title not like '%[Hh]as %'
AND Title not like '%[Ww]ill %'
AND Title not like '%[Ww]on''t %'
AND Title not like '%[Hh]ave %'
AND Title not like '%[Dd]o %'
AND Title not like '%[Dd]on''t %'
AND Title not like '%[Dd]oes %'
AND Title not like '%[Dd]oesn''t %'
AND Title not like '%[Dd]id %'
AND Title not like '%[Dd]idn''t %'
AND Title not like '%[Tt]o what extent%'
AND Title not like '%Am I %'
AND Title not like '%Must %'
) AND Title  not like '%?%')
AND ClosedDate is null 
UNION
SELECT Id
AS [Post Link], CreationDate as [Date], Score as [Score], AnswerCount as [Answers], 'Question not clear (grammar)' as [Category]
FROM Posts 
WHERE ((
Title not like '%Who %'
AND Title not like '%[Ww]hat %'
AND Title not like '%What''s %'
AND Title not like '%Who''s %'
AND Title not like '%When %'
AND Title not like '%[Ww]here %'
AND Title not like '%[Ww]ere %'
AND Title not like '%[Ww]hy %'
AND Title not like '%[Ww]ould %'
AND Title not like '%[Ww]ouldn''t %'
AND Title not like '%Could %'
AND Title not like '%[Ss]hould %'
AND Title not like '%[Ss]houldn''t %'
AND Title not like '%[Hh]ow %'
AND Title not like '%[Cc]an %'
AND Title not like '%[Ii]s %'
AND Title not like '%[Mm]ay %'
AND Title not like '%If %'
AND Title not like '%[Ww]hich %'
AND Title not like '%[Ww]as %'
AND Title not like '%[Aa]re %'
AND Title not like '%[Hh]as %'
AND Title not like '%[Ww]ill %'
AND Title not like '%[Ww]on''t %'
AND Title not like '%[Hh]ave %'
AND Title not like '%[Dd]o %'
AND Title not like '%[Dd]on''t %'
AND Title not like '%[Dd]oes %'
AND Title not like '%[Dd]oesn''t %'
AND Title not like '%[Dd]id %'
AND Title not like '%[Dd]idn''t %'
AND Title not like '%[Tt]o what extent%'
AND Title not like '%Am I %'
AND Title not like '%Must %'
) AND Title  like '%?%')
AND ClosedDate is null 

ORDER BY CreationDate DESC

fork query

edited sep 20 19 Who?

created nov 4 14 Ambo100