Q&A about the site for engineers, producers, editors, and enthusiasts spanning the fields of video, and media creation
/*select count(*) from (*/ SELECT Id, Title, ViewCount, Score, Tags FROM Posts WHERE PostTypeId=1 and AnswerCount > 0 and Tags like '%<javascript>%' and Title COLLATE Latin1_General_CI_AS like 'how %' and Title COLLATE Latin1_General_CI_AS not like 'how to %' and Title COLLATE Latin1_General_CI_AS like 'how do you %' and Title COLLATE Latin1_General_CI_AS not like 'how may %' and Title COLLATE Latin1_General_CI_AS not like 'how might %' and Title COLLATE Latin1_General_CI_AS not like 'how can %' and Title COLLATE Latin1_General_CI_AS not like 'how could %' and Title COLLATE Latin1_General_CI_AS not like 'how should %' ORDER BY ViewCount DESC /*) as T*/