0

Please login or register to vote for this query.

(click on this box to dismiss)

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*/

fork query

edited jul 1 20

created jul 1 20 anonymous