0

Please login or register to vote for this query.

(click on this box to dismiss)

Used to improve the quality of question titles on aviation.

Q&A about the site for practitioners of the art and science of signal, image and video processing

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

created mar 4 DeltaLima