Which question titles could be improved?

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

CiviCRM

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

Enter Parameters

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