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 for administrators and users of the CiviCRM Constituent Relationship Management software
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